Skip to main content

Set Up the LiveRamp Native App in Snowflake

Abstract

Translation and identity resolution capabilities are available within Snowflake through the LiveRamp Identity Resolution and Translation native app, which creates a share to your account, opening up a view to query the reference data set from within your own Snowflake environment.

Translation and identity resolution capabilities are available within Snowflake through the LiveRamp Identity Resolution and Translation native app, which creates a share to your account, opening up a view to query the reference data set from within your own Snowflake environment.

Once you've completed these steps to set up the native app, you're ready to perform the desired operation. See the articles listed below for the appropriate instructions:

Overall Steps

To set up the LiveRamp native app:

  1. Accept the Snowflake Consumer Terms of Service in Snowflake.

    Note

    This must be performed by a user with an "orgadmin" role.

  2. Install the LiveRamp Identity Resolution and Transcoding native app.

  3. Perform the initial application setup.

  4. Set up the logging events table.

See the sections below for detailed information on performing these steps.

Once you've run identity operations, you can then access the metrics view.

If needed, you can also share the native app to a different role.

Accept the Snowflake Consumer Terms of Service

To install the LiveRamp native app, an organizational administrator (ORGADMIN) or greater role needs to accept the Snowflake Consumer Terms of Service. Follow Snowflake's instructions listed here.

Install the LiveRamp Identity Resolution and Transcoding Native App

Note

To install the LiveRamp Identity Resolution and Transcoding native app:

  1. From the left navigation bar of Snowsight, select Marketplace.

    I-Set_Up_LiveRamp_Native_App-Marketplace_selection.png

  2. Search or browse to find the LiveRamp Identity Resolution and Transcoding native app and then click Request.

    I-Set_Up_LiveRamp_Native_App-Request_firsts.png

  3. If your email address has not been previously verified with Snowflake, you’ll receive an email to allow you to verify your email address.

  4. Fill in the fields on the form and then click Request.

    I-Set_Up_LiveRamp_Native_App-Request_second.png

    LiveRamp will then reach out to you to begin the contracting process and other required steps. Once these steps have been completed, LiveRamp shares the native app to your account.

  5. Once the native app has been shared to your account, select Apps.

    I-Set_Up_LiveRamp_Native_App-Apps_selection.png

  6. From the “Recently Shared with You” area, click Get for the LiveRamp Identity Resolution and Transcoding native app.

    I-Set_Up_LiveRamp_Native_App-Get_button.png

  7. Select the appropriate warehouse.

    I-Set_Up_LiveRamp_Native_App-Configure_app.png

    Note

    See Snowflake’s warehouse documentation for more information on the creation and use of warehouses. A warehouse is a specification of computer resources used for operations and follows Snowflake’s sizing and pricing rules for pricing and availability. A Snowflake warehouse will auto-suspend after a certain period of inactivity.

  8. If desired, change the application name.

  9. Click Get.

    The installation process begins.

    I-Set_Up_LiveRamp_Native_App-Install_message.png

    Note

    Do not leave the page or refresh the browser until you receive an email confirming that the installation has finished.

After the database is created successfully, the App will show up as an installed Application within the Apps section.

Open the LiveRamp Native App

To open the LiveRamp native app, doubleclick the application name in the Apps area.

I-Set_Up_LiveRamp_Native_App-Installed_app.png

You are taken to the Readme view from the application, which provides key details on inputs allowed, data configuration, and expected application behavior.

I-Set_Up_LiveRamp_Native_App-ReadMe.png

At the bottom of the screen, you’ll see sample SQL for the one-time initial application setup, as well as sample SQL with execution steps for performing an operation.

At the top of each sample SQL, an “Open in Worksheets” option appears upon hover to allow you to open the sample SQL in a worksheet.

I-Set_Up_LiveRamp_Native_App-Open_worksheet_icon.png

Perform Initial Application Setup

Before you perform an operation, you must perform the initial setup of the native app by running the Application Setup SQL with your updated values. This setup performs the following actions:

  • Sets the necessary variables that will be used in subsequent steps.

  • Creates an integration to LiveRamp’s auth API and enables the application to use it.

  • Creates an integration with LiveRamp’s billing API ensuring usage metrics can be tracked.

Note

Once completed, these setup steps do not need to be performed again.

To perform the initial application setup:

  1. Open the Application Setup worksheet with the sample SQL for initial application setup.

  2. Update the following variables in the sample SQL shown below and then run the SQL:

    Note

    Do not change the schema name. Leave this value as lr_app_schema.

    • DATABASE: The name of your database.

    • PUBLIC: The name of the schema that holds the tables for identity resolution.

    • LIVERAMP_IDENTITY_NATIVE_APP: The name of the database the native app is loaded to.

    • LIVERAMP_AUTH_INTEGRATION: The API integration which allows the native app to reach LiveRamps authentication API.

    --The configuration works off parameterized values, please update this section with the appropriate variables that will be referred to later in the process.

set customer_db_name = 'DATABASE';
set customer_schema_name = concat($customer_db_name, '.', 'PUBLIC');

-- Set the name of the application, you can choose to change the name of the application or leave it as is
set application_name = 'IDENTITY_RESOLUTION_AND_TRANSCODING';

--Update usage permissions on the appropriate database, schema and table names
grant usage on database identifier($customer_db_name) to application identifier($application_name);
grant usage on schema identifier($customer_schema_name) to application identifier($application_name);

-- Our application reaches out with client ID and secret to authenticate the workflow, please create and allow the application to use the API integration
create api integration if not exists LIVERAMP_AUTH_INTEGRATION
    api_provider = aws_api_gateway
    api_aws_role_arn = 'arn:aws:iam::715724997226:role/snowflake-lambda'
    api_allowed_prefixes = ('https://9e7j3merc8.execute-api.us-east-2.amazonaws.com/Prod')
    enabled = true;

grant usage on integration LIVERAMP_AUTH_INTEGRATION to application identifier($application_name);

--Our application reaches out with job metrics for billing, please create and allow the application to use the API integration. You will be able to track what job metrics got sent in LR_METRICS_SCHEMA.METRICS_VIEW
create api integration if not exists LIVERAMP_BILLING_API_INTEGRATION
    api_provider = google_api_gateway
    google_audience = 'embeddedidentitybilling-1mv2bhu1ltcuc.apigateway.identity-lambda-us-prod.cloud.goog'
    api_allowed_prefixes = ('https://embedded-identity-billing-gateway-ajm9gcm4.uc.gateway.dev')
    enabled = true;

grant usage on integration LIVERAMP_BILLING_API_INTEGRATION to application identifier($application_name);
use database identifier($application_name);
use schema lr_app_schema;

call enable_auth_api_call('LIVERAMP_AUTH_INTEGRATION');
call enable_billing_api_call('LIVERAMP_BILLING_API_INTEGRATION');

Set Up the Logging Events Table

The native app uses Snowflake Event Sharing to log activity to your account's event table, which can help you understand performance and enables information to be shared with LiveRamp for debugging and application health.

To enable the sharing of logs to LiveRamp:

Note

This only shares event logs generated by the LiveRamp native app back to LiveRamp. Any other events in the event table do not get shared to LiveRamp.

  1. If you have not already done so, set up an event table for your account by following Snowflake’s instructions here.

    Note

    If you’ve already set up an event table for your account, you do not need to create an additional table.

  2. After opening the LiveRamp native app, select the Security (shield) icon on the top right.

    I-Set_Up_LiveRamp_Native_App-security_shield.png

  3. In the screen that opens, select the “Events and Logs” tab.

  4. In the “Events and log sharing” area, click Enable.

    I-Set_Up_LiveRamp_Native_App-enable_button.png

  5. Slide the “All events” toggle to the right and then click Review.

    I-Set_Up_LiveRamp_Native_App-review_screen.png

Access the Metrics View

LiveRamp collects metrics for each job run through the native app. These metrics are sent to LiveRamp using an external function call. You can view the collected metrics in the native app under lr_metrics_schema.metrics_view.

Each record in the metrics view contains:

  • A timestamp

  • The UUID (transaction ID)

  • A billable flag

  • The number of records processed or not, an error count, and additional metadata

  • The job type

Share the Native App to a Different Role

You can share the installed native app to a different role on your account in either of the following ways:

  • Via the Snowflake UI

  • Via an SQL command

See the sections below for more information.

Share the Native App via the Snowflake UI

To use the Snowflake UI to share the installed native app to a different role on your account:

  1. From the navigation pane, using the role of the owner of the app, select Data Products → Apps.

    I-Snowflake_Set_Up_Native_App-Share_Apps_menu_item.png

  2. Click on the row for the LiveRamp app to open it.

    I-Snowflake_Set_Up_Native_App-Share-LiveRamp_app.png

  3. Click Manage Access.

    I-Snowflake_Set_Up_Native_App-Share-Manage_Access_button.png

  4. Select the additional role to grant access to the native app.

    I-Snowflake_Set_Up_Native_App-Share-Roles_dropdown.png

The UI indicates that the role has access to the “APP_VISIBLE_ROLE” role.

I-Snowflake_Set_Up_Native_App-Share-confirmation.png

Share the Native App via SQL

To use a SQL command to share the installed native app to a different role on your account, run the command below after substituting your information for the placeholder values.

GRANT APPLICATION ROLE IDENTIFIER('LIVERAMP_IDENTITY_NATIVE_APP.APP_VISIBLE_ROLE') TO ROLE IDENTIFIER('ROLE_THAT_NEEDS_ACCESS')

Substitute your information for the following placeholder values:

  • LIVERAMP_IDENTITY_NATIVE_APP: Change this to the application name of the LiveRamp native app installed in your account.

  • ROLE_THAT_NEEDS_ACCESS: Change this to the role you want to grant access to.

In this section: