Skip to main content

Connect Graphext to AWS Redshift

(Make sure that your cluster is available for connection and that you have configure the IP correctly, in case you need help, we explain you how to do it in the section below “Configure the availability of your cluster and the IP”)

Guided steps

1

Create a project

Click on “New Project” (this will add the integration to your personal team) or the “Integrations” button inside the team you want to work on.
2

Select Amazon Redshift from the integrations list.

3

Introduce your account Username and Password.

4

Head to the AWS webpage

select the cluster you want to use.
5

From the database configurations

Copy the Database name, the Port, and the Host and paste them into the corresponding fields.
6

Create your SQL query

Using the AWS console or your favorite editor, and paste it in the field labeled Query. Make sure to access the full path.
7

Allow write output to export data

If you want Graphext to write back the project’s output to Amazon Redshift. Select “Allow write output.” View more documentation about this step in our API Docs.
8

Save

Click on “Save and create project” to retrieve your data and begin exploring or “Save” the integration for later use.

Configure the availability of your cluster and the IP

Availability of your Redshift cluster and the IP

Ensure you configure the Inbound rules with the correct IP and Port.

Inbound rules with the correct IP and Port