# Linking Snowflake as a source - Docs

The data warehouse can link to data in Snowflake.

Start by going to the [Data pipeline page](https://app.posthog.com/data-management/sources) 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`.

![Snowflake details](https://res.cloudinary.com/dmukukwp6/image/upload/Clean_Shot_2024_07_23_at_13_50_56_2x_c31bfa6237.png)![Snowflake details](https://res.cloudinary.com/dmukukwp6/image/upload/Clean_Shot_2024_07_23_at_13_50_42_2x_aa20de1109.png)

Once added, click **Next**, select the tables you want to sync, as well as the [sync method](/docs/cdp/sources.md#incremental-vs-full-table), and then press **Import**.

Once done, you can now [query](/docs/data-warehouse/query.md) your new table using the table name.

![Snowflake details](https://res.cloudinary.com/dmukukwp6/image/upload/Clean_Shot_2024_07_23_at_13_56_32_2x_9c0bc2d35f.png)![Snowflake details](https://res.cloudinary.com/dmukukwp6/image/upload/Clean_Shot_2024_07_23_at_13_56_53_2x_76a2b7f711.png)

#### 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:

| US | EU |
| --- | --- |
| 44.205.89.55 | 3.75.65.221 |
| 44.208.188.173 | 18.197.246.42 |
| 52.4.194.122 | 3.120.223.253 |

### Community questions

Ask a question

### Was this page useful?

HelpfulCould be better