Creating an Amazon Redshift Connection

In order to pull data from the Amazon Redshift API, you must first create a connection. This will grant Conversionomics the authentication it needs to access the API.

To create a connection, first navigate to the desired organization, press your profile icon in the top right of the page, and click  Connections.

Once you are in the Connections page, press the + New Connection button.

In the popup, select Amazon Redshift for the connection type and press continue.

You will then be shown the connection configuration popup.

From here, you will need to fill out each of the following inputs:

  • Connection Name: The name you wish to give the connection
  • Database: Name of your database that is connected with your AWS account
  • Host: Your url or IP address where the database service is running.
  • Username: The redshift user you wish to link the connection to
  • Password: The password associated to the selected Username
  • Port: Identification number of the database service showed in your AWS administration console.
  • Access Key: Identification ID of your AWS account. you can get more about it at this link.
  • Secret key: generated string in your AWS account used to sign programmatic requests that you make to AWS
  • Bucket Region: AWS region where you created your storage bucket (AWS region that is geographically close to you to optimize latency, minimize costs, or address regulatory requirements)

Once everything has been filled out, press Save and your connection will be created and ready to be used.

Still need help? Contact Us Contact Us