> For the complete documentation index, see [llms.txt](https://public-docs.anvilogic.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://public-docs.anvilogic.com/get-started/onboarding-guide/select-your-data-repository-and-get-data-in/integrate-snowflake-as-your-data-repository.md).

# Integrate Snowflake as your data repository

## Choose Snowflake <a href="#choose-snowflake" id="choose-snowflake"></a>

After defining your company profile in the guided onboarding, select **Snowflake** as the data logging platform.

You must have admin privileges in Snowflake in order to complete the integration.

<figure><img src="/files/68WVf9mBTRXAbKAYLzof" alt=""><figcaption></figcaption></figure>

## Connect Snowflake to the Anvilogic platform <a href="#connect-snowflake-to-the-anvilogic-platform" id="connect-snowflake-to-the-anvilogic-platform"></a>

Perform the following steps to complete the integration with Snowflake:

1. Input your Snowflake account identifier to establish a connection between your Snowflake instance and the Anvilogic platform.
2. Click **Copy Code**, then click **Go to Snowflake** to go to your Snowflake instance and run the copied SQL commands. This set of SQL commands creates the necessary Snowflake components, the anvilogic\_service Snowflake user used by the Anvilogic platform, and assigns the necessary permissions to the anvilogic\_admin role for the anvilogic\_service user.
3. Perform the following tasks in your Snowflake instance:
   1. Open a new worksheet.
   2. Change the role from PUBLIC to ACCOUNTADMIN.
   3. Paste the copied SQL commands into the new worksheet.
   4. Click the **All Queries** checkbox to run all the commands.
   5. Click **Run**.
   6. Look for the **Statement executed successfully** message.

      <figure><img src="/files/rYgrzdkwYHSNT7TgSAc3" alt=""><figcaption></figcaption></figure>
4. Return to the Anvilogic platform, then click **Next**.
5. Click **Copy Code**, then click **Go to Snowflake** to go to your Snowflake instance and run the copied SQL commands. This set of SQL commands creates the S3 storage integration and allows access to the anvilogic\_service user so that a connection to your managed S3 bucket where Snowflake retrieves the data can be made.
6. Perform the following tasks in your Snowflake instance:
   1. Open a new worksheet.
   2. Change the role from PUBLIC to ACCOUNTADMIN.
   3. Paste the copied SQL commands into the new worksheet.
   4. Click the **All Queries** checkbox to run all the commands.
   5. Click **Run**.
   6. Look for the **Statement executed successfully** message.

      <figure><img src="/files/G1nywqYauafsDQqGv6CH" alt=""><figcaption></figcaption></figure>
7. Return to the Anvilogic platform, then click **Add**.

## Next step <a href="#next-step" id="next-step"></a>

After you have defined your company's threat profile and connected Snowflake as a data repository, it's time to [Get data into Snowflake](/get-started/onboarding-guide/select-your-data-repository-and-get-data-in/integrate-snowflake-as-your-data-repository/get-data-into-snowflake.md).
