Certain information in this article may be missing or out of date. We are in the process of updating the content.
Connecting to your Amazon Redshift database? Here is an overview of things you can expect.
Connecting to Amazon Redshift
Before starting, please collect your Amazon Redshift Host, Port, Database name, username and password. Additionally, please whitelist these IP addresses before connecting.
- Click on the Data tab at the top left of the global navigation. Then click on Connections in the Data Library section.
- Click on the blue Connect button and search for Amazon Redshift.
- Click on the Amazon Redshift logo.
- 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.
FAQs + Tips and Tricks
Random Disconnects
Sometimes Amazon Redshift disconnects from Grow randomly. We have found that it is an issue with Redshift and not the connector of the Grow. If your metrics become disconnected, just go ahead and reconnect to your database.
How can I make sure my data is secure?
We have several items in place to keep your data safe. Check out our security article to see what steps you can take to keep control of your data.
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.