All Collections
Data Connections
Connecting to Amazon Redshift
Connecting to Amazon Redshift
Piers Batchelor avatar
Written by Piers Batchelor
Updated over a week ago


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.

Connection to Amazon Redshift with Astrato

Figure 1: Create New Connection - dialogue box image

Did this answer your question?