Skip to main content

Install Snowflake CLI Framework for Windows

The integration of LiveRamp Clean Room’s intelligence applications with Snowflake streamlines data collaboration and delivers end-to-end solutions that drive business outcomes for brands. It combines a flexible UI with Snowflake’s Data Cloud to orchestrate clean room use cases through low-code data connectors to access data at the cloud source with zero data movement.

Overall Steps

As part of the implementation, the LiveRamp Clean Room agent must be installed on your Snowflake instance. This document details the end-to-end CLI installation process specifically for Windows. Perform the following overall steps to install the Snowflake CLI framework for Windows:

  1. Add a credential

  2. Install LiveRamp Clean Room Snowflake Command-Line Interface (CLI)

  3. Create a YAML configuration file

  4. Initialize the LiveRamp Clean Room Snowflake Framework

For information on performing these steps, see the instructions below. After you complete these steps, you can create and modify data connections directly in LiveRamp Clean Room using the steps in "Configuring a Snowflake Data Connection".

Note

Only one Snowflake account should be configured in a given LiveRamp Clean Room organization. Configuring multiple Snowflake accounts in an organization is not supported. If you previously completed the prerequisites and set up connections, you can start at the "Install LiveRamp Clean Room Snowflake Command-Line Interface (CLI)" section below.

Prerequisites

Ensure that you do the following before configuring the installation of the LiveRamp Clean Room Snowflake CLI Framework:

  • Identify your Snowflake Edition. LiveRamp Clean Room Snowflake CLI supports both Snowflake Enterprise Edition (recommended) and Snowflake Business Critical Edition.

  • Identify your Snowflake authentication method. LiveRamp Clean Room Snowflake CLI supports the following authentication methods:

    • User and Password

    • Key Pair in PKCS8

    • Single Sign-on (SSO)

  • Locate your Snowflake Account Identifiers from your Snowflake account.

    Note

    Users with the ORGADMIN role can execute the SQL command:

    SELECT current_account() AS accountID, current_account_alias() AS accountName, system$return_current_org_name() AS OrgName;

    Identifiers include:

    • Account name

    • Organization name

    • Organization UUID

    • Locator

    • Role

    • Warehouse

    • User

    image idm783

  • Confirm you have ACCOUNTADMIN (Account Administrator) access. ACCOUNTADMIN is a role that encapsulates the SYSADMIN and SECURITYADMIN system-defined roles.

  • Confirm you have the following Python environment:

    • Python Version 3.9.7 or later

    • Python Virtual Environment

    • Python pip-tools

  • Confirm you have access to LiveRamp Clean Room. If you need access to LiveRamp Clean Room, contact LiveRamp Community portal.

Add a Credential

Complete the following steps for both the collaboration owner and partner.

Note

For detailed steps to identify Snowflake account information, see "Find Your Snowflake Account Information."

To create the Snowflake credential, do the following:

  1. From the LiveRamp Clean Room navigation pane, select Data Management → Credentials.

  2. Click Add Credential

    add_credential.png

  3. Complete the following fields:

    • Name: Enter the [Organization] Snowflake account name.

    • Credentials Type: Select Snowflake Account from the drop-down list.

    • Account ID: Enter the 8-digit account ID for your organization; alphanumeric characters should be capitalized (for example, "AB123456")

    • Account Name: Enter your Snowflake account name (unique within your organization).

    • Organization Name: Enter your Snowflake organization name (unique within Snowflake).

    • Region: Select the region associated with your Snowflake account from the drop-down list.

  4. Click Save Credential.

    snow_account_creds.png

  5. To verify the added credential:

    1. Log in to your Snowflake account as an ACCOUNTADMIN.

    2. Select two inbound shares. For example:

      • HABU_ID_GRAPH_SHARE_DB (LiveRamp Clean Room’s Identity Graph)

      • HABU_ORG_UUID_SHARE (LiveRamp Clean Room Snowflake Database shared to your Snowflake account)

    image idm1125

Install LiveRamp Clean Room Snowflake Command-Line Interface (CLI)

LiveRamp Clean Room Snowflake CLI is a toolset used to support confirmation of your provider and requester instances.

To install LiveRamp Clean Room Snowflake CLI, do the following:

  1. From the Windows Start Menu, search for Command Prompt and select Run as administrator.

    image idm1130

  2. Verify that you have Python 3 version 3.9.7 or later by running the following command:

    C:\WINDOWS\system32>python3 --version

    The Python 3 version you have should display, for example, Python 3.10.2

    If Python is not available, you can install it by running the following command:

    C:\WINDOWS\system32>python3

    image idm1135

  3. A virtual environment is recommended to facilitate the installation. Virtual environments isolate installation directories and allow you to localize the CLI installation without forcing you to install them system-wide.

    If you do not have the Python Virtual Environment installed, install it by running the following command:

    pip install virtualenv

    image idm1140

  4. Create a virtual environment by running the following command:

    python3 -m venv <environmentname>

    In this example, the virtual environment is named, "habu_snowflake".

    image idm1145

  5. Activate the virtual environment by changing into the directory and running the activate command:

    cd C:\Temp\habu_snowflake\Scripts

    activate

    image idm1150

  6. Install the LiveRamp Clean Room Snowflake CLI by running the following command:

    Note

    Update the Snowflake CLI version accordingly (for example, "4.11.0")

    pip install habu-snowflake-cli==4.11.0

Create a YAML Configuration File

Note

You will need the following Snowflake account information in the steps below: account name, organization name, role, warehouse, user, and password. See the "Prerequisites" section above for more information.

YAML is commonly used for configuration files and in applications where data is being stored or transmitted. You will need to create a YAML configuration file for your Snowflake account based on your authentication method. LiveRamp Clean Room supports three authentication options:

  • User and Password Authentication

  • Key Pair Authentication

  • Single Sign-on (SSO) Authentication

You create a YAML configuration file by running the redbeard generate-config command. The command writes the inputs you pass in as arguments. In each of the following options, these inputs include account name, organization name, role (ACCOUNTADMIN), warehouse, and user.

To create a YAML configuration file, do the following:

  1. Run the following command: redbeard generate-config 

    Note

    Running redbeard generate-config  creates the default "habu_snowflake_config_yaml" YAML file. You can create a custom named YAML file by using the -c function as follows: redbeard generate-config -c <FILENAME.yaml> 

    For example (modify accordingly):

    (snowflake) bash-5.1$ redbeard generate-config -c custom_habu_snowflake_config.yaml

  2. Enter the appropriate information according to the authentication option you are implementing. See the examples for each option below:

User and Password Authentication Option

To enable user and password authentication, enter the appropriate information at the prompts: For example (modify accordingly):

(snowflake) bash-5.1$ redbeard generate-config
Client account name: HABU_DEV1_OWNER
Client organization name: HABU_ORG
Role to use [ACCOUNTADMIN]: 
Warehouse to use for installation [CLEAN_ROOM_SETUP_WH]: 
Clean room user [clean_room_user]:      
Authentication Type (sso, keypair, password) [sso]: password
Please enter password: 

Verify the content of the YAML file by running the following command: cat habu_snowflake_config.yaml. 

For example:

(snowflake) bash-3.2$ cat habu_snowflake_config.yaml 
accountName: HABU_DEV1_OWNER 
organizationName: HABU_ORG 
role: ACCOUNTADMIN 
warehouse: CLEAN_ROOM_SETUP_WH 
user: clean_room_user 
password: changeme
Key Pair Authentication Option

Note

To learn more about key pair authentication, see "Snowflake Key Pair Authentication and Key Pair Rotation".

To enable key pair authentication, enter the appropriate information at the prompts: For example (modify accordingly):

(snowflake) bash-5.1$ redbeard generate-config
Client account name: HABU_DEV1_OWNER
Client organization name: HABU_ORG
Role to use [ACCOUNTADMIN]: 
Warehouse to use for installation [CLEAN_ROOM_SETUP_WH]: 
Clean room user [clean_room_user]: 
Authentication Type (sso, keypair, password) [sso]: keypair
Please enter keypair file path: /Users/jdoe/.ssh/rsa_key.p8       
Please enter keypair file password:

Verify the content of the YAML file by running the following command: cat habu_snowflake_config.yaml. 

For example:

(snowflake) bash-3.2$ cat habu_snowflake_config.yaml 
accountName: HABU_DEV1_OWNER 
organizationName: HABU_ORG 
role: ACCOUNTADMIN 
warehouse: CLEAN_ROOM_SETUP_WH 
user: clean_room_user 
key_path: /Users/johndoe/.ssh/rsa_key.p8 
key_pass: abc123
Single Sign-on (SSO) Authentication Option

Note

If you currently log in to your Snowflake account via SSO, CLI can be configured using SSO authentication.

To enable SSO authentication, enter the appropriate information at the prompts: For example (modify accordingly):

(snowflake) bash-5.1$ redbeard generate-config
Client account name: HABU_DEV1_OWNER
Client organization name: HABU_ORG
Role to use [ACCOUNTADMIN]: 
Warehouse to use for installation [CLEAN_ROOM_SETUP_WH]: 
Clean room user [clean_room_user]: 
Authentication Type (sso, keypair, password) [sso]: sso

Verify the content of the YAML file by running the following command: cat habu_snowflake_config.yaml. 

For example:

(snowflake) bash-3.2$ cat habu_snowflake.yaml 
accountName: HABU_DEV1_OWNER 
organizationName: HABU_ORG 
role: ACCOUNTADMIN 
warehouse: CLEAN_ROOM_SETUP_WH 
user: clean_room_user

Initialize the LiveRamp Clean Room Snowflake Framework

After you create the YAML configuration file, you can initialize the framework. To initialize the framework, do the following:

Note

You can find your Organization UUID in LiveRamp Clean Room by selecting your organization in the Organization drop-down list in the upper right, and clicking the Copy UUID icon next to your Organization UUID under the Organization UUID column.

  • If you configured the YAML file as the default "habu_snowflake_config.yaml", add your "Organization UUID" to the following command and run the command:

    redbeard init habu-framework -o <organization uuid> .

    For example (modify accordingly):

    redbeard init habu-framework -o f593e343-452c-4ad2-8f6b-fea01658e4e8

    Note

    If you used a custom YAML file name, add your "Organization UUID" and the custom "YAML file name" to the following command and run the command:

    redbeard init habu-framework -o <organization uuid> -c <YAML file name>

The command creates two databases: "HABU_CLEAN_ROOM_COMMON" and "HABU_DATA_CONNECTIONS" and shares them with LiveRamp Clean Room.

"HABU_DATA_CONNECTIONS" stores the metadata information for LiveRamp Clean Room (i.e., Columns and Column Data Types) and the identity graph (i.e., Parent’s ID).

image idm813

It also accepts a shared database called "HABU_ID_GRAPH_SHARE_DB" from LiveRamp Clean Room. This is LiveRamp Clean Room’s identity graph.

To implement the Snowflake pattern, you run a set of CLI commands. These commands create and share databases and tables in the account. To learn more, see "Configure a Snowflake Pattern Data Connection".

Note

Databases and tables are often referred to as objects.

In this section: