Skip to main content

Amazon Redshift

info

Adding an Ahana data source creates a definition of the connection between Ahana and the data source you want Ahana to connect to. See Data Sources Overview.

Ahana data source definitions do not move or create database objects or data, and do not require the data source to exist when the definition is created.

Amazon Redshift is a service on AWS that that makes it easier to set up, operate, and scale a Redshift cluster in the AWS Cloud.

This page walks you through adding an Amazon Redshift cluster as a data source to Ahana Cloud for Presto.

Step 1: Select Amazon Redshift as the Connector Type

  1. In the Ahana SaaS Console, select Data Sources.
  2. Select Add Data Source.

Add Data Source

  1. Select Amazon Redshift.

Configure Redshift

Step 2: Configure the data source details

  1. Give your data source a Name. The name is used to derive the catalog name used for Presto. A data source name must contain only lowercase letters, numbers, and underscores. The table in the Data Sources tab of the Ahana SaaS Console shows both the name entered here and the derived catalog name. See Data Sources Overview.
  2. Enter a Description for this data source.

Configure Amazon Redshift

Step 3: Configure the Redshift cluster access details

  1. Enter the Endpoint information for your Redshift cluster.
    • for example: redshift-ahana-demo.example.us-east-1.redshift.amazonaws.com:5439/dev
Find the connection string to the Redshift cluster
  1. Navigate to the Amazon Redshift console.
  2. In the sidebar menu, select CLUSTERS, then select the cluster name you want to connect to.
  3. In General information, click the copy button next to the Endpoint to copy the connection string.
  4. Paste the connection string into the Endpoint text field on the Ahana SaaS Console.

Get the endpoint Information from the Amazon Redshift Console

caution

This Endpoint needs to be accessible from the Virtual Private Cloud (VPC) where the Presto clusters are running.

  1. If required, enter Connection Parameters for the Redshift cluster.
    Connection parameters are typically optional. However, if you are configuring an SSL connection to your Redshift database, you must add the following parameter:
    ?ssl=true
  2. Enter the User and the Password for the Redshift cluster.

Configure AWS Redshift

Step 4: Add the data source

When you have configured the data source, select Add Data Source.

You can now connect to this data source from your Presto clusters.