Some time ago we wrote a post with the ultimate list of custom dashboards and BI tools. Then connecting a BI tool in an Amazon Redshift cluster is usually, straightforward. It is of most importance to get all your data in Redshift first. It is Open Source universal database tool.Ĭlick here to get our FREE 90+ page PDF Amazon Redshift Guide! Which BI tools can I use to connect a BI tool to Amazon Redshift? RazorSQL ships with the JDBC drivers necessary to connect to Amazon Redshift. JackDB is an SQL IDE that works with PostgreSQL, Amazon Redshift and more. You can download from it’s official site. It is a Mac native and supports database systems derived from PostgreSQL like Amazon Redshift. It has a simple interface that works nicely.

Read how to connect to Amazon Redshift from here.

Read how to connect to Amazon Redshift here.Ī Windows based, Amazon Redshift specific IDE.

Navicat offers many flavors this is a compact version of Navicat. It is all time classic in the PostgreSQL community and its latest version (as of today) pgAdmin 4, is a complete rewrite of pgAdmin, built using Python and Javascript/jQuery.

Follow these instructions on how to connect to your Amazon Redshift cluster with the psql tool with this guide from Amazon.

You will need your Amazon Redshift cluster endpoint, database, and port to connect. Psql is a terminal-based front end from PostgreSQL, and it is pretty straightforward to use. You may also connect with psql to an Amazon Redshift cluster. Follow these instructions on how to connect to your Amazon Redshift cluster over a JDBC Connection in SQL Workbench/J from Amazon here.Read the Installing and starting SQL Workbench/J page.Download SQL Workbench/J from SQL Workbench.SQL Workbench/JĪmazon in their guide uses SQL Workbench/J. Though you can connect to your cluster using psql or any SQL IDE that supports PostgreSQL JDBC or ODBC drivers. Which SQL IDE is the best to connect to AWS Redshift?Īmazon does not provide any SQL client tools, but they recommend SQL Workbench/J.

Best sql client for mac