Daily forecast production volumes

1. Integration overview

Dataset Name: Daily Forecast Production Volumes
Secure View: FORECAST_PRODUCTION_VOLUMES_DAILY_SV
Delivery Mechanism: Snowflake Secure View via Private Share
Update Pattern: Immutable / Append-Only
Export Trigger:

User-triggered from ComboCurve UI
Triggered via ComboCurve Export v2 (Snowflake export)

Data Retention: 30 days

2. Business context (Oil & Gas Reservoir Engineering)

This dataset provides daily measured production volumes per well for standard phases (Oil/Gas/Water) plus tenant-configured custom streams.
Unlike the “combined” datasets, this dataset contains production-only fields (no forecast and no stitched columns).

4. Expected record uniqueness

This dataset is append-only and may contain multiple exports for the same well and day.

The expected uniqueness constraint is:

(FORECAST_VOLUME_EXPORT_ID, WELL_ID, DATE)

5. Client access pattern

Query the secure view directly:

Primary access object: FORECAST_PRODUCTION_VOLUMES_DAILY_SV
Typical filters: FORECAST_VOLUME_EXPORT_ID (batch scoping); PROJECT_ID, FORECAST_ID, USER_ID, EXPORT_DATE (time window)

Example:

SELECT *
FROM SHARED_DATABASE.FORECAST_PRODUCTION_VOLUMES_DAILY_SV
WHERE PROJECT_ID = '<project_id>'
  AND FORECAST_ID = '<forecast_id>'
  AND DATE >= '2024-01-01';

Recommended filters:

FORECAST_VOLUME_EXPORT_ID (batch scoping)
PROJECT_ID
FORECAST_ID
USER_ID
DATE (time window)

6. Full schema definition (client-facing secure view)

Below is the schema for FORECAST_PRODUCTION_VOLUMES_DAILY_SV, grouped into data categories for easier consumption.

6.1 Well & cross-reference identifiers

Column	Data Type	Description
WELL_NAME	VARCHAR	Human-readable well name used in the source system.
WELL_NUMBER	VARCHAR	Engineering well number or identifier assigned by the operator.
API14	VARCHAR	14-digit API number uniquely identifying the wellbore.
INPTID	VARCHAR	INPT (PIDX) unique identifier for the well.
CHOSENID	VARCHAR	Chosen Energy cross-reference ID for the well.
ARIES_ID	VARCHAR	Well identifier in ARIES economic software.
PHDWIN_ID	VARCHAR	Well identifier in PHDWin reserves software.
PROJECT_ID	VARCHAR	ComboCurve project identifier.
FORECAST_ID	VARCHAR	Unique ID of the forecast case that produced these volumes.
USER_ID	VARCHAR	Identifier of the user who executed the export.
WELL_ID	VARCHAR	ComboCurve master well identifier.
FORECAST_VOLUME_EXPORT_ID	VARCHAR	GUID of the volume-export job.
EXPORT_DATE	TIMESTAMP_NTZ	UTC timestamp when the volume set was exported.
DATE	TIMESTAMP_NTZ	Calendar day represented by the row.

6.2 Daily production volumes (Oil/Gas/Water)

Column	Data Type	Description
OIL_PRODUCTION	FLOAT	Measured daily oil production.
GAS_PRODUCTION	FLOAT	Measured daily gas production.
WATER_PRODUCTION	FLOAT	Measured daily produced-water volume.

6.3 User-defined CustomNumber streams (0–19)

Column	Data Type	Description
CUSTOMNUMBER0_PRODUCTION	FLOAT	Measured daily volume for user-defined CustomNumber0.
CUSTOMNUMBER1_PRODUCTION	FLOAT	Measured daily volume for user-defined CustomNumber1.
CUSTOMNUMBER2_PRODUCTION	FLOAT	Measured daily volume for user-defined CustomNumber2.
CUSTOMNUMBER3_PRODUCTION	FLOAT	Measured daily volume for user-defined CustomNumber3.
CUSTOMNUMBER4_PRODUCTION	FLOAT	Measured daily volume for user-defined CustomNumber4.
CUSTOMNUMBER5_PRODUCTION	FLOAT	Measured daily volume for user-defined CustomNumber5.
CUSTOMNUMBER6_PRODUCTION	FLOAT	Measured daily volume for user-defined CustomNumber6.
CUSTOMNUMBER7_PRODUCTION	FLOAT	Measured daily volume for user-defined CustomNumber7.
CUSTOMNUMBER8_PRODUCTION	FLOAT	Measured daily volume for user-defined CustomNumber8.
CUSTOMNUMBER9_PRODUCTION	FLOAT	Measured daily volume for user-defined CustomNumber9.
CUSTOMNUMBER10_PRODUCTION	FLOAT	Measured daily volume for user-defined CustomNumber10.
CUSTOMNUMBER11_PRODUCTION	FLOAT	Measured daily volume for user-defined CustomNumber11.
CUSTOMNUMBER12_PRODUCTION	FLOAT	Measured daily volume for user-defined CustomNumber12.
CUSTOMNUMBER13_PRODUCTION	FLOAT	Measured daily volume for user-defined CustomNumber13.
CUSTOMNUMBER14_PRODUCTION	FLOAT	Measured daily volume for user-defined CustomNumber14.
CUSTOMNUMBER15_PRODUCTION	FLOAT	Measured daily volume for user-defined CustomNumber15.
CUSTOMNUMBER16_PRODUCTION	FLOAT	Measured daily volume for user-defined CustomNumber16.
CUSTOMNUMBER17_PRODUCTION	FLOAT	Measured daily volume for user-defined CustomNumber17.
CUSTOMNUMBER18_PRODUCTION	FLOAT	Measured daily volume for user-defined CustomNumber18.
CUSTOMNUMBER19_PRODUCTION	FLOAT	Measured daily volume for user-defined CustomNumber19.

6.4 Project custom streams (0–19)

Column	Data Type	Description
_PROJECT_CUSTOM_STREAM_0_PRODUCTION	FLOAT	Measured daily volume for project custom stream 0.
_PROJECT_CUSTOM_STREAM_1_PRODUCTION	FLOAT	Measured daily volume for project custom stream 1.
_PROJECT_CUSTOM_STREAM_2_PRODUCTION	FLOAT	Measured daily volume for project custom stream 2.
_PROJECT_CUSTOM_STREAM_3_PRODUCTION	FLOAT	Measured daily volume for project custom stream 3.
_PROJECT_CUSTOM_STREAM_4_PRODUCTION	FLOAT	Measured daily volume for project custom stream 4.
_PROJECT_CUSTOM_STREAM_5_PRODUCTION	FLOAT	Measured daily volume for project custom stream 5.
_PROJECT_CUSTOM_STREAM_6_PRODUCTION	FLOAT	Measured daily volume for project custom stream 6.
_PROJECT_CUSTOM_STREAM_7_PRODUCTION	FLOAT	Measured daily volume for project custom stream 7.
_PROJECT_CUSTOM_STREAM_8_PRODUCTION	FLOAT	Measured daily volume for project custom stream 8.
_PROJECT_CUSTOM_STREAM_9_PRODUCTION	FLOAT	Measured daily volume for project custom stream 9.
_PROJECT_CUSTOM_STREAM_10_PRODUCTION	FLOAT	Measured daily volume for project custom stream 10.
_PROJECT_CUSTOM_STREAM_11_PRODUCTION	FLOAT	Measured daily volume for project custom stream 11.
_PROJECT_CUSTOM_STREAM_12_PRODUCTION	FLOAT	Measured daily volume for project custom stream 12.
_PROJECT_CUSTOM_STREAM_13_PRODUCTION	FLOAT	Measured daily volume for project custom stream 13.
_PROJECT_CUSTOM_STREAM_14_PRODUCTION	FLOAT	Measured daily volume for project custom stream 14.
_PROJECT_CUSTOM_STREAM_15_PRODUCTION	FLOAT	Measured daily volume for project custom stream 15.
_PROJECT_CUSTOM_STREAM_16_PRODUCTION	FLOAT	Measured daily volume for project custom stream 16.
_PROJECT_CUSTOM_STREAM_17_PRODUCTION	FLOAT	Measured daily volume for project custom stream 17.
_PROJECT_CUSTOM_STREAM_18_PRODUCTION	FLOAT	Measured daily volume for project custom stream 18.
_PROJECT_CUSTOM_STREAM_19_PRODUCTION	FLOAT	Measured daily volume for project custom stream 19.

6.5 UI label mapping

Most columns appear in the ComboCurve UI under a simple title-cased version of the column name (OIL_PRODUCTION → "Oil", GAS_FORECAST → "Gas Forecast"). The exceptions are the cross-reference identifiers and the custom-stream columns below.

Watch out for these:

Custom streams are user-named. The CUSTOMNUMBER{0–19}_* columns carry the company's user-defined stream label in the UI (for example "NGL Yield"), not "Custom Number 0". The underlying token is camelCase (customNumber0) — contrast the snake_case CUSTOM_NUMBER_0 form used in the production-volume datasets.

Project custom streams are off by one. _PROJECT_CUSTOM_STREAM_{i}_* is 0-indexed in the column name, but the UI default label is 1-indexed — _PROJECT_CUSTOM_STREAM_0_* shows as "Project Custom Stream 1".

Snowflake column	ComboCurve UI label
INPTID	INPT ID
CHOSENID	Chosen ID
API14	API 14
ARIES_ID	Aries ID
PHDWIN_ID	PhdWin ID

7. Incremental consumption best practices

Pull only new or changed records

For scheduled ingestion, pull rows where EXPORT_DATE is after your last run, or scope to a single export batch by FORECAST_VOLUME_EXPORT_ID.

SELECT *
FROM FORECAST_PRODUCTION_VOLUMES_DAILY_SV
WHERE EXPORT_DATE > DATEADD(day, -1, CURRENT_TIMESTAMP);

Pull a single export batch (recommended)

SELECT *
FROM FORECAST_PRODUCTION_VOLUMES_DAILY_SV
WHERE FORECAST_VOLUME_EXPORT_ID = '<export-guid>';

Deduplicate by the secure-view key

Treat the record key as (FORECAST_VOLUME_EXPORT_ID, WELL_ID, DATE) when loading a single export batch, or (PROJECT_ID, FORECAST_ID, USER_ID, EXPORT_DATE) when deduplicating across batches. Multiple exports for the same well and day are expected across batches.

8. Operational notes

Data is immutable once exported.
Multiple exports of the same well and day are expected across batches.
The secure view is a pass-through (SELECT *) over the base table.