Linking Redshift as a source

The Redshift connector can link your database tables to PostHog.

To link Redshift:

1. Go to the Data pipeline page and the sources tab in PostHog
2. Click New source and select Redshift
3. Enter your database connection details:
   • Host: The hostname or IP of your Redshift cluster like my-cluster.abc123.us-east-1.redshift.amazonaws.com.
   • Port: The port your Redshift cluster is listening on. The default is 5439.
   • Database: The name of the database you want like analytics_db.
   • User: The username with the necessary permissions to access the database.
   • Password: The password for the user.
   • Schema: The schema for your database where your tables are located. The default is public.
4. Click Next

The data warehouse then starts syncing your Redshift data. You can see details and progress in the sources tab.

Permissions: The Redshift source only requires read permissions on the schemas and tables you intend to sync.

Inbound IP addresses

We use a set of IP addresses to access your instance. To ensure this connector works, add these IPs to your inbound security rules: