Linking Snowflake as a source

The data warehouse can link to data in Snowflake.

Start by going to the Data pipeline page and the sources tab and clicking New source. Choose Snowflake and enter the following data:

• Account identifier: Likely a combination of your organization and the name of the account (e.g. myorg-account123). You can find this in the sidebar account selector or by executing the CURRENT_ACCOUNT_NAME and CURRENT_ORGANIZATION_NAME functions in SQL.
• Database: Like tasty_bytes_sample_data
• Warehouse: Like compute_wh
• User: Your username like IANVPH
• Password: The password for your user
• Role (optional): The role with necessary privileges to access your context like accountadmin.
• Schema: The schema for your database like RAW_POS. If it isn't working, trying using all caps.
• Table Prefix: The optional prefix for your tables in PostHog. For example, if your table name ended up being menu, a prefix of snow_prod_ would create a table in PostHog called snow_prod_menu.

Once added, click Next, select the tables you want to sync, as well as the sync method, and then press Import.

Once done, you can now query your new table using the table name.

Troubleshooting

Network policy blocking connection

Problem: Your Snowflake sync fails with an error like:

Incoming request with IP/Token is not allowed to access Snowflake. Contact your account administrator.

Solution: Your Snowflake account has a network policy (IP allowlist) that doesn't include PostHog's egress IP addresses. Ask your Snowflake administrator to add the IP addresses listed in the Configuration section below to your network policy allowlist. Once updated, retry the sync.

Configuration

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: