Vitally.io Vitally Academy Vitally Blueprints

Redshift

Instructions for setting up Redshift for synchronization of data into Vitally

Requirements

  1. Make sure that your Redshift cluster is accessible over the internet.

  2. Create unique Redshift credentials, using password authentication for Vitally's access to the database and grant the user permission to the required tables.

  3. Safe-list Vitally's IP address in any relevant security groups:

    • For US-hosted Vitally customers: 52.2.105.119, 34.198.95.164, 54.225.45.200, 3.233.54.92, 44.197.82.135, 44.205.137.47, 3.231.135.245, 34.234.2.125, 18.117.45.34, 18.118.174.158, 3.128.104.4, 3.128.39.40, 3.137.39.224, 3.20.73.62

    • For EU-hosted Vitally customers: 13.50.117.250, 13.48.176.93, 13.48.142.17, 13.53.227.107, 16.171.90.148, 16.170.120.57, 16.171.215.121, 16.171.156.82

Step 1 - Connect

We'll need these values to connect to your Redshift warehouse:

  • Host: The public hostname of your Redshift cluster, which you can find under 'connection details' in the AWS Redshift console.

  • Port: The port your Redshift cluster is configured to use. By default, it is 5439.

  • Database: The name of the database that you want to connect to (e.g. production).

  • Username: A unique Redshift user that you've created for Vitally.

  • Password: That user's password.

Step 2 - Configure Sync

Step 3 - Enable Sync

PreviousPostgreSQLNextBigQuery

Last updated