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:
| Field | Value |
|---|---|
| Database type | Amazon Redshift |
| Database IP or hostname | The cluster's or workgroup's endpoint, without the port and database, for example examplecluster.abc123.us-east-1.redshift.amazonaws.com. |
| Port | 5439, Redshift's default. |
| Database name | The 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
EXPLAINhas no JSON plan. RunEXPLAINas 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.