Documentation / Product / Integrations / Amazon Web Services / Amazon Redshift

Amazon Redshift: Authorization

If you haven't already done so, you will need to set up an Amazon Web Services (AWS) account before you begin the process described below. See the Redshift Getting Started Guide to get started with Amazon Redshift. You will also have to add Lytic's IPs to your cluster's ingress rules. Contact your Account Manager for the current list of Lytics' IP addresses.

There are two Redshift Authorization Types:

Redshift Only

To set up AWS Redshift User you will need the following credentials: database username and password. See the Redshift Users Guide for instructions on how to create a user in Amazon Redshift. If you are new to creating authorizations in Lytics, see the Authorizations Dashboard documentation for more information.

  1. Select Amazon Web Services (AWS) from the list of providers.
  2. Select the AWS Redshift User method for authorization.
  3. Enter a Label to identify your authorization.
  4. (Optional) Enter a Description for further context on your authorization.
  5. In the Username text box, enter your Redshift cluster admin user name.
  6. In the Password password box, enter your Redshift cluster admin password.
  7. (Optional) In the DB URL text box, enter your Redshift database endpoint. Follow these instructions to obtain your DB URL; copy the Endpoint from the general information page (the area as the JDBC URL in the Amazon instructions). This will be of the form: redshift-cluster-name.VCP-cluster.region.redshift.amazonaws.com:port/db-name. If left blank the import will need to have the DB URL set in the job configuration.
  8. (Optional) From the SSL mode input, select your SSL mode credential. Leave blank to disable SSL verification.

  9. Click Save Authorization.

    aws-redshift-auth

Redshift and S3

To setup the AWS S3 Keys And Redshift User you will need the following credentials:

  • Redshift database username
  • Redshift database password
  • S3 access key ID
  • S3 secret key
  • Redshift database URL

See the Redshift Users Guide for instructions on how to create a user in Amazon Redshift. If you are new to creating authorizations in Lytics, see the Authorizations Dashboard documentation for more information.

  1. In the Label text box, enter a name for the authorization.
  2. (optional) In the Description text box, enter a description for this authorization.
  3. In the S3 Access Key text box, enter your S3 Access Key credential.
  4. In the S3 Secret Key password box, enter your S3 Secret Key credential.
  5. In the Redshift Username text box, enter your Redshift Username credential.
  6. In the Redshift Password password box, enter your Redshift Password credential.
  7. In the Redshift DB URL text box, enter your Redshift DB URL credential. Follow these instructions to obtain your DB URL; copy the Endpoint from the general information page (the area as the JDBC URL in the Amazon instructions). This will be of the form: redshift-cluster-name.VCP-cluster.region.redshift.amazonaws.com:port/db-name.
  8. From the Redshift SSL mode input, select your Redshift SSL mode credential.