_1scog
Last Updated: June 10, 2016
·
277
· rebagliatte

Segment + AWS Redshift + Chartio

  1. Create a Redshift cluster as described here:
    https://help.segment.com/hc/en-us/articles/206579173-Setting-up-Amazon-Redshift

  2. Add Segment's IP to the cluster's allowed IP list
    https://help.segment.com/hc/en-us/articles/206213296-Permissioning-Segment-to-Redshift

  3. Make sure at least one of your Segment Sources is sending data to the newly created warehouse.

  4. Add Chartio's IP to the cluster's allowed IP list
    https://support.chartio.com/docs/data-sources/#amazon-redshift

  5. Get 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

  6. Connect chartio with Redshift!