Price Transparency Snowflake Data Share

Trillions of Negotiated Rates, Live in Your Snowflake Account

No ETL. No flat files. Share your account identifier and query real payer rates in minutes.

PayerPrice Snowflake data share example

The full picture, queryable in Snowflake

We process every published machine-readable file and share the structured output directly to your Snowflake account. Same data powering our UI and API.

Trillions

of Negotiated Rates

200+

Commercial Payers

100+

Filter Columns

Monthly

Data Refreshes

From share to query in minutes

Your warehouse. Our data. No pipeline.

We share structured MRF data directly to your Snowflake account. You query it like any other table.

Payer MRFsPayerPrice ProcessingYour Warehouse

Zero-pipeline access

Share your Snowflake account identifier. We provision the data share. Tables appear in your account — no ETL, no file transfers, no storage costs for shared data.

NPITINCodePayerRate123...12-34599213United$138123...12-34599214United$197456...67-89099213Aetna$125

100+ filterable columns

NPI, TIN, payer, plan, network, taxonomy, billing code, modifier, place of service, state — and more. Filter and join against your own data however you need.

Full DatasetLatest MonthRolling 3moHistorical

Flexible views for common queries

Pre-built views for latest month, rolling three-month windows, and full historical data. Use them as-is or build your own.

Built for teams that run on SQL

If your team already works in Snowflake, the data is right where you need it.

BI Dashboards

Connect Tableau, Looker, or Power BI directly to the shared tables.

Custom Analytics

Query 1T+ rates with SQL. Join with your own data.

Replace Manual Reports

Replace spreadsheets with automated rate comparisons.

Internal Tools

Power internal apps and workflows with live rate data.

Rate Benchmarking

Compute percentiles by payer, state, specialty, and billing code.

Fee Schedule Management

Build and update fee schedules grounded in real market data.

SQL-native access

Standard Snowflake tables and views. No special SDK, no proprietary format. If you can write SQL, you can use the data.

PayerPrice Snowflake schema example

Monthly data refreshes

Updated within days of payer publication, every month. No action on your side.

Built-in Medicare benchmarks

Every rate includes a Medicare percentage for easy comparison across payers.

Compute on your account

Queries run on your Snowflake compute. You control warehouse size and cost.

Real rates. Standard SQL.

Query negotiated rates directly from your Snowflake warehouse.

query.sql
SELECT
  payer,
  billing_code,
  state,
  PERCENTILE_CONT(0.50) WITHIN GROUP (
    ORDER BY negotiated_rate
  ) AS p50,
  PERCENTILE_CONT(0.75) WITHIN GROUP (
    ORDER BY negotiated_rate
  ) AS p75,
  PERCENTILE_CONT(0.90) WITHIN GROUP (
    ORDER BY negotiated_rate
  ) AS p90
FROM negotiated_rates
WHERE
  state = 'MA'
  AND taxonomy_code = '208000000X'
  AND billing_code IN ('99213', '99214')
GROUP BY payer, billing_code, state;
results
6 rows
payer     | billing_code | p50    | p75    | p90
----------+--------------+--------+--------+-------
United    | 99213        | 149.83 | 212.53 | 241.98
United    | 99214        | 214.75 | 307.10 | 349.66
Aetna     | 99213        | 142.10 | 198.44 | 229.87
Aetna     | 99214        | 201.33 | 289.62 | 334.15
Cigna     | 99213        | 155.20 | 219.81 | 248.32
Cigna     | 99214        | 222.47 | 315.88 | 358.91
(6 rows)

“In one instance, we were prepared to accept sub-optimal rates based on flawed rate assumptions, and reversed course once we got access to PayerPrice.”

CPChip PorterVP of Managed Care, ApolloMD

Real negotiated rates. One SQL query away.

Share your Snowflake account identifier and start querying trillions of contracted rates. No ETL required.

Free trial access. No credit card required.

Snowflake Data Share FAQs

Your questions answered

You share your Snowflake account identifier. We provision the data share and notify you when it's ready. You create a database from the share and start querying. Most teams are live in under a day.

We process new machine-readable files from payers every month. Updated data appears in the share within days of payer publication. No action needed on your side.

The share includes tables for negotiated rates, provider-payer mappings, and plan metadata. Over 100 columns including NPI, TIN, payer, plan, network, taxonomy, billing code, modifier, place of service, and state. Pre-built views cover common query patterns.

Yes. We can provision a share scoped to the payers, states, or specialties you need. This keeps the data volume manageable and the cost predictable.

Pricing is based on the scope of data shared. The shared data itself incurs no Snowflake storage cost on your account — you only pay for the compute you use to query it. Contact us for pricing details.

Yes. We retain historical MRF snapshots so you can track rate changes over time. The historical depth depends on your plan.

You do. Queries run on your Snowflake warehouse, so you control the size, concurrency, and cost. The data share itself is read-only and adds no compute cost.

The share includes commercial payer negotiated rates from published MRFs — currently 200+ payers. It does not include Medicare fee schedules (those are public and free), Medicaid rates, or payers that have not yet published compliant MRFs.

Can't find what you're looking for? Contact our data team