Skip to main content

Connect Snowflake to Anzenna

This guide walks you through creating a Snowflake service account user with the appropriate permissions and connecting it to Anzenna using key-pair authentication.

Prerequisites​

  • Snowflake administrator access (SECURITYADMIN or equivalent)
  • Access to the Anzenna platform
  • Access to Snowflake SQL Worksheet

Step-by-Step Instructions​

Part 1: Get the Public Key from Anzenna​

  1. In Anzenna, click on Integrations.
Click on Integrations
  1. Click the enroll toggle button in the Snowflake card to begin setup.
Click on the enroll toggle button in Snowflake card
  1. Copy the public key shown in Anzenna. This will be used to establish the connection with Snowflake.
Copy the public key

Part 2: Create the Anzenna User in Snowflake​

  1. In your Snowflake console, click on SQL Worksheet.
Click on SQL Worksheet
  1. Paste the following SQL into the worksheet, replacing <your-public-key> with the key you copied from Anzenna:

create user ANZENNA display_name="Anzenna" timezone='UTC' type=SERVICE default_warehouse="COMPUTE_WH" default_role="SECURITYADMIN" rsa_public_key="<your-public-key>"; grant role SECURITYADMIN to user ANZENNA;

Paste the SQL with public key replaced
  1. Click on More run options.
Click on More run options
  1. Click Run All. Use "Run All" rather than "Run" to ensure both the CREATE and GRANT statements execute.
Click on Run All

Part 3: (Optional) Set a Network Policy​

If your organization requires restricting API access by IP, you can set a network policy for the Anzenna service account.

  1. Paste the following network policy SQL into the worksheet:

create network policy allow_anzenna_policy ALLOWED_IP_LIST=('35.212.173.22'); alter user ANZENNA set NETWORK_POLICY=allow_anzenna_policy;

Put network policy into the dialog
  1. Click on More run options.
Click on More run options
  1. Click Run All.
Click on Run All

Part 4: Complete the Connection in Anzenna​

  1. Return to the Anzenna enrollment page and paste your Snowflake account identifier. The format is <orgname>-<accountname>. See the Snowflake documentation for more details.
Paste your account identifier into the input
  1. Type ANZENNA as the username.
Type ANZENNA
  1. Click Connect.
Click on Connect
  1. You should see your Snowflake instance marked as connected.
You should see your instance marked as connected.
success

Snowflake is now connected to Anzenna. Anzenna will begin monitoring your Snowflake environment for security insights.