Snowflake Quickstart
If you're a Snowflake user, you can access your HUMAN data through the Snowflake Data Marketplace. Datasets are available for MediaGuard, FraudSensor, BotGuard for Growth Marketing, and BotGuard for Applications. You can use these datasets to explore the information collected by HUMAN in even greater detail and perform your own observation and analysis.
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.
- Navigate to the Snowflake Data Marketplace and select HUMAN from the provider drop-down menu.
- 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.)
- 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:
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.
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:
- In SnowSQL, execute a
SHOW SHARES
statement. The result should include a share name starting withWHITEOPS_
followed by the name of the product you selected in the Getting Started section above (eitherWHITEOPS_ADVERTISING_INTEGRITY
,WHITEOPS_MARKETING_INTEGRITY
, orWHITEOPS_APPLICATION_INTEGRITY
) and the providerWHITEOPS<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 |
+---------------------------------+---------+-------------------------+-----------------------+----+-------+---------------------------------------------+
- 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 theWHITEOPS<region_name>
value described in the previous step, and<share_name>
withWHITEOPS_<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:
CREATE DATABASE myDB FROM SHARE WHITEOPSAWSUSEAST1.WHITEOPS_ADVERTISING_INTEGRITY
- 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.