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_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_sslmode | SSL mode (e.g., prefer) |
pg_db | Database name |
pg_user | Username for authentication |
pg_pass | Password for authentication (use secret reference) |
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).