> For the complete documentation index, see [llms.txt](https://docs.coupler.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.coupler.io/sources/category/files-and-tables/redshift.md).

# Redshift

Redshift is Amazon's fully managed, petabyte-scale data warehouse service. With Coupler.io, you can automatically export data from your Redshift tables, views, or custom SQL queries to Google Sheets, Excel, BigQuery, Looker Studio, or even AI destinations like Claude and ChatGPT — all on a schedule you control.

## Why connect Redshift to Coupler.io?

* **No code required** — Select a table or write a SQL query; Coupler.io handles the rest
* **Flexible exports** — Send data to spreadsheets, data warehouses, or AI platforms
* **Scheduled automation** — Set it and forget it; your data updates on your timeline
* **Transform as you go** — Use Join, Append, and Aggregate transformations to reshape your Redshift data before it lands in your destination

## Prerequisites

* An active Redshift cluster
* A Redshift user account with read access to the tables or schemas you want to export
* Host, port, database name, username, and password for your Redshift cluster
* Outbound access from your Redshift cluster to Coupler.io's IP addresses (your Coupler.io support team can provide these)

{% hint style="success" %}
**Quick start:** If you're exporting a single table or view, use the "Table or view" report type. If you need to filter, aggregate, or join data, use "Custom SQL" instead.
{% endhint %}

## How to connect

{% stepper %}
{% step %}
**Log in to Coupler.io** and create a new data flow. Click **Add source** and search for Redshift.
{% endstep %}

{% step %}
**Enter your Redshift connection details:**

* **Host** — Your Redshift cluster endpoint (e.g., `my-cluster.123456789.us-east-1.redshift.amazonaws.com`)
* **Port** — Default is `5439`
* **Database** — The database name you want to connect to
* **Username** — Your Redshift username
* **Password** — Your Redshift password

Click **Test connection** to verify the credentials work.
{% endstep %}

{% step %}
**Choose your report type:**

* Select **Table or view** if you want to export an entire table or materialized view. Then pick the schema and table name from the dropdowns.
* Select **Custom SQL** if you need to write a query to filter, aggregate, or join data. Paste your SQL query in the text field.
  {% endstep %}

{% step %}
**Select your destination.** Choose where your Redshift data should land — Google Sheets, Excel, BigQuery, Looker Studio, Claude, ChatGPT, Cursor, Gemini, Perplexity, OpenClaw, or another supported platform.
{% endstep %}

{% step %}
**Run the data flow.** Click **Run** to execute a manual test. Coupler.io will fetch your data and send it to the destination. Once this completes successfully, you can set up a schedule.
{% endstep %}
{% endstepper %}

## Supported report types

| Report type       | Use case                                            | Example                                                            |
| ----------------- | --------------------------------------------------- | ------------------------------------------------------------------ |
| **Table or view** | Export an entire table or view without modification | Export the `public.customers` table                                |
| **Custom SQL**    | Filter, aggregate, join, or transform data with SQL | `SELECT customer_id, SUM(amount) FROM orders GROUP BY customer_id` |


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.coupler.io/sources/category/files-and-tables/redshift.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.