Skip to content
Developers
Get an API token

Novi UDM Data (v4)

Well-level US oil and gas data in one SQL data model, delivered through Snowflake, over HTTPS, or as bulk files.

View MarkdownOpen in Claude(opens in a new tab)

Query Novi’s well-level oil and gas data for the US Lower 48 with SQL, in one data model: Novi’s Unified Data Model (UDM). It lives in Snowflake: database NOVI_DATA_ACCESS, with the well dataset in schema NOVI_WELLS. The current release is 26.4.3, released 2026-10-29.

NOVI_WELLS holds 41 views: 10 presentation views that join the most-used data for you, 29 base views with full detail, and 2 that list bulk download files.

Group What you get Main views
Wells and wellbores Well and wellbore headers, surface locations, trajectories, directional survey stations WELL, WELLBORE, SURFACE_LOCATION
Production and tests Monthly and weekly volumes by stream, reported roll-ups, well tests PRODUCTION, WELL_PRODUCTION_SUMMARY, WELL_TEST
Completion and stimulation Completion design and intensity, FracFocus disclosures WELL_COMPLETION, FRAC_FOCUS_SUMMARY
Forecasts Monthly forecast volumes, Arps segments and parameters, county supply projections PRODUCTION_FORECAST, PRODUCTION_FORECAST_ARPS_SEGMENT
Spacing and subsurface Neighbor distances, parent and child, rock properties WELL_SPACING, SUBSURFACE_PROPERTY
Permits and well events Permit filings and one lifecycle timeline per well PLANNED_WELL, WELL_PERMIT, WELL_EVENT
Acreage, activity, and prices Company acreage parcels, rig and frac activity, weekly WTI and Henry Hub prices COMPANY_ACREAGE, RIG_FRAC_ACTIVITY, PRICE_WEEKLY
Reference lists Operators, operator contacts, basins, data lineage OPERATOR, BASIN, SOURCE

Start with WELL_DETAIL: one row per wellbore with location, completion design, production totals and spacing already joined.

A well is the surface location and its regulatory record. One well can have several wellbores, the holes drilled from it.

  • Well-level attributes join on WELL_KEY. Production, completions, well tests, spacing, forecasts and frac chemistry are per wellbore and join on WELLBORE_KEY.
  • To count wells, count distinct WELL_KEY values.

Every join: Data model. How keys are built: Well identifiers.

Novi-hosted reader account

Novi creates a Snowflake account for your team. Log in with the link in your welcome email. No Snowflake administrator needed.

Share into your Snowflake account

Novi shares the data to your own Snowflake account. Your administrator runs one setup script.

SQL over HTTPS

Send SQL to Snowflake’s SQL API with a programmatic access token. Works with either account type.

Bulk files

Download full and daily diff zips of tab-separated files per basin, built every weekday.

  • Country: United States. Canada is planned.
  • Basins: you see the basins in your subscription. Views keyed by a well or wellbore filter rows for you.
  • Reference lists such as operators, basins, and weekly prices are complete for every account.
  • Freshness: the data refreshes on a regular schedule. Each query returns the latest load.