Skip to content
Developers
Get an API token

Bulk download views

The two views that list the full and diff zip files your account can download.

View MarkdownOpen in Claude(opens in a new tab)

Load a full zip once from DOWNLOADS_FULL, then apply the diff zips from DOWNLOADS_DIFF in RUN_ID order. Each row has a download URL that stops working 2 hours after you query it. See Delivery options for the full procedure.

Views live in NOVI_DATA_ACCESS.NOVI_WELLS. Column descriptions are from the Wells data dictionary, release 26.4.3.

6 columns

Full zip files you can download: the latest complete extract of each basin, one row per basin.

More about this view

Load a full zip once, then apply the diff zips of later runs from DOWNLOADS_DIFF to keep it current. Lists only the zips your account is entitled to; the USA zip needs every US basin.

Sample query
SELECT RUN_ID, BASIN, ZIP_NAME, RUN_AT_UTC, ZIP_SIZE_MB
FROM NOVI_DATA_ACCESS.NOVI_WELLS.DOWNLOADS_FULL
LIMIT 10
Columns6
RUN_ID
Run that produced the zip, as YYYYMMDD_HHMISS in UTC.
More

After you load the zip, your data matches this run.

BASIN
Basin the zip covers, or USA for the country zip that holds every US basin.
ZIP_NAME
Name of the zip, the same as BASIN.
More

The downloaded file has a different name, which contains RUN_ID.

RUN_AT_UTC
RUN_ID as a UTC timestamp.
ZIP_SIZE_MB
Size of the zip file in megabytes.
URL
Download link for the zip.
More

The link is created when you query the view and stops working 2 hours later; query the view again for a new link. A download that has started continues after the link expires.

9 columns

Diff zip files you can download, one row per basin per run.

More about this view

Each diff holds the changes from BASE_RUN_ID to RUN_ID, so it applies only on top of the data from BASE_RUN_ID. Apply diffs in RUN_ID order; if a BASE_RUN_ID is not the run you hold, download the full zip from DOWNLOADS_FULL instead. Lists only the zips your account is entitled to; the USA zip needs every US basin.

Sample query
SELECT BASE_RUN_ID, RUN_ID, BASIN, ZIP_NAME, DAYS_PRIOR
FROM NOVI_DATA_ACCESS.NOVI_WELLS.DOWNLOADS_DIFF
LIMIT 10
Columns9
BASE_RUN_ID
Run the diff starts from, as YYYYMMDD_HHMISS in UTC.
More

Apply the diff only to data from this run.

RUN_ID
Run that produced the zip, as YYYYMMDD_HHMISS in UTC.
More

After you apply the diff, your data matches this run.

BASIN
Basin the zip covers, or USA for the country zip that holds every US basin.
More

Joins to DOWNLOADS_FULL.BASIN.

ZIP_NAME
Name of the zip: the basin name followed by --DIFF.
More

The downloaded file has a different name, which contains RUN_ID.

DAYS_PRIOR
Position of this run among the diff runs: 1 for the newest, 2 for the run before it.
More

It counts runs, not calendar days; runs happen on weekdays only. The same value names the same run in every basin.

BASE_RUN_AT_UTC
BASE_RUN_ID as a UTC timestamp.
RUN_AT_UTC
RUN_ID as a UTC timestamp.
ZIP_SIZE_MB
Size of the zip file in megabytes.
URL
Download link for the zip.
More

The link is created when you query the view and stops working 2 hours later; query the view again for a new link. A download that has started continues after the link expires.