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 theAdmin 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
Access Data Mapping Settings:
- Navigate to the Data Mapping page in the Osano application.
- Select Sources from the left-hand navigation menu.
Select Cloud DB Services as Source type
From the available sources, select
Redshift
.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.
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.
Click into the Discovered Data to view the tables that synced from Redshift.
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.
- To proceed with creating a new data store, click on