FAQ

Can I connect to a Redshift cluster in a private VPC?

Redshift clusters in private VPCs are not directly accessible from the internet. However, there are a few options:

• Enable a public endpoint for your cluster (then use the standard connection method)

• Use an SSH tunnel or bastion host to bridge the connection (contact Coupler.io support for assistance)

• Use a VPN to make the cluster accessible

Talk to your Coupler.io support team about which option works best for your setup.

Can I use a Custom SQL query with JOIN or UNION?

Yes, absolutely. Custom SQL in Coupler.io supports the full range of Redshift's SQL syntax, including JOINs, UNIONs, CTEs (WITH clauses), window functions, and aggregations. Just paste your query and click Test to verify it works.

How do I export only recent data (last 30 days, this month, etc.)?

Use date functions in your Custom SQL query. Here are some common patterns:

-- Last 30 days
SELECT * FROM orders WHERE order_date >= CURRENT_DATE - 30

-- Current month
SELECT * FROM orders WHERE DATE_TRUNC('month', order_date) = DATE_TRUNC('month', CURRENT_DATE)

-- Last week
SELECT * FROM orders WHERE order_date >= CURRENT_DATE - 7

These queries use Redshift's current date, so they dynamically adjust each time the data flow runs.

Can I combine Redshift data with data from other sources?

Yes. After creating a Redshift data flow, you can add a second source (Salesforce, Stripe, Google Ads, etc.) to the same data flow. Then use Coupler.io's Append transformation to merge rows from both sources, or Join to combine data by a common key. Learn more in the Coupler.io transformations documentation.

What happens if my Redshift query returns NULL values?

NULL values will be exported as-is to your destination (blank cells in Google Sheets or Excel, NULLs in BigQuery, etc.). If you want to replace NULLs with a default value, use the COALESCE() function in your Custom SQL:

SELECT id, COALESCE(email, 'Not provided') AS email FROM customers

Alternatively, if you're working in Google Sheets or Excel, you can clean up NULLs after import using formulas.

How many rows can I export?

Coupler.io has a limit of 10 million cells per data flow (not rows). The exact row limit depends on your column count. For example:

• 100 columns × 100,000 rows = 10 million cells ✓

• 10 columns × 1 million rows = 10 million cells ✓

• 5 columns × 2.1 million rows = 10.5 million cells ✗

If you hit this limit, filter your query or split the data across multiple data flows.

Can I schedule my data flow to run every hour, or only daily?

Scheduling options depend on your Coupler.io plan. You can typically schedule data flows to run at intervals ranging from hourly to weekly. Check your plan's features or contact support to confirm what's available.

How do I know if my data flow ran successfully?

After you schedule a data flow, Coupler.io displays the run history in your dashboard. Each run shows:

• Start and end times

• Status (Success, Failed, Timeout)

• Row count (if successful)

Click on a run to see detailed logs, including any errors or warnings. You can also enable email notifications for failed runs.

Can I use Redshift data as input for an AI model like Claude or ChatGPT?

Yes. Coupler.io supports AI destinations including Claude, ChatGPT, Cursor, Gemini, Perplexity, and OpenClaw. Export your Redshift data to one of these platforms for analysis, summarization, or other AI-powered tasks. Your data flow will send the query results directly to the AI model.

For more details on available transformations, visit the Best Practices section. For detailed data structure information, see Data Overview. If you encounter errors, check Common Issues for troubleshooting steps.