Snowflake (Edge)

Prerequisites

• An active Snowflake account is available.

• You have either ACCOUNTADMIN or SECURITYADMIN role in Snowflake to create a new role for Hevo.

• You have either ACCOUNTADMIN or SYSADMIN role in Snowflake to create a warehouse.

• Hevo is assigned USAGE permissions on data warehouses.

• Hevo is assigned USAGE and CREATE SCHEMA permissions on databases.

• Hevo is assigned USAGE, MONITOR, CREATE TABLE, CREATE EXTERNAL TABLE, and MODIFY permissions on the current and future schemas.

Refer to section, Create and Configure your Snowflake Warehouse to create a Snowflake warehouse with adequate permissions for Hevo to access your data.

---

Perform the following steps to configure your Snowflake Destination:

(Optional) Create a Snowflake Account

---

Create and Configure your Snowflake Warehouse

Hevo provides you with a ready-to-use script to configure the Snowflake warehouse you intend to use as a Destination.

Follow these steps to run the script:

1. Log in to your Snowflake account.

2. In the left navigation pane, under Projects, click Worksheets.

   

3. On the top right corner of the Worksheets tab, click the + icon and select SQL Worksheet from the drop-down to create a new worksheet.

   

4. Paste the following script in the worksheet. The script creates a new role for Hevo in your Snowflake Destination. Keeping your privacy in mind, the script grants only the essential permissions required by Hevo to load the data in your Destination.

   -- create variables for user / password / role / warehouse / database (needs to be uppercase for objects)
   set role_name = 'HEVO'; -- Replace "HEVO" with your role name
   set user_name = 'HARRY_POTTER'; -- Replace "HARRY_POTTER" with your username
   set user_password = 'Gryffindor'; -- Replace "Gryffindor" with the user password
   set warehouse_name = 'HOGWARTS'; -- Replace "HOGWARTS" with the name of your warehouse
   set database_name = 'RON'; -- Replace "RON" with the name of your database
   set schemaName = 'DARK_ARTS'; -- Replace "DARK_ARTS" with the database schema name
   
   set db_schema = concat($database_name, '.', $schemaName);
   
   begin;
   
   -- change role to securityadmin for user / role steps
   use role securityadmin;
   
   -- create role for HEVO
   create
   role if not exists identifier($role_name);
   grant role identifier($role_name) to role SYSADMIN;
   
   -- create a user for HEVO
   create user if not exists identifier($user_name)
   password = $user_password
   default_role = $role_name
   default_warehouse = $warehouse_name;
   
   -- Grant access to the user
   grant role identifier($role_name) to user identifier($user_name);
   
   -- change role to sysadmin for warehouse / database steps
   use role sysadmin;
   
   -- create a warehouse for HEVO, if it does not exist
   create
   warehouse if not exists identifier($warehouse_name)
   warehouse_size = xsmall
   warehouse_type = standard
   auto_suspend = 60
   auto_resume = true
   initially_suspended = true;
   
   -- create database for HEVO
   create database if not exists identifier($database_name);
   
   -- grant HEVO role access to warehouse
   grant USAGE
   on warehouse identifier($warehouse_name)
   to role identifier($role_name);
   
   -- grant HEVO access to current schemas
   use role accountadmin;
   grant CREATE SCHEMA, MONITOR, USAGE, MODIFY
   on database identifier($database_name)
   to role identifier($role_name);
   
   -- grant Hevo access to future schemas
   use role accountadmin;
   grant SELECT on future tables in database identifier($database_name) to role identifier($role_name);
   grant MONITOR, USAGE, MODIFY on future schemas in database identifier($database_name) to role identifier($role_name);
   
   use role accountadmin;
   CREATE SCHEMA IF not exists identifier($db_schema);
   GRANT USAGE, MONITOR, CREATE TABLE, CREATE EXTERNAL TABLE, MODIFY ON SCHEMA identifier($db_schema) TO ROLE identifier($role_name);
   
   commit;
   

5. Replace the sample values provided in lines 2-7 of the script with your own. You can specify a new warehouse, role, and database name to create these now, or use pre-existing ones to load data into. These are the credentials that you will be using to connect your warehouse to Hevo.

   Note: The values for role_name, user_name, warehouse_name, database_name and schemaName must be in upper case.

6. Press CMD + A (Mac) or CTRL + A (Windows) inside the worksheet area to select the script.

7. Press CMD+return (Mac) or CTRL + Enter (Windows) to run the script.

8. Once the script runs successfully, you can use the credentials from lines 2-7 of the script to connect your Snowflake warehouse to Hevo.

---

Obtain your Snowflake Account URL

The organization name and account name are visible in your Snowflake web interface URL.

For most accounts, the URL looks like https://<orgname>-<account_name>.snowflakecomputing.com.

For example, https://hevo-westeros.snowflakecomputing.com. Here, hevo is the organization name and westeros is your account name.

Perform the following steps to obtain your Snowflake account URL:

1. Log in to your Snowflake instance.

2. Navigate to the bottom of the left navigation pane, click the account selector, and then hover over the Account section.

   

3. In the pop-up, locate the account whose URL you want to obtain and hover over it.

4. In the account details pop-up dialog, click the Copy icon to copy the account identifier, and save it securely.

   

The account identifier is provided in the format <orgname>.<account_name>. To convert it to the account URL, substitute the values of orgname and account_name in the format https://<orgname>-<account_name>.snowflakecomputing.com.

For example, if the account identifier is KRCHCUO.CN07513, the account URL is https://krchcuo-cn07513.snowflakecomputing.com.

Use this URL while configuring your Destination.

---