Amazon Redshift
Read and write Amazon Redshift: provisioned clusters and Serverless workgroups both speak the PostgreSQL wire protocol, so there is no driver to install. Press Refresh columns on a node and the builder shows a query's columns, never automatically, because Serverless resumes and bills on connect.
Settings
What the connection form asks for. Every connection has a Staging side, which it needs, and an optional Production side with values of its own; both ask for the same settings.
| Host | |
| Port | |
| Database | |
| Username | |
| Password | Stored encrypted, and never shown again after you save it. |
| Encryption | Managed services (Amazon RDS and Aurora, Cloud SQL, Azure Database) accept verify-full with no extra setup. Use require for a server with a self-signed certificate. Choices: Require encryption; Require encryption, verify certificate and hostname; Require encryption, verify certificate; Encrypt if the server offers it; No encryption. |
Testing the connection
Test connects, signs in and runs SELECT 1. It waits up to 20 seconds, because a Serverless workgroup resumes when something connects.
Good to know
- Provisioned clusters and Serverless workgroups both work, with no driver to install.
- A node reads its columns only when you press Refresh columns, never while you type, because connecting resumes a Serverless workgroup and starts its billing.
Nodes that use it
Read a table or SQL query from Amazon Redshift. A Bookmark can read only the rows added or changed since the last successful run.
Load rows into an Amazon Redshift table (append, replace, or upsert). Best for small and medium loads. The load is one transaction by default, so a load that fails leaves the table as it was.