Connecting to your Amazon Redshift database? Here is an overview of things you can expect.
NOTE: This data source is only available for accounts on the Professional plan. If you would like to upgrade your plan, talk to your Grow account manager or visit your account's billing page.
How to Connect
Before starting, please collect your Amazon Redshift Host, Port, Database name, username and password. Additionally please whitelist these IP addresses before connecting.
- Log in to your Grow account and click Add Metric. Select Amazon Redshift from your list of data sources, then click the blue Connect button.
- Type in the connection nickname, this can be anything that you would like to name it.
- Type in the host, port, database name, username and password.
And that's it! You are good to go.
FAQs + Tips and Tricks
Sometimes Amazon Redshift disconnects from Grow randomly. We’ve found that it is an issue with Redshift and not Grow’s connector. If your metrics become disconnected, just go ahead and reconnect to your database.
Connecting via SSH
Redshift itself doesn't use SSH.
In order to to use a SSH tunnel, Grow will need to connect to a server on the same VPC that has access to your Redshift DB. It is usually an EC2 Instance that has the PosgreSQL CLI client installed. This is because Redshift itself doesn't support SSH tunneling, but we can connect through a server that has access to the Redshift DB.
Once you have setup an additional EC2 instance inside of the same VPC, please install PostgreSQL CLI client, as well as SSH server. Make sure port #22 is open, and send us the whitelisted IP address from which we can access the server.