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'