Redshift

The Redshift integration works by uploadig data to an S3 bucket, and then loading that data into the database. Thus, the configuration needs both an S3 bucket to write to and a database conection string.

databases:
  - type: redshift
    api_keys:
      - test_api_key
    settings:
      # Redshift connection
      redshift_host: myredshiftcluster.amazonaws.com 
      redshift_port: 5439 
      redshift_user: myuser 
      redshift_password: mypassword 
      redshift_dbname: mydb
      # S3 bucket
      s3_region: "us-east-1"
      s3_access_key_id: "ACCESS_KEY_ID"
      s3_secret_access_key: "SECRET_ACCESS_KEY"
      s3_bucket: "bucket_name"