Snowflake
  • 2 Minutes to read
  • PDF

Snowflake

  • PDF

About this document


This document provides the step-by-step procedure to onboard a Snowflake asset in SAFE.

Important
  • This document only applies to onboarding a single Snowflake account in SAFE.
  • To onboard multiple Salesforce accounts in SAFE, raise a service request to SAFE support to assist you.

Introduction


SAFE integrates with Snowflake and onboards the Snowflake assets under the Cloud-SaaS Applications vertical. Onboarding a Snowflake account is a three-step process:

  • Download the script from SAFE and generate connection details
  • Enter and Save the connection details in SAFE
  • Assess the Snowflake account and view results in SAFE.
Important
To perform the assessment of a Snowflake asset, a user with the read-only role is required with MFA (Multi-factor Authentication) exempted for this user. Instead of MFA, this user can be restricted to connect only from the SAFE instance’s IP address. We recommend setting the permissions for this account to only have read access to security settings, and not any other data stored in Snowflake.
Network Policy in Snowflake
  1. To create a Network Policy in Snowflake, please refer to this Snowflake documentation here.
  2. In the Allowed IP Addresses, specify the SAFE IP address.  Raise a service request to SAFE support to get online assistance with IP addresses during the process.
  3. To enforce the created Network Policy on the user, execute the below command:
    alter user <username> set NETWORK_POLICY = '<policy name>';
  4. To check the Network Policy is successfully implemented, execute the below command:
    show parameters like 'network_policy' in user <username>;

Onboard a Snowflake account in SAFE


Step 1: Download the script from SAFE and generate connection details

Important
The below steps need to be performed only on the Snowflake Classic UI experience. 
  1. Login to SAFE and navigate to SAFE Hooks.
  2. Click the Configure button available on the Snowflake card.
  3. On the configuration page, click the Download Script button available under step 1.
  4. The system downloads a script on your system. This script performs the below-mentioned tasks:
    • Creates SAFE read-only user. 
    • Creates a non-privileged table that can be accessed by the SAFE read-only user. 
    • Creates tasks that continuously fetch the configuration information that is required to validate the controls from the privileged tables, at specific intervals, and store it in the Non-privileged table. 
  5. Go to your Snowflake account URL and log in with an “ACCOUNTADMIN” privilege. 
  6. Click on the three dots options menu available at the top-right of the screen.  
  7. Click the Load Script option and upload the script downloaded from SAFE.
    Snowflake1

  8. Mark the All Queries checkbox.
  9. Click the Run button.
  10. After running all the queries inside the loaded script, the system displays the connection details (username and password). Note down the username and password of the read-only user to use in Step 2.
Note

The password for the least privileged (read-only) user will get updated every time you load the script. Hence make a note of the user's password and update it in SAFE to perform the assessment.

Step 2: Enter and save connection details in SAFE

  1. Navigate to the Snowflake configuration page in SAFE Hooks.
  2. Enter the connection details; Snowflake instance URL, Username, and Password generated in step 1.
  3. Click the Test Connection button.
    SnowFlake Integration
  4. Once the connection is verified, click the Save button. You have now successfully onboarded the Snowflake account in SAFE. 

Step 3: Assess the Snowflake account and view results in SAFE


  1. On the Snowflake configuration page in SAFE Hooks, click the Sync Now button to assess the onboarded Snowflake account.
  2. The account, once saved, will get assessed once per day as per the scheduled scan time. This is set to a pre-set time in 24 Hrs.
  3. SAFE Onboards the Snowflake assets under Cloud-SaaS Applications. To view the assessment result:
    1. Go to Technology > Inside-out. Click the Cloud-Saas Vertical.
      Assess Snowflake
    2. On this page, search and view the snowflake assets' assessment details.
      Assess Snowflake 2



Was this article helpful?

What's Next