§ Snowflake Marketplace
One share into your Snowflake account.
The full PropRaven dataset — including the larger source-side coverage that hasn't yet been promoted to the public API (building permits, deed transactions, entity resolution, FEMA flood polygons) — lives in our Snowflake Marketplace listing.
A share into your Snowflake account. No data movement, no ETL.
Listing in review
The Snowflake Marketplace listing is in review, so it cannot be subscribed to yet. Access today is a direct share by request: email sales@propraven.com with your Snowflake account identifier and the listings and states you need.
In the share
- • 191.3M parcels (129.0M carry coordinates) with 620 catalogued columns (44 rebuilt every epoch and 576 carried from an April 2026 reference export; 56 of the 620 are withheld from sale while they are rebuilt)
- • 157M+ permit records
- • 10M+ title transfers
- • Entity resolution (73K+ entities, officers, parents)
- • FEMA flood polygons (5.5M)
- • ACS demographics, FEMA risk, climate scoring
- • CMBS loans + properties
Pricing
Snowflake delivery is sold as an annual Data License; see /pricing.
Freshness as of 2026-10-15: PROPRAVEN_PARCEL_INTELLIGENCE (the 620-column parcels table) was refreshed on 2026-10-15 from the parcels gateway's current per-state builds (most states 2026-10-12; ID 2026-10-11; CT 2026-10-04-rw1; WI 2026-10-18), loaded by serverless Snowpipe. The Ontology share's silver tables were refreshed the same day from silver built on that per-state map; its derived graph and intelligence tables (owner portfolio, ownership edges, distress, value-add, institutional ownership, lender exposure) are from the 2026-08-28 build.
Nine listings, one truth
What is in the share
The catalog ships as nine Snowflake listings with three access modes: a wide table for engineers integrating a single feature, a knowledge graph for analysts who traverse ownership, and pre-filtered vertical cohorts for specific buyers. Every listing is cut from the same underlying tables, so a customer with Parcel Intelligence can layer in the Ontology share or any vertical bundle without redundant ingestion, and queries written against the free Preview run unchanged against any paid share — swap PROPRAVEN_PREVIEW for the paid share name.
| Listing | Share name | Contents | Refresh |
|---|---|---|---|
| Parcel Intelligence | PROPRAVEN_PARCEL_INTELLIGENCE | Marquee wide table — 191.3M parcels × 620 catalogued columns. AVM, FEMA NRI, demographics, HMDA, crime, climate, permits, deeds, owner-entity resolution. One row per parcel. | Per parcel build |
| Ontology | PROPRAVEN_ONTOLOGY | Resolved knowledge graph — 12 canonical entities, 166M+ ownership edges, confidence-scored signals. Same truth as Parcel Intelligence, different access shape. | Per parcel build |
| Lending | PROPRAVEN_LENDING | 12.6K recorded loans (feed being re-expanded) + canonical lenders + per-lender exposure rollup with distress overlay, pre-joined to property and owner context. | Per parcel build |
| Insurance | PROPRAVEN_INSURANCE | Per-parcel multi-peril risk vector — FEMA NRI rated (~92% coverage), NFIP claim history, NOAA storms, USGS seismic, CDC SVI, wildfire. | Per parcel build |
| Banking Marketplace | PROPRAVEN_BANKING_MARKETPLACE | Every U.S. bank branch with deposits, ownership chain, geocoded location. Pre-computed branch stability scores, MSA market share, antitrust HHI. | Per parcel build |
| SFR | PROPRAVEN_SFR | Residential parcels (SFR / MF_SMALL / CONDO / MOBILE) with absentee classification, institutional flag, recent transfer. | Per parcel build |
| CRE | PROPRAVEN_CRE | Commercial / industrial / multifamily / mixed-use parcels with owner graph and intelligence signals. | Per parcel build |
| GovTech | PROPRAVEN_GOVTECH | 191.3M parcels with addresses, property attributes, tax and assessment fields where the county publishes them, 157M+ permit records, and the full Census geographic hierarchy. No owner data. | Per parcel build |
| Preview (Free) | PROPRAVEN_PREVIEW | Free 10K-parcel Mecklenburg County NC sample of every entity. Same schema as the paid catalog. No commitment required to evaluate. | Per parcel build |
Each listing has its own page in the catalog docs; the refresh table and the stable-ID / confidence model are on methodology & versioning.
Schemas
How the share is laid out
Each share exposes the same three schemas. SILVER holds the normalized entities — PARCEL, PROPERTY, TAX_RECORD, PERMIT, OWNER, GEOGRAPHY — under stable, deterministic PropRaven IDs (prpv_*) that survive county refreshes and APN re-issuance. GOLD_GRAPH carries the resolved ownership edges (EDGE_OWNER_PARCEL). GOLD_INTELLIGENCE ships the pre-computed signals — PARCEL_ABSENTEE, PARCEL_INSTITUTIONAL_OWNED, PARCEL_RECENT_TRANSFER, OWNER_PORTFOLIO — so you get the insight rather than re-deriving it. Parcel Intelligence adds the single wide view, CURATED.V_MARKETPLACE_NATIONAL. Per-row _LOADED_AT and _SOURCE_AS_OF columns expose actual freshness for any row in a query result, and every column on every entity is defined in the data dictionary.
The sample below is the Preview listing's own — top owners in Mecklenburg County by assessed value. Point it at a paid share name for the national answer.
SELECT
o.name_normalized AS owner,
o.entity_type,
op.parcel_count,
ROUND(op.total_assessed_value / 1e6, 1) AS total_av_m
FROM PROPRAVEN_PREVIEW.SILVER.OWNER o
JOIN PROPRAVEN_PREVIEW.GOLD_INTELLIGENCE.OWNER_PORTFOLIO op USING (prpv_owner_id)
WHERE op.parcel_count >= 5
ORDER BY op.total_assessed_value DESC
LIMIT 25;More ready-to-run SQL across parcels, owners, signals and the vertical bundles is on sample queries.
Getting the share
How to request access
- Email sales@propraven.com with your Snowflake account identifier. The recommended starting point is Preview (free) — a 10,000-parcel Mecklenburg County, NC sample with 100% schema parity — or Parcel Intelligence for the wide table.
- Accept the direct share by creating a database from it (requirements below).
- Run the sample queries against the share in Snowsight, then layer in Ontology or a vertical bundle as needed.
While the listing is in review, every share is a direct share: request one and tell us which listings and which states you need. Custom share requests, or coverage requirements that do not fit a published listing, go to the same address. Not on Snowflake? The Databricks Delta Sharing share, Parquet on Cloudflare R2 and CSV export are compared on bulk parcel data, and the Property Data API serves the same records one parcel at a time.
Requirements
Access and requirements
- Listing status (2026-10-15). The Snowflake Marketplace listing is in review, so it cannot be subscribed to yet.
- Access today. Access is a direct share by request: email sales@propraven.com with your Snowflake account identifier and the listings and states you need. It is not self-serve yet.
- Requirements. The provider account runs on AWS (region on request). To accept the share you need a role with
IMPORT SHAREandCREATE DATABASE(standard Snowflake share acceptance), so you can create a database from the share. - Cost. Snowflake delivery is sold as a Data License; see /pricing.