Amazon Redshift

Amazon Redshift is its own database type in QueryDesk, for provisioned clusters and Redshift Serverless. It speaks the PostgreSQL protocol, so data protection and peer reviews work as they do on PostgreSQL, with Redshift's own catalog and SQL.

Connect a cluster

Add the database as in Connect a database, with these values:

FieldValue
Database typeAmazon Redshift
Database IP or hostnameThe cluster's or workgroup's endpoint, without the port and database, for example examplecluster.abc123.us-east-1.redshift.amazonaws.com.
Port5439, Redshift's default.
Database nameThe database to query, for example dev.

Redshift requires TLS for most clusters, so turn on Encryption. A redshift:// or postgres:// connection string pasted under Update with connection string keeps the Amazon Redshift type.

A cluster in a private subnet is reached through a Tunnel.

Click Test Connection under the credential to check the connection.

What works differently

  • Analyze isn't available: Redshift's EXPLAIN has no JSON plan. Run EXPLAIN as a query to see its plan.
  • AI read-only runs an AI query's statements in one transaction opened with BEGIN READ ONLY, which is always rolled back.
  • IAM authentication isn't supported yet. Use a database user and password.

Was this page helpful?