Skip to main content

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.

note

To view your HUMAN data in Snowflake, you must already have an active MediaGuard and/or FraudSensor integration.

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 seperately.)

  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 by using Snowflake's SnowSQL client. In 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      |

+---------------------------------+---------+-------------------------+-----------------------+----+-------+---------------------------------------------+
  1. 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

The mediaguard_prebid and mediaguard_prebid_sampled views correspond to pre-bid MediaGuard data, while mediaguard_postbid corresponds to post-bid FraudSensor 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.