Snowflake Quickstart

If you’re a MediaGuard or FraudSensor user, you can directly access your HUMAN data through Snowflake. The datasets available in Snowflake are similar to what you’ll find in the HUMAN Dashboard; however, these Snowflake datasets let you explore your HUMAN data in even greater detail, and you can use SnowSQL queries to perform your own observation and analysis.

Get started

Before you can query your HUMAN data, you’ll need to request access through Snowflake.

1. Navigate to HUMAN’s Snowflake Marketplace page.
2. Select the Programmatic Ad Fraud Defense listing. (This listing comprises both MediaGuard and FraudSensor data; you won’t need to request each dataset separately.)
3. From the Programmatic Ad Fraud Defense listing, select Request. A HUMAN representative will contact you shortly to verify and approve your request.

Set up shares

You can set up shares in your Snowflake environment either by using Snowflake’s web interface or its SnowSQL client. With either method, you’ll need an account with the ACCOUNTADMIN role (or any other role with the IMPORT SHARES privilege).

For more information about shares, consult Snowflake’s Data Consumers guide.

Web interface setup

To set up shares via Snowflake’s web interface:

1. In Snowflake’s web interface, navigate to the Shares tab, then select the Inbound toggle. You’ll see a list of all the shares available to your account. When you create a database from a share, its name will appear in the Database column. If the Database column is empty, this means you haven’t yet created a database from the share.
2. To create a database from the share, select the share and choose Create Database from Secure Share.

SnowSQL setup

To set up shares via SnowSQL:

1. In SnowSQL, execute a SHOW SHARES statement. The result should include a share name called WHITEOPS_ADVERTISING_INTEGRITY and the provider WHITEOPS<region_name>. Your SnowSQL output should look something like this:

Example output

+---------------------------------+---------+---------------------------------------------------+-----------------------+----+-------+---------------------------------------------+
| created_on                      | kind    | name                                              | database_name         | to | owner | comment                                     |
|---------------------------------+---------+---------------------------------------------------+-----------------------+----+-------+---------------------------------------------|
| Thu, 15 Jun 2017 17:02:29 -0700 | INBOUND | WHITEOPSAWSUSEAST1.WHITEOPS_ADVERTISING_INTEGRITY |                       |    |       |                                             |
| Sat, 09 Jul 2016 19:18:09 -0700 | INBOUND | SFC_SAMPLES.SAMPLE_DATA                           | SNOWFLAKE_SAMPLE_DATA |    |       | Sample data sets provided by Snowflake      |
+---------------------------------+---------+---------------------------------------------------+-----------------------+----+-------+---------------------------------------------+

2. After you’ve obtained the share name, create a database by using the following command (replace <name> with the name you’d like to assign to your new database, <provider_account> with the WHITEOPS<region_name> value described in the previous step, and <share_name> with WHITEOPS_ADVERTISING_INTEGRITY):

CREATE DATABASE <name> FROM SHARE <provider_account>.<share_name>

For example, using the information from the example output above, a database creation command might look like this:

CREATE DATABASE myDB FROM SHARE WHITEOPSAWSUSEAST1.WHITEOPS_ADVERTISING_INTEGRITY

Verify your setup

If you’ve created the database successfully, you should be able to access the following views in your Snowflake share:

• mediaguard_prebid
• mediaguard_prebid_sampled
• mediaguard_postbid
• mediaguard_prebid_postbid_combined_global

The mediaguard_prebid and mediaguard_prebid_sampled views include pre-bid MediaGuard data, mediaguard_postbid includes post-bid FraudSensor data, and mediaguard_prebid_postbid_combined_global includes pre-bid MediaGuard and post-bid FraudSensor joined data..

Use HUMAN data in Snowflake

For more information about using your HUMAN data in Snowflake, consult our Data Fields guide and our Example Queries guide.