Amazon Redshift is a widely used cloud data warehouse, hosted on AWS and configurable as either a cluster where you define setup parameters, or a ‘serverless’ set-up.
- Hostname which is the publicly accessible IP or URL for your Redshift database. Note that you’ll need to set your database to be publicly accessible.
- Port which is the port that your database is live on – typically 5439 by default for Redshift, but your port may differ
- Database Name which is the name on your hostname IP / URL you database is referenced by
- Username which is…your database (NOT AWS!) username. Best practice is to create a read only user
- Password which is…your password. Once you enter this, Zing will automatically encrypt this.
If you’ve not already created a Redshift cluster and made it accessible to a data querying tool outside youur VPC, you’ll need to:
- Create a Virtual Private Cloud (VPC) – the default VPC is fine.
- Create a subnet group
- Expose a public IP (often using ElasticIP), allocate it, and connect it to your Redshift instance
- Set your Redshift cluster to ‘publicly accessible’ and connect it to the IP you’ll expose to the internet via a routing table
- Ensure your security group allows connections from IPv4 connections from the internet (or better, just from Zing’s IP specifically: 220.127.116.11 )
Go to your Zing Data Web Console and ensure you are logged in
Tap the ‘data sources’ tab
Enter your Redshift credentials, as outlined above.
Tap ‘Check Connection’
You’ll see a list of tables and views which you can allow Zing to access. By default ‘Include All’ is turned on which means all database tables will be visible to Zing. But if you’d like you can select a subset of tables to make visible to Zing.
Once you see that your connection has been successfully saved, tap ‘Close’
The data source you just added will be available to everybody in your organization.
- Zing will verify that it can connect to your data source and if successful, add it as a source. If Zing cannot connect to your data source, you'll see a message asking your to check your credentials and retry. If even after checking your credentials and retrying you still experience issues, reach out to Zing support here