Redshift

Connect to a Redshift database

Setup

The following credentials keys are accepted:

• host (required) -> The hostname / ip of the instance

• user (required) -> he username to access the instance

• database (required) -> The database name of the instance

• aws_bucket (required) -> The name of the S3 Bucket for Bulk Loading / Unloading

• aws_access_key_id (required) -> The AWS Access Key ID to access the bucket for Bulk Loading / Unloading

• aws_secret_access_key (required) -> The AWS Secret Key to access the bucket for Bulk Loading / Unloading

• schema (optional) -> The default schema to use when loading

• password (optional) -> The password to access the instance

• port (optional) -> The port of the instance. Default is 5439.

Here is an example of setting a connection named REDSHIFT:

# YAML format
export REDSHIFT="{type: redshift, host: <host>, user: <user>, database: <database>, password: <password>, port: <port>, sslmode: require}, aws_bucket: <aws_bucket>, aws_access_key_id: <aws_access_key_id>, aws_secret_access_key: <aws_secret_access_key>"
export REDSHIFT="{type: redshift, url: 'redshift://myuser:[e-mail]:5439/mydatabase', aws_bucket: <aws_bucket>, aws_access_key_id: <aws_access_key_id>, aws_secret_access_key: <aws_secret_access_key>}"