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.
Access to information schema- To build a data model, the user in the data connection must have read access to the Information_schema.
To validate access, run this query and confirm that you get the list of schemas in the database you are connected to. Replace %s in the code below with the database name.SELECT schema_name
FROM information_schema.schemata
WHERE schema_name !~ '^pg_' AND schema_name <> 'information_schema' AND catalog_name = '%s'
ORDER BY LOWER(schema_name) ;`
Cloud NAT IP addresses
prod-astrato-io-prod-nat-ip-0
34.142.11.11
prod-astrato-io-prod-nat-ip-1
34.142.68.232
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
click Test Connection.
Once the authentication is completed, a new screen will be displayed
Select a database and name the data connection.
Click Next.
In the next screen, select who can use the data connection.
Click Connect.
If the connection is successful and the data source is created, the Data View Editor opens.
In the Dataview, select the tables needed for the app.
Later, you can create additional dataviews that use the same data connection.