Stitch uses Amazon Redshift for data warehousing. To connect Stitch to Chartio, you’ll need to do the following:
- Whitelist Chartio’s IP address in Redshift
- Enter the Redshift connection details into Chartio
Whitelisting Chartio’s IP Address
See our Redshift instructions for whitelisting Chartio’s IP address.
Add Stitch to Chartio
The following instructions can be used to set up a Direct Connection to your Stitch Redshift data warehouse. If you plan on using an SSH Tunnel to connect, see our Tunnel connection instructions.
Connection details can be found in your AWS management console, as described in the instructions for whitelisting Chartio’s IP address.
In your Chartio account, select Data > + Add Data Source > Amazon Redshift then fill in the following:
|Form Field||Field Description|
|Hostname or IP||Your endpoint, excluding the colon and port number|
|Database Port||Database port number; may automatically be filled|
|Connect using SSL||Leave selected to use SSL|
|Database Username||The user you want to use to connect to Chartio; could be the master user, the Stitch user, or something else|
|Database Password||Password associated with the database user|
|Database Name||The name of the database that you used to connect to Stitch. This should be the same database that's listed in the Database field in your Stitch Warehouse Settings.|
|Extract schema||Leave selected!|
|Time Zone Support||Select Time Zone to automatically apply your organization's and dashboards' time zone to your data.|
|Data Source Alias||A nickname for your database|
When finished, click Connect.