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) ;`
```

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 and data source/connection name, 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