Amazon Redshift

Amazon Redshift

  • Purpose: Connect to Amazon Redshift, a PostgreSQL-compatible cloud data warehouse.
  • When to use it: Best for large-scale analytical queries on structured data stored in AWS Redshift clusters.
  • How to create it:
    1. Go to Data Sources and click Add.
    2. Select Amazon Redshift.
    3. Name: Enter a unique name for this connection.
    4. Host: Redshift cluster endpoint (e.g., cluster.xxxx.us-east-1.redshift.amazonaws.com).
    5. Port: Default is 5439.
    6. Database Name: The Redshift database to connect to.
    7. Schema: (Optional) Default is public.
    8. Username / Password: Database user credentials.
    9. SSH Tunnel: (Optional) Enable if your cluster is in a private VPC — see SSH Tunnel.
    10. Click Test Connection to verify, then Save.

Amazon Redshift Configuration

Note: Ensure your Redshift cluster’s security group allows inbound connections from the Datalytics IP address on port 5439.