Integrate Snowflake as your data repository

Integrate the Anvilogic platform with Snowflake.

Choose Snowflake

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.

Connect Snowflake to the Anvilogic platform

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.

      
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.

      
7. Return to the Anvilogic platform, then click Add.

Next step

After you have defined your company's threat profile and connected Snowflake as a data repository, it's time to Get data into Snowflake.