Skip to main content

Amazon Redshift

Integrating Amazon Redshift with Osano​

Connecting to Amazon Redshift​

In order for Osano to discover data stored in your systems, we must connect to those data providers via an API. We require, at minimum, read-only access to establish a connection to these providers. Each provider you connect may require different information. Please see the linked vendor documentation for instructions on where and how to obtain this data.

Prerequisites​

Redshift Cluster Identifier​
  • To get the identifier of the Redshift cluster from the AWS management console,
    • Navigate to "Redshift" in the AWS Management Console.
    • In the navigation pane, choose "Clusters".
    • Select the cluster you want to connect to.
    • The cluster identifier is displayed in the "Cluster Identifier" column.
Secret ARN​
  • Follow the instructions to store your credentials in a secret for an Amazon redshift cluster.
    • Ensure the secret has the proper permissions to access the Redshift cluster.
    • To get the password for your Redshift database, enter this into your AWS CLI:
      • aws secretsmanager get-secret-value --secret-id <Admin password ARN> where the Admin password ARN can be found in the Redshift Cluster -> properties -> Database configurations.
  • To get the secret ARN, please go to the AWS Secrets Manager and copy the ARN of the secret that contains the credentials for the Redshift cluster.
AWS Credentials​

  • Create an IAM user and attach the following custom policy and the AWS managed Policy AmazonRedshiftDataFullAccess.

      {
         "Version": "2012-10-17",
         "Statement": [
             {
                 "Effect": "Allow",
                 "Action": [
                     "secretsmanager:GetSecretValue"
                 ],
                 "Resource": "{Secret ARN}"
             }
         ]
      }
    • After creating the IAM user, get the access key and secret key by going through the steps in Create Access Key inside IAM -> Users.
    • Have your AWS credentials, cluster identifier, secret ARN, AWS region, and database name ready.

Step by step guide​

  1. Access Data Mapping Settings:

    • Navigate to the Data Mapping page in the Osano application.
    • Select Sources from the left-hand navigation menu.

  2. Select Cloud DB Services as Source type

  3. From the available sources, select Redshift.

  4. Configure Redshift Integration:

    • Follow the on-screen instructions to configure your Redshift integration.
    • Enter your Amazon credentials.
    • Enter your Amazon ARNs.
    • Enter your database name.
    • Click Save.

  5. View Redshift Integration:

    • Once saved, you will see your Redshift integration in the list of configured sources.
    • Your integration will include tables that already exist in your Redshift environment.

  6. Click into the Discovered Data to view the tables that synced from Redshift.

  7. Create a new data store:

    • To proceed with creating a new data store, click on Review.
    • Follow the prompts to create a new data store.