Amazon Redshift is a columnar OLAP database compatible with PostgreSQL. To connect Redshift to Spice, use the PostgreSQL data connector 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. 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 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 and using referenced secrets guide.