Redshift

Source and destination

Redshift as a source

To use Redshift as a source, you only need to supply read-access to the database.

  1. In Polytomic, go to ConnectionsAdd ConnectionRedshift.

  2. Enter host and credential details

Note: The AWS Access Key/Secret Key and Bucket configuration are only required if you plan to use Redshift as a destination. If you only plan to read from Redshift, you can leave these fields blank.

Redshift as a destination

If you wish to write to Redshift, there are two requirements:

  1. A user with write permission to the table/schemas that you want to load data into
  2. An S3 bucket in the same region as your Redshift server and an Access Key/Secret Key with read/write access to the bucket. Polytomic will use these credentials to:
  • Write intermediary load files to the bucket
  • Instruct Redshift to load from the same bucket

Files are removed as each load job completes - the bucket is only used as a staging area inside your own AWS account as we load files into your Redshift cluster. While Polytomic will make an effort to clean up intermediary files, it is wise to set a file retention policy on the bucket to periodically delete or archive files.

Once you have set up a user and an S3 bucket with an Access Key/Secret Key pair, input the details in the connection Configuration.