Link a source

PostHog enables you to link your most important data from sources like your CRM, payment processor, or database. Once linked, you can combine this data with the product analytics data already in PostHog and query across all of it.

To link a source, go to the Integrations tab, and click the Sources tab. On that page, you have an option to create a managed source such as:

• Stripe
• Hubspot
• Zendesk
• Postgres
• MySQL
• Azure SQL Server
• Snowflake
• Vitally
• Chargebee
• BigQuery
• Google Ads

The other option is a self-managed source, which include:

• S3
• R2
• Google Cloud Storage
• Azure

You can find the set up instructions in-app or in the source specific docs.

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:

Linking a custom source

The data warehouse can link to data in your object storage system. To do this, you'll need to:

1. Create a bucket in your object storage system like S3, GCS, or Cloudflare R2
2. Set up an access key and secret
3. Add data to the bucket (potentially using a tool like Airbyte, Fivetran, Stitch, or others)
4. Link the table in PostHog

See an example in our S3 setup docs.

Incremental vs full table

On some sources and tables, you can choose the sync method. The options are incremental replication or full table replication.

Incremental

With incremental replication, you only sync new or updated data. This reduces the total number of rows synced and how long it takes to sync.

When choosing incremental replication, you must select a field to identify new and updated data. This is often something like an updated_at timestamp, or an autoincrementing ID. Not all fields are suitable to be used to identify new and updated data, and so we only support the following types as replication keys:

• integer (including bigint and smallint)
• datetime
• date
• timestamp
• numeric (for Snowflake)

The one downside to incremental syncing is that deletions of data won't be synced to your PostHog data warehouse. You need to use full table refreshes for this.

Full table

This reloads the whole table on every sync. This is great for tables with common data deletions or ones without an incrementing field (such as a updated_at timestamp).

Syncing

Once you add a source, you can see its status, sync frequency, and last successful run in the sources page. You can also reload or delete sources here.

When you expand each source, you can see:

• Schema name
• Enable or disable syncing for that table
• Synced table name in PostHog
• Time the table was last synced