Bulk download views
The two views that list the full and diff zip files your account can download.
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.
DOWNLOADS_FULL
Section titled “DOWNLOADS_FULL”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.
SELECT RUN_ID, BASIN, ZIP_NAME, RUN_AT_UTC, ZIP_SIZE_MBFROM NOVI_DATA_ACCESS.NOVI_WELLS.DOWNLOADS_FULLLIMIT 10- RUN_ID
- Run that produced the zip, as
YYYYMMDD_HHMISSin 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_IDas 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.
No columns match. Try a shorter word.
DOWNLOADS_DIFF
Section titled “DOWNLOADS_DIFF”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.
SELECT BASE_RUN_ID, RUN_ID, BASIN, ZIP_NAME, DAYS_PRIORFROM NOVI_DATA_ACCESS.NOVI_WELLS.DOWNLOADS_DIFFLIMIT 10- BASE_RUN_ID
- Run the diff starts from, as
YYYYMMDD_HHMISSin UTC.More
Apply the diff only to data from this run.
- RUN_ID
- Run that produced the zip, as
YYYYMMDD_HHMISSin 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_IDas a UTC timestamp.- RUN_AT_UTC
RUN_IDas 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.
No columns match. Try a shorter word.