Skip to main content
TablePro connects to Amazon Redshift using the same libpq driver as PostgreSQL, plus Redshift-specific metadata queries for distribution style, sort keys, and table size. The PostgreSQL page applies unless noted here.

​
Connection Settings

Fill in the form and click Save & Connect.
AWS IAM authentication is not available for Redshift connections (unlike MySQL and PostgreSQL). Use the cluster’s database username and password.

​
Connection URL

See Connection URL Reference.

​
Features

Schemas: like PostgreSQL, default schema public. Table metadata comes from svv_table_info: distribution style, sort keys, and table size. External schemas: schemas created with CREATE EXTERNAL SCHEMA are listed alongside regular ones and marked External. This covers Redshift Spectrum over S3, federated query to Aurora, RDS, and MySQL, cross-database references, and datashare consumers. Their tables appear under the schema with an external icon. External tables are read-only. Redshift does not support UPDATE or DELETE on them and they have no primary key, so the data grid disables cell editing, adding rows, and deleting rows. Reading works as usual: browse, filter, sort, and export. Row counts are not shown, because svv_table_info does not cover external tables. Databases: dev, the database created with every cluster, is listed like any other. Only padb_harvest is marked as a system database. DDL: table definitions include DISTKEY, SORTKEY, DISTSTYLE, and ENCODE directives. Foreign keys display as informational; Redshift does not enforce them.
Redshift table info showing distribution style and sort keys

Distribution style and sort keys in table info

Backup & Restore: Backup Dump and Restore Dump run pg_dump and pg_restore for Redshift. See Backup & Restore. Import & Export: export to CSV, JSON, SQL, or XLSX. Import from CSV, JSON, or SQL. See Import & Export.

​
Structure Editing

TablePro disables the structure-editing UI for Redshift: no column, index, or key changes from the structure tab. Run ALTER TABLE statements in the SQL editor instead.

​
Limitations

Redshift is a columnar warehouse, not a general-purpose RDBMS.
  • No traditional indexes. Redshift uses DISTKEY and SORTKEY instead.
  • No enums, sequences, or triggers.
  • Foreign keys are informational. Redshift does not enforce them.
  • No Maintenance menu. Run VACUUM and ANALYZE from the SQL editor.
  • External tables cannot be edited, and have no row count. Column types show as the external catalog reports them, such as varchar(65535) or array<varchar(20)>.

​
Troubleshooting

Connection refused: check the security group allows port 5439, the cluster is publicly accessible (or use an SSH tunnel), and the cluster is not paused. Auth failed: verify the master username and password in the AWS Console. Slow queries: check distribution with SELECT * FROM svv_table_info WHERE "table" = 'your_table', run ANALYZE to update stats, and match SORTKEY to your WHERE/JOIN predicates.