Segment + AWS Redshift + Chartio
Create a Redshift cluster as described here:
https://help.segment.com/hc/en-us/articles/206579173-Setting-up-Amazon-RedshiftAdd Segment's IP to the cluster's allowed IP list
https://help.segment.com/hc/en-us/articles/206213296-Permissioning-Segment-to-RedshiftMake sure at least one of your Segment Sources is sending data to the newly created warehouse.
Add Chartio's IP to the cluster's allowed IP list
https://support.chartio.com/docs/data-sources/#amazon-redshiftGet your schema names. You can get them from each Segment's UI, from the Source page under Settings > Sql, or you can get them by connecting to your database via PostreSQL as follows:
a. Add your own IP to the cluster's allowed IP list
b. Connect to your db:
psql -h <yourcluster>.<yourslug>.<yourregion>.redshift.amazonaws.com -U <yourdbusername> -d <yourdatabasename> -p <yourport>
c. List your schemas
\dn
Connect chartio with Redshift!