Before you begin

Enable sharing of a Snowflake listing

The Translate app enables businesses to unlock the full value of customer data by securely resolving identities without ever compromising personal information. By converting digital identifiers into persistent IDs, Translate bridges online and offline data, giving marketers a unified view of their audiences and enabling faster, more precise person-based marketing. Translate is versatile, allowing for integration within Snowflake environments, whether within the Snowflake Data Clean Room (DCR) or other environments, and can seamlessly transcode across Person IDs, facilitating enhanced collaboration and ensuring compatibility, consistency, robust data management, and security across various platforms.

To begin the installation process, our team must first enable your access to the Snowflake listing for the applicable application. This requires a few details from you about your Snowflake account.
If you have not already done so, contact dentsu.Composable sales to request the application.

In your request, provide the following details:

  • Client name: The name of the client or company related to your request.
  • Primary contact name
  • Primary contact email
  • Snowflake Organization Name: The unique name of your Snowflake organization, as shown in your Snowflake account details.
  • Snowflake Account Name: The name assigned to your Snowflake account, as shown in your Snowflake account details.
  • Snowflake Account Locator: The unique identifier for your Snowflake account, as shown in your Snowflake account details.

You can find Snowflake information in the Snowflake UI (Account > View Account Details), or by running the following in your Snowflake account:

SELECT current_organization_name() AS org_name,
       current_account_name() AS account_name,
       current_account() AS account_locator;

Please also share your dentsu Client Key, the unique identifier assigned to your advertiser for rekeying data, if known. 

Snowflake account requirements

This application requires:

  • Snowflake Enterprise Edition (or higher)

Snowflake role requirements

Please review the Snowflake documentation available here for more information on role setup in the context of the application's general installation.

Before installation, ensure the appropriate Snowflake roles are available.

  • INSTALLATION: Role with privileges to install the application from the Snowflake Marketplace. Note the name of the role you are using to install, as you may need it in subsequent steps.
  • ENABLEMENT (as needed, depending on the requirements in the “App enablement requirements > Account privileges” section): Role (e.g., `ACCOUNTADMIN`) that can grant required account-level privileges to the application

To support the use of the application, assign the application role to the account roles that will use the application.

App enablement requirements

Account privileges

No account privileges required for this application.

To enable functionality

This application requires:

  • <dentsu_client_key> — dentsu Client Key used to generate HMIDs

A dentsu Client Key is a unique identifier for an advertiser and is used to key and rekey data for identity resolution.

Optional (as needed):

For HMID-to-HMID translation:

  • <source_dentsu_client_key> and <target_dentsu_client_key> — Approved dentsu Client Key pairs

HMIDs are a variant of the dentsu.ID and can be an input or output of the Translate App.

About event logging

Snowflake Native Application Event Sharing enables effective use of this application for billing & observability by providing the necessary information to dentsu, while maintaining customer data privacy and security. Event sharing is enabled upon installation of this application.

  • The SNOWFLAKE.TELEMETRY.EVENTS table is the default event table for telemetry data collection. If you haven’t set up an event table, Snowflake uses the EVENTS table by default to collect telemetry data. For further information about event logging and how to locate and review your event table, please see this documentation from Snowflake.
  • Details regarding required event types are available for review from the application homepage > App Events. You are able to review the events table at any time to confirm that what is shared with Dentsu does not include sensitive information.

Billing

Custom event logging will be shared with dentsu for billing purposes. Examples of this type of custom event may include the number of rows or records processed.

Observability

Allowing developers to receive detailed logs and metrics from customer usage of a Snowflake Native Application significantly enhances support. It enables proactive debugging, performance tuning, and faster issue resolution. With access to real-time telemetry, developers can optimize application behavior, ensure reliability, and continuously improve the user experience — all while maintaining customer data privacy and security.

This is done securely and efficiently through Snowflake’s data-sharing capabilities, allowing our developers to understand and optimize application performance without requiring access to customer data.

Logging, tracing, and metrics are among the observability features Snowflake provides to make it easier to debug and optimize applications.

From the application homepage, this will appear as various Event Types, including Errors and Warnings, Metrics, Traces, Usage logs & Debug logs.
 

Getting started

Related articles