Introduction
In this article, we show you how to connect your Astrato workspace to Amazon Redshift. It's designed to be a quick process and easy to follow.
Connection data required
When setting up your data connection, you'll need to know:
Data connection: Hostname, Port
Database Credentials: User name, Password
SSL Credentials: SSL mode - default set at 'Disable' - please amend as required to meet your organization's security policy.
Creating the data connection to Amazon Redshift
Select Data in the sidebar
Create Data to open the Create New Data Source screen
Click on the Amazon Redshift icon
A dialogue box displays to Connect to Amazon Redshift (Figure 1)
Complete the required fields in the connection dialogue box
Enter the database name, Data Source/connection name, and click and click Test Connection.
If the connection is successful and the data source is created, the Data View Editor opens.
Please note: if a duplicate is created, a timestamp is added to the data source name.
Figure 1: Create New Connection - dialogue box image