Amazon Redshift is a columnar OLAP database compatible with PostgreSQL. To connect Redshift to Spice, use the PostgreSQL data connector (opens in a new tab) and specify the Redshift cluster connection parameters.
fromUse the format postgres:schema.table to reference a Redshift table. The connector parameters should match your Redshift cluster settings.
| Parameter Name | Description |
|---|---|
pg_connection_string | Optional. A PostgreSQL connection string (opens in a new tab). Overrides individual connection parameters when provided. |
pg_host | Hostname or IP address of the Redshift cluster |
pg_port | The PostgreSQL TCP port. Redshift uses port 5439 by default — set this explicitly. |
pg_db | Database name |
pg_user | Username for authentication |
pg_pass | Password for authentication (use secret reference) |
pg_sslmode | SSL mode. Default verify-full. Supported values: disable, prefer, require, verify-ca, verify-full. |
pg_sslrootcert | Optional. Path to a custom root certificate for SSL verification |
pg_connection_pool_min_idle | Optional. The minimum number of idle connections to keep open in the pool. Default is 1. |
connection_pool_size | Optional. The maximum number of connections in the connection pool. Default is 5. |
Redshift types are mapped to PostgreSQL types. See the PostgreSQL connector documentation (opens in a new tab) for details on supported types and configuration.
Spice integrates with multiple secret stores to help manage sensitive data securely. For details, see the secret stores documentation (opens in a new tab) and using referenced secrets guide (opens in a new tab).