Magento Business Intelligence Help Center

Compatible SQL Clients for PDW

JUMP TO

BROUGHT TO YOU BY

Avatar

Amazon recommends using SQL Workbench/J to connect to and query Redshift, but you can also use the 8.x version of the PostgreSQL query tool psql or any SQL client that supports PostgreSQL JDBC or ODBC drivers. We’ve listed a handful of compatible clients below. To go back to the Amazon Redshift Prerequisite Setup article, click here.

Note that Amazon Redshift is based on PostgreSQL 8.0.2.

Client Operating System Classification
SQuirreL Windows/Linux/Mac OS X Open Source
DBeaver Windows/Linux/Mac OS X Open Source
PG Commander Mac OS X Proprietary
Aginity Workbench for Redshift Windows Proprietary, Free
Navicat Windows/Linux/Mac OS X Proprietary
RazorSQL Windows/Linux/Mac OS X Proprietary
JackDB Windows/Linux/Mac OS X Proprietary
0xDBE (in preview) Windows/Linux/Mac OS X Proprietary
Aqua Data Studio Windows/Linux/Mac OS X Proprietary
Was this article helpful?
0 out of 0 found this helpful

Comments

Powered by Zendesk