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)

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.

How to connect

1

Log in to Coupler.io and create a new data flow. Click Add source and search for Redshift.

2

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.

3

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.

4

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.

5

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.

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