Amazon Redshift is a fully managed, petabyte-scale data warehouse service in the cloud. You can connect Gtmhub to your Redshift instance to sync data from the Redshift data warehouse to build Gtmhub Insights for use in dynamic KRs.
Before you connect to Redshift you must make sure of the following:
- Your cluster must be publicly accessible.
- Create a database user for Gtmhub with permissions to read database schema and data.
- If your Redshift Cluster is part of a VPC you must allow inbound traffic to your VPC from the IP address which Gtmhub uses to handle data syncs. To do so in your AWS Console goto VPC and then to Security Groups. Find the security group to which your Redshift cluster belongs and add the following inbound rule:
Type: Redshift (5439)
Protocol: TCP (6)
Note that the IP through which we do syncs is
188.8.131.52but Amazon requires that IPs are provided in CIDR notation.
To establish a connection to your RedShift cluster, log in to your Gtmhub account and navigate to Setup > Data Sources.
- On the Data Sources screen click on the Add new data source button.
- Navigate to the Databases tab and select Amazon Redshift.
- Fill in the necessary details. To get your instance address you can check the Endpoint value in your Redshift cluster's dashboard. Take everything up to the port value :5439