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_host | Hostname or IP address of the Redshift cluster |
pg_port | Port for Redshift (default: 5439) |
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 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.