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

Random Disconnects

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.

How can I make sure my data is secure?

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 PostgreSQL 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.

Info Required:

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.