Amazon Redshift
Source (Direct Connection) — Vendo reads directly from your Redshift cluster. No data is copied to Vendo’s infrastructure.
What Vendo Accesses
Vendo connects to your Amazon Redshift cluster and queries tables directly for use in attribution, segments, and data models.
Supported Data
| Data | Description |
|---|---|
| Tables | Any table in authorized schemas |
| Views | Standard and late-binding views |
| External Tables | Redshift Spectrum external tables (S3-backed) |
| Materialized Views | Auto-refreshed materialized views |
Connection Behavior
| Behavior | Description |
|---|---|
| Direct Query | No data import — queries run in your cluster |
| IAM or Password Auth | Supports both IAM role and username/password authentication |
| SSL Required | All connections use SSL encryption |
| Schema Discovery | Auto-discovers schemas and tables |
Platform Details
| Setting | Value |
|---|---|
| Auth Method | IAM role or username/password |
| Connection Type | Direct connection (no sync) |
| Protocol | PostgreSQL wire protocol (port 5439) |
| Compute | Queries run on your Redshift cluster |
Setup
- Navigate to App Connections > Add App Connection
- Select Amazon Redshift from the data warehouse category
- Enter your cluster endpoint, port, and database name
- Provide credentials (IAM role ARN or username/password)
- Click Save — Vendo will discover your schemas and tables
Network Requirements
Your Redshift cluster must be accessible from Vendo’s static IP addresses. Contact support for the current IP whitelist.
Troubleshooting
- Connection refused — Ensure your Redshift security group allows inbound on port 5439 from Vendo’s IPs
- Authentication failed — Verify credentials and check that the user has SELECT permissions
- Tables not appearing — Check schema permissions (
GRANT USAGE ON SCHEMA+GRANT SELECT ON ALL TABLES)
Last updated on