Skip to main content

Snowflake Quickstart

If you're a Snowflake user, you can access HUMAN integrations through the Snowflake Data Marketplace. We’ve compiled a guide to help you query and import your HUMAN data into your Snowflake environment.

Our Human Verification Engine analyzes real-time traffic signals to provide continuous, multi-layered detection throughout your digital ecosystem. Datasets are available for the following HUMAN products:

MediaGuard is HUMAN’s tool for detecting and preventing digital advertising fraud. Our leading market solution provides digital advertisers (including mobile publishers and programmatic advertising platforms) with the knowledge to protect themselves against malicious bot activity and prevent losses from wasted ad spend. Our joint pre-bid and post-bid solutions (known as MediaGuard and FraudSensor, respectively) ensure that your ads are delivered to humans and not bots, boosting your overall ROI.

These datasets provide you with the knowledge to explore traffic data, monitor your customer base, and eliminate fraud. HUMAN offers granular data about individual transactions, including “bot or not” decisions and detailed threat taxonomies to isolate hotspots of fraudulent activity. Potential use cases may involve identifying fraudulent ad publishers, analyzing the effects of an email marketing campaign, or discovering the types of automated traffic that your application receives.

Get started

After you’ve spoken to a HUMAN representative to set up your HUMAN account (if you don't have one already), you’ll need to request access to HUMAN data through the Snowflake Data Marketplace.

  1. Navigate to the Snowflake Data Marketplace and select HUMAN from the provider drop-down menu.
  2. HUMAN offers three products: MediaGuard, BotGuard for Growth Marketing, and BotGuard for Applications. From these options, select the product whose data you'd like to access. (If you’re using multiple HUMAN products and would like to access data for all of them, you can repeat these steps for each applicable product.)

  1. On the relevant product's listing page, 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. 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 starting with WHITEOPS_ followed by the name of the product you selected in the Getting Started section above (either WHITEOPS_ADVERTISING_INTEGRITY, WHITEOPS_MARKETING_INTEGRITY, or WHITEOPS_APPLICATION_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 |



| 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_<name_of_product>):
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:

  1. If you selected multiple HUMAN products in the Getting Started section of this guide, you'll need to repeat these SnowSQL commands for each applicable product.

Verify your setup

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

  • mediaguard_prebid
  • mediaguard_prebid_sampled
  • mediaguard_postbid
  • botguard_apps
  • botguard_growth_marketing

You'll only be able to access views that correspond to the product(s) that you set up in the previous steps. MediaGuard users have access to views for both HUMAN’s pre-bid solution (MediaGuard) and post-bid solution (FraudSensor); however, if you've only subscribed to one of these two MediaGuard products, you'll only be able to select pre-bid or post-bid data according to your current setup.


The following views are deprecated but might still be accessible in Snowflake. Since they're no longer maintained, we don't recommend using them.

  • advertising_integrity_fraudsensor
  • advertising_integrity_mediaguard
  • marketing_integrity
  • application_integrity

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.