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.

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