Skip to main content

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'