# Getting Started with Snowflake

Access Dataplex healthcare data products directly through Snowflake Marketplace. No data movement, no ETL—query our data instantly within your Snowflake environment.

{% hint style="success" %}
**Ready to get started?**

[Browse Our Snowflake Marketplace Listings →](https://app.snowflake.com/marketplace/providers/GZT1Z125KCG/Dataplex%20Consulting%20%26%20Data%20Products)
{% endhint %}

## Why Snowflake Marketplace?

| Benefit                | Description                                                           |
| ---------------------- | --------------------------------------------------------------------- |
| **Instant Access**     | Data is available immediately after subscription—no provisioning wait |
| **Zero Data Movement** | Query data directly in Snowflake without copying or syncing           |
| **Managed Billing**    | Snowflake handles subscription payments through your existing account |
| **Automatic Updates**  | Data refreshes automatically—always access the latest version         |
| **Native Integration** | Works with your existing Snowflake roles, warehouses, and tools       |

## Available Data Products

Visit our [Snowflake Marketplace provider page](https://app.snowflake.com/marketplace/providers/GZT1Z125KCG/Dataplex%20Consulting%20%26%20Data%20Products) to see all available listings:

| Data Product                               | Coverage                                                                                | Marketplace Listing                                                                                                                               |
| ------------------------------------------ | --------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------- |
| **ACA Marketplace Analytics Dataset**      | 50M+ records                                                                            | [View Listing](https://app.snowflake.com/marketplace/listing/GZT1Z7QRSXWC/dataplex-consulting-data-products-aca-marketplace-analytics-dataset)    |
| **Canadian Provider Registry**             | 93K+ providers                                                                          | [View Listing](https://app.snowflake.com/marketplace/listing/GZT1Z7QRSX3V/dataplex-consulting-data-products-canadian-provider-registry)           |
| **CDC Open Data Product**                  | 1.7B+ records                                                                           | [View Listing](https://app.snowflake.com/marketplace/listing/GZT1Z125KEY/dataplex-consulting-data-products-cdc-open-data-product)                 |
| **Census LEHD LODES Employment Dataset**   | 2.8B+ records                                                                           | [View Listing](https://app.snowflake.com/marketplace/listing/GZT1Z7QRSWHE/dataplex-consulting-data-products-census-lehd-lodes-employment-dataset) |
| **CMS Data Feeds Dataset**                 | 73B+ records, 232 feeds                                                                 | [View Listing](https://app.snowflake.com/marketplace/listing/GZT1Z125KDH/dataplex-consulting-data-products-cms-data-feeds-dataset)                |
| **CMS Data Research Dataset**              | Research datasets                                                                       | [View Listing](https://app.snowflake.com/marketplace/listing/GZT1Z125KDP/dataplex-consulting-data-products-cms-data-research-dataset)             |
| **CMS Medicaid Provider Spending Dataset** | 227M+ Medicaid claims records                                                           | [View Listing](https://app.snowflake.com/marketplace/listing/GZT1Z7QRSYVE)                                                                        |
| **CMS NPPES Provider Dataset**             | 8M+ providers                                                                           | [View Listing](https://app.snowflake.com/marketplace/listing/GZT1Z125KD9/dataplex-consulting-data-products-cms-nppes-provider-dataset)            |
| **FDA FAERS Dataset**                      | 18M+ events                                                                             | [View Listing](https://app.snowflake.com/marketplace/listing/GZT1Z125KFN/dataplex-consulting-data-products-fda-faers-dataset)                     |
| **FDA MAUDE Dataset**                      | 14M+ events                                                                             | [View Listing](https://app.snowflake.com/marketplace/listing/GZT1Z125KF7/dataplex-consulting-data-products-fda-maude-dataset)                     |
| **FDA Total Diet Study Dataset**           | 930K+ analytical results                                                                | [View Listing](https://app.snowflake.com/marketplace/listing/GZT1Z7QRT0BH)                                                                        |
| **HRSA Healthcare Resources Dataset**      | 40K+ records                                                                            | [View Listing](https://app.snowflake.com/marketplace/listing/GZT1Z7QRSW96)                                                                        |
| **NPPES Provider Golden Record**           | 9.5M NPIs, 19M address rows, 11 tables — validated, deduped, PECOS-enrolled, FHIR-ready | [View Listing](https://app.snowflake.com/marketplace/listing/GZT1Z7QRT0IO)                                                                        |

## How to Subscribe

### Step 1: Browse Listings

Visit the [Dataplex provider page](https://app.snowflake.com/marketplace/providers/GZT1Z125KCG/Dataplex%20Consulting%20%26%20Data%20Products) on Snowflake Marketplace.

### Step 2: Select a Product

Click on the data product you want to access. Review the listing details including:

* Data coverage and update frequency
* Sample queries and schema documentation
* Pricing and subscription terms

### Step 3: Get the Data

Click **Get** on the listing page. Snowflake will:

1. Create a shared database in your account
2. Set up access permissions
3. Make the data immediately queryable

{% hint style="info" %}
**Permissions required:** You need ACCOUNTADMIN or IMPORT SHARE privileges to subscribe to Marketplace listings. Contact your Snowflake administrator if you don't have access.
{% endhint %}

### Step 4: Start Querying

Once subscribed, the data appears as a shared database in your Snowflake account. Query it like any other database:

```sql
-- Example: Query CMS Data Feeds
SELECT *
FROM DWV.MEDICARE_PHYSICIAN_SPENDING
WHERE year = 2023
LIMIT 100;
```

## Free Trials

Some listings offer free trial access directly through Snowflake Marketplace. Look for the **Try for Free** option on listing pages.

For products without Marketplace trials, you can request a trial through our [Databricks trial portal](https://trial.dataplex-consulting.com) instead.

## Billing & Management

Snowflake Marketplace handles all subscription billing:

* **Payment**: Charges appear on your Snowflake invoice
* **Management**: View and manage subscriptions in Snowflake's **Data** → **Marketplace** → **Your Purchases**
* **Cancellation**: Cancel anytime through the Marketplace interface

## Snowflake vs Databricks

Not sure which platform to use? Here's a quick comparison:

| Feature           | Snowflake Marketplace           | Databricks Delta Sharing           |
| ----------------- | ------------------------------- | ---------------------------------- |
| **Trial**         | Some listings offer trials      | 14-day free trial for all products |
| **Billing**       | Through Snowflake               | Through Stripe                     |
| **Setup**         | Click "Get" → instant access    | Download activation file → import  |
| **Data Location** | Shared database in your account | Unity Catalog integration          |

{% hint style="info" %}
**Already using Databricks?** See our [Databricks getting started guide](/databricks-access/getting-started.md) for Delta Sharing setup.
{% endhint %}

## Need Help?

* **Questions about listings**: Contact <support@dataplex-consulting.com>
* **Snowflake technical issues**: Contact Snowflake support
* **Custom data requests**: Email us to discuss enterprise options

***

{% hint style="success" %}
**Ready to explore?**

[Browse Dataplex on Snowflake Marketplace →](https://app.snowflake.com/marketplace/providers/GZT1Z125KCG/Dataplex%20Consulting%20%26%20Data%20Products)
{% endhint %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.dataplex-consulting.com/snowflake-access/snowflake.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
