Claravine + Snowflake Integration (Closed Beta)

Julia Randall
Julia Randall
  • Updated

Use our Snowflake outbound connector to export data from The Data Standards Cloud into a table in a Snowflake database to apply data standards within the Snowflake Marketing Data Cloud.

How you can use the Snowflake outbound connector:

  • If you're building exception tables in Snowflake, this can serve as a user interface for teams to manage Snowflake dimension tables.
  • If you're working across the content supply chain, you can use this to connect creative metadata from a DAM to media campaigns for richer analytics in Snowflake.
  • If you're managing a migration from Datorama or a similar system, you can recreate harmonization rules with the Split and Extract feature and template definition.
  • If you have image and video assets, Content Comprehension powered by Claravine AI can enrich these with additional content and creative metadata for use in analysis in a Snowflake table.

The key benefits of this connector include:

  • Makes data available faster in Snowflake: The direct connector (compared to connecting via S3) removes a step and bypasses needing to work with a data engineering team. This reduces the time it takes to evaluate performance and ROI and make necessary changes.
  • Improves marketing metadata capabilities: With a single source of truth for all metadata, you can minimize time and resources cleaning up data so your data teams can spend more time on insights and results and less time fixing and re-processing data.
  • Provides Snowflake dimension table management: If you're building exception tables in Snowflake, Claravine provides a user interface for teams to manage this data.
  • Proves business value of marketing campaigns: Gain campaign intelligence by breaking down data silos and unifying advertising and marketing data fast in a single, governed, and scalable platform.

Integrate Claravine with Snowflake

Begin by running the setup script in Snowflake.

A dedicated warehouse, database, and schema are required to house data from The Data Standards Cloud in your Snowflake account. If you don’t already have these configured, you must run a script to create them. Run the following script in a SQL Worksheet in your Snowflake account.

Note: Be sure to change the password from what’s included in the script below to something more secure.

 -- set variables (these need to be uppercase)
 set claravine_role = 'CLARAVINE_ROLE';
 set claravine_username = 'CLARAVINE_USER';
 set claravine_warehouse = 'CLARAVINE_WAREHOUSE';
 set claravine_database = 'CLARAVINE_DATABASE';
 set claravine_schema = 'CLARAVINE_SCHEMA';

 -- set user password
 set claravine_password = 'password';


 -- create claravine role
 use role securityadmin;
 create role if not exists identifier($claravine_role);
 grant role identifier($claravine_role) to role SYSADMIN;

 -- create claravine user
 create user if not exists identifier($claravine_username)
 password = $claravine_password
 default_role = $claravine_role
 default_warehouse = $claravine_warehouse;

 grant role identifier($claravine_role) to user identifier($claravine_username);

 -- change role to sysadmin for warehouse / database steps
 use role sysadmin;

 -- create claravine warehouse
 create warehouse if not exists identifier($claravine_warehouse)
 warehouse_size = xsmall
 warehouse_type = standard
 auto_suspend = 60
 auto_resume = true
 initially_suspended = true;

 -- create claravine database
 create database if not exists identifier($claravine_database);

 -- grant claravine warehouse access
 grant USAGE
 on warehouse identifier($claravine_warehouse)
 to role identifier($claravine_role);

 -- grant claravine database access
 on database identifier($claravine_database)
 to role identifier($claravine_role);



 USE DATABASE identifier($claravine_database);

 -- create schema for claravine data
 CREATE SCHEMA IF NOT EXISTS identifier($claravine_schema);



 -- grant claravine schema access
 on schema identifier($claravine_schema)
 to role identifier($claravine_role);


Set Up the Snowflake Outbound Connector

  1. To configure the Snowflake integration in your Claravine account, navigate to Settings > Integrations > Accounts.
  2. Click Add (+), and select the Snowflake tile.
  3. Enter your Snowflake locator URL, username, and password.
    Snowflake Locator URL format is based on the region in which your Snowflake account is hosted. Refer to the Snowflake documentation to determine the correct locator URL to use.

    image (13).png

Configure the Snowflake Outbound Integration

  1. Add the Snowflake outbound integration as an outbound connector in the template configuration Connect step. In outbound connectors, select the Snowflake tile.
  2. Enter an Integration Name.
  3. Select the Snowflake Account (created in Step 2 above).
  4. Select the Template fields to be delivered to Snowflake.
    Outbound data selection is similar to Email Send configuration. Select the fields to be delivered to your Snowflake table.

    image (14).png

    Data will automatically deliver to Snowflake each time a submission is completed.

Watch a Video

Watch a live outbound integration demo:



Article is closed for comments.