Skip to main content

Redshift

To add an Amazon Redshift data source you only need the credentials and info of the data you want to import, there are 2 ways: User + Password or IAM role.

To add a new data source go to Settings > Data Sources > Add new data source and select Redshift. Remember only admins can access worksapce settings. Let’s see how to make the connection:

Configuration​

There are 2 ways to configure Redshift, User/Password or IAM role. Let’s see the process for both:

User/Password configuration​

  1. Fill in the required fields

    • Alias → (Required) The name you'll see for this source in Latitude. This doesn’t affect anything in your database.
    • User → (Required) The user credentials to authenticate in your database.
    • Password → (Required) The password to authenticate in your database.
    • Host → (Required) The host for the database connection, which can be expressed as either an IP address or a domain.
    • Port → (Required) The port number for the connection. If you don’t have a port assigned the default port number of Amazon Redshift is 5439.
    • Database → (Required) The exact name of the database that contains the data you want to sync.

  1. Click on Add data source to save the configuration

  2. Now, it's time to check that everything was set up correctly. Go to a project, add a Redshift data source and check that you get results

IAM role configuration​

  1. Fill in the required fields

    • Access Key → (Required) The credential that gives you access to your resources in Amazon Web Services. Check here how to get your Access Key.

    • Secret Access Key → (Required) The password that authenticates you to access your resources in Amazon Web Services. Check here how to get your Secret Access Key.

    • Region → (Required) The location where your Redshift is configured. The format is [continent]-[position]-[number]. For example, eu-central-1.

      1. Open Redshift.

      2. Click the location at the top right.

      3. Check the location selected at the right. You will see the region.

    • Database → (Required) The exact name of the database that contains the data you want to sync.

  1. Click on Add data source to save the configuration

  2. Now, it's time to check that everything was set up correctly. Go to a project, add a Redshift data source and check that you get results

Generate the Access Key and Secret Access Key​

If you don’t have an Access Key you need permission to use the IAM console to generate one. Otherwise, request permissions or ask your AWS account administrator for this information.

  1. Open the IAM console at https://console.aws.amazon.com/iam/.

  2. From the navigation menu, select Users

  3. Select your IAM username (not the checkbox)

  4. Open the Security credentials tab

  5. Scroll down to the Access Keys section

  6. Choose the Create access key.

  7. Select the Application running outside AWS option and click Next

  8. The Set description tag step is optional, click on Create Access key

  9. Now the Retrieve access keys will appear with the Access Key and Secret Access Key. You can also, you can download the information in .csv format so that you don't lose it.

    • Access key ID example: AKIAIOSFODNN7EXAMPLE
    • Secret access key example: wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMPLEKEY
    info

    ☝ If you lose or forget your secret access key, you cannot retrieve it. You will need to create a new one.