> This page is for Advertising Protection.

> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://docs.humansecurity.com/llms.txt.

# Snowflake Quickstart

If you're a [MediaGuard](/advertising/mediaguard-overview) or [FraudSensor](/advertising/fraudsensor-overview) 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](/advertising/understand-the-human-dashboard); however, these Snowflake datasets let you explore your HUMAN data in even greater detail, and you can use [SnowSQL queries](/advertising/snowflake-example-queries) to perform your own observation and analysis.

> **Note**
>
> Commercial terms may be required for you to use Snowflake. Reach out to your account representative for more information.
>
> 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](https://app.snowflake.com/marketplace/providers/GZSNZ1IP0/HUMAN%20Security).
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](#WebInterfaceSetup) or its [SnowSQL client](#SnowSQLSetup). 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](https://docs.snowflake.com/en/user-guide/data-share-consumers.html) 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](/advertising/snowflake-data-fields) guide and our [Example Queries](/advertising/snowflake-example-queries) guide.