Amazon Redshift
Connect to Redshift.
Configuration
The following values are needed to connect to Redshift:
- Address: endpoint address of the Redshift cluster
- Database: database name to pull tables from
- Username: user to authenticate as
- Password: password used to authenticate
Datasets
By default, each table in the database will be automatically indexed as a dataset within Predibase.
Connection Query Template
CREATE CONNECTION redshift_connection
CONNECTION_TYPE = REDSHIFT
DATABASE_ADDRESS = 'examplecluster.abc123xyz789.us-west-2.redshift.amazonaws.com:5439'
DATABASE_NAME = 'database'
USERNAME = 'username'
PASSWORD = 'password'