> ## Documentation Index
> Fetch the complete documentation index at: https://docs.graphext.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Redshift

> Connect Graphext to Amazon Redshift and be able to bring your data and write back to your data warehouse recurrently

<Frame caption="Connect Graphext to AWS Redshift">
  <iframe width="640" height="449" src="https://www.youtube.com/embed/qj_swZXg4rk?si=dU_xu6X8BWuS3C93" title="Connect Graphext to AWS Redshift" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" allowFullScreen="True" />
</Frame>

(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

<Accordion title="Connect to Amazon Redshift">
  <Steps>
    <Step title="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.
    </Step>

    <Step title="Select Amazon Redshift from the integrations list." />

    <Step title="Introduce your account Username and Password." />

    <Step title="Head to the AWS webpage">
      select the cluster you want to use.
    </Step>

    <Step title="From the database configurations">
      Copy the **Database name**, the **Port**, and the **Host** and paste them into the corresponding fields.
    </Step>

    <Step title="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.
    </Step>

    <Step title="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](/api-docs).
    </Step>

    <Step title="Save">
      Click on “Save and create project” to retrieve your data and begin exploring or “Save” the integration for later use.
    </Step>
  </Steps>
</Accordion>

### Configure the availability of your cluster and the IP

<Frame caption="Availability of your Redshift cluster and the IP">
  <iframe width="640" height="449" src="https://www.youtube.com/embed/l8pJcIJl_ao?si=tGnQ1aITMmxcP4Uy" title="Availability of your Redshift cluster and the IP" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" allowFullScreen="True" />
</Frame>

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

<Frame caption="Inbound rules with the correct IP and Port">
  <iframe width="640" height="449" src="https://www.youtube.com/embed/DNGqNx6dtIc?si=dC6cRU6OUcXUUdeJ" title="Inbound rules with the correct IP and Port" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" allowFullScreen="True" />
</Frame>