Connection Parameters
| Parameter | Description | Required | Example |
|---|---|---|---|
| Host | Cluster endpoint | Yes | my-cluster.redshift.amazonaws.com |
| Port | Cluster port | Yes | 5439 (default) |
| Database | Database name | Yes | production |
| Username | Database user | Yes | readonly_user |
| Password | User password | Yes | ******** |
Required Permissions
Similar to PostgreSQL, create a user with read permissions:
redshift_permissions.sql
-- Minimum required permissions GRANT CONNECT ON DATABASE production TO readonly_user; GRANT USAGE ON SCHEMA public TO readonly_user; GRANT SELECT ON ALL TABLES IN SCHEMA public TO readonly_user; -- For metadata extraction (System Catalog) GRANT SELECT ON pg_catalog.pg_tables TO readonly_user; GRANT SELECT ON information_schema.tables TO readonly_user; GRANT SELECT ON information_schema.columns TO readonly_user;
Special Features
Spectrum Support
Automatically detects and extracts metadata from external tables (Redshift Spectrum).
Distribution Keys
Identifies distribution keys and sort keys to help with query optimization.
Compression Detection
Extracts column encoding/compression information.
PostgreSQL Compatibility
Full compatibility with PostgreSQL-based tools and drivers.
Common Issues
Connection timeout
Check your VPC security group inbound rules. Ensure port 5439 is open to the 3X platform IP.
Cluster not publicly accessible
Enable 'Publicly Accessible' in Redshift cluster settings or use a VPC Peering/VPN connection.
Cannot see external tables
Grant SELECT access on the external schema:
GRANT SELECT ON EXTERNAL SCHEMA schema_name TO readonly_user;