# Novi UDM Data (v4)

Source: https://developers.novilabs.com/data/

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

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.

- [Upstream Energy Data on novilabs.com](https://novilabs.com/energy-analytics/upstream-data/): Accurate oil and gas upstream data, sourced from public and private channels and refined by Novi's reservoir engineers.

## What is in it

`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.

## Grain: wells and wellbores

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](https://developers.novilabs.com/data/model/). How keys are built: [Well identifiers](https://developers.novilabs.com/data/identifiers/).

## How you get it

  **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.
  

- [Compare delivery options](https://developers.novilabs.com/data/delivery/): Steps, who sets it up, and what each path grants.

## Coverage and access

- **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.

> **Note:**
> The same `NOVI_DATA_ACCESS` database can also hold other Novi datasets, each with its own subscription:
> `NOVI_INTEL` (Novi Intelligence basin research data), `NOVI_MA_INTEL` (upstream M&A deals), and `NOVI_NDN` (contributor-supplied well header and completion data).
> This section documents `NOVI_WELLS`.

## Next steps

  - [All views](https://developers.novilabs.com/data/tables/): Every view with its columns, types, and units.
  - [Cookbook](https://developers.novilabs.com/cookbook/): Ready-to-run SQL for Novi Wells, Novi Intelligence and Novi M&A Intelligence.
  - [Releases and versioning](https://developers.novilabs.com/data/releases/): Release numbers, the current release and how versions are supported.
  - [Moving from v3](https://developers.novilabs.com/data/migrate-from-v3/): What changes when you move from the v3 REST API or bulk export.
