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.
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.
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_ |
| Production and tests | Monthly and weekly volumes by stream, reported roll-ups, well tests | PRODUCTION, WELL_, WELL_ |
| Completion and stimulation | Completion design and intensity, FracFocus disclosures | WELL_, FRAC_ |
| Forecasts | Monthly forecast volumes, Arps segments and parameters, county supply projections | PRODUCTION_, PRODUCTION_ |
| Spacing and subsurface | Neighbor distances, parent and child, rock properties | WELL_, SUBSURFACE_ |
| Permits and well events | Permit filings and one lifecycle timeline per well | PLANNED_, WELL_, WELL_ |
| Acreage, activity, and prices | Company acreage parcels, rig and frac activity, weekly WTI and Henry Hub prices | COMPANY_, RIG_, PRICE_ |
| 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_KEY. Production, completions, well tests, spacing, forecasts and frac chemistry are per wellbore and join on WELLBORE_KEY.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.