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
(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”)
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.
