Connect to AWS Redshift

<aside> 💡 This enables Glazed to automatically validate that the events you create on the Glazed App are correctly arriving to your data warehouse.

</aside>

Prerequisites

• Whitelist Glazed IP addresses (see how):

167.71.58.189/32

• The cluster must be publicly accessible (see how)

Steps

1. Open a new Query Editor in the Console of your Redshift Cluster
2. Run the following queries: Note: this grants the “glazed” user permission to run SELECT statements only on the specified table. You can modify the query to grant access to multiple tables.

CREATE USER glazed WITH PASSWORD '<create a password>';

GRANT USAGE ON SCHEMA schema_name TO glazed;

GRANT SELECT ON TABLE schema_name.table_name TO glazed;

Common Questions

• How can I find out my host?

  1. Go to your cluster in the AWS console

  2. Copy the “Endpoint: information and remove everything after the “:” (included)

     

  Example of host: redshift-cluster-1.cq6rilpu2470.eu-central-1.redshift.amazonaws.com

• How can I whitelist Glazed IP addresses?

  Whitelist IP Addresses (Redshift)