Redshift
Connect Graphext to Amazon Redshift and be able to bring your data and write back to your data warehouse recurrently
Connect Graphext to AWS Redshift
Guided steps
Connect to Amazon Redshift
Connect to Amazon Redshift
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
Inbound rules with the correct IP and Port