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​

  • 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.

  • 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.

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

      {
         "Version": "2012-10-17",
         "Statement": [
             {
                 "Sid": "SecretsManagerDbCredentialsAccess",
                 "Effect": "Allow",
                 "Action": [
                     "secretsmanager:GetSecretValue"
                 ],
                 "Resource": "arn:aws:secretsmanager:<REGION>:<ACCOUNT_ID>:secret:<SECRET-*>"
             }
         ]
      }
    • 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.