Novi Intelligence recipes
Ready-to-run Snowflake SQL recipes for Novi Intelligence, from the cookbook your welcome email points to.
These recipes query the NOVI_INTEL schema. They match Novi Intelligence release 26.2.4, the release your account reads, and the full cookbook your welcome email points to holds the same SQL.
Run this once per session first:
USE DATABASE NOVI_DATA_ACCESS;1. Basin overview
Section titled “1. Basin overview”Basin-level summary: well counts by development class (PDP vs planned inventory: Base Case + Emerging).
It reproduces Basin Report cover page well counts.
Tables: WELL, PLANNED_WELL, BASIN.
PDP wells by basin and subbasin
SELECT w.BASIN, w.SUBBASIN, w.REPORT_NAME, COUNT(*) AS pdp_well_countFROM NOVI_INTEL.WELL wGROUP BY w.BASIN, w.SUBBASIN, w.REPORT_NAMEORDER BY w.BASIN, w.SUBBASINBase Case / Emerging inventory by basin
SELECT pw.BASIN, pw.SUBBASIN, pw.REPORT_NAME, COUNT(*) AS planned_well_count, COUNT(CASE WHEN pw.INVENTORY_CLASS = 'BASE_CASE' THEN 1 END) AS base_case_count, COUNT(CASE WHEN pw.INVENTORY_CLASS = 'EMERGING' THEN 1 END) AS emerging_countFROM NOVI_INTEL.PLANNED_WELL pwGROUP BY pw.BASIN, pw.SUBBASIN, pw.REPORT_NAMEORDER BY pw.BASIN, pw.SUBBASINCombined PDP + planned inventory by basin (planned covers BASE_CASE + EMERGING)
SELECT BASIN, SUM(CASE WHEN dev_class = 'PDP' THEN cnt ELSE 0 END) AS pdp, SUM(CASE WHEN dev_class = 'PLANNED' THEN cnt ELSE 0 END) AS planned, SUM(cnt) AS totalFROM ( SELECT BASIN, 'PDP' AS dev_class, COUNT(*) AS cnt FROM NOVI_INTEL.WELL GROUP BY BASIN UNION ALL SELECT BASIN, 'PLANNED' AS dev_class, COUNT(*) AS cnt FROM NOVI_INTEL.PLANNED_WELL GROUP BY BASIN) xGROUP BY BASINORDER BY total DESC2. Well header by operator
Section titled “2. Well header by operator”Well header with operator, formation, and wellbore geometry.
It reproduces Report Figures 11-14 (well counts by operator, formation, county).
Tables: WELL, WELLBORE, OPERATOR.
Well count by operator (top 10)
SELECT o.NAME_NORMALIZED AS operator, COUNT(*) AS well_countFROM NOVI_INTEL.WELL wJOIN NOVI_INTEL.OPERATOR o ON w.OPERATOR_ID = o.OPERATOR_IDGROUP BY o.NAME_NORMALIZEDORDER BY well_count DESCLIMIT 10Well count by formation (from wellbore, since formation moved from well to wellbore)
SELECT wb.FORMATION AS formation, COUNT(DISTINCT w.WELL_ID) AS well_countFROM NOVI_INTEL.WELL wJOIN NOVI_INTEL.WELLBORE wb ON wb.WELL_ID = w.WELL_IDWHERE w.BASIN = 'Haynesville'GROUP BY wb.FORMATIONORDER BY well_count DESCWell header detail: well + wellbore + operator joined
SELECT w.UWI_API, o.NAME_NORMALIZED AS operator, w.BASIN, w.SUBBASIN, w.STATUS, w.FIRST_PRODUCTION_DATE, wb.FORMATION, wb.LATERAL_LENGTH, wb.TVD_TD, wb.MD_TDFROM NOVI_INTEL.WELL wJOIN NOVI_INTEL.WELLBORE wb ON wb.WELL_ID = w.WELL_IDJOIN NOVI_INTEL.OPERATOR o ON w.OPERATOR_ID = o.OPERATOR_IDWHERE w.BASIN = 'Haynesville'ORDER BY w.FIRST_PRODUCTION_DATE DESC NULLS LASTLIMIT 203. Production forecast EUR
Section titled “3. Production forecast EUR”Production forecast EUR and type curve analysis.
It reproduces Executive Summary EUR estimates and forecast volumes.
Tables: WELL_ECONOMICS_SUMMARY, WELL, OPERATOR.
For what P10 and P90 mean in each Novi product, see P-levels.
EUR by operator (gas-focused, Haynesville)
SELECT o.NAME_NORMALIZED AS operator, COUNT(*) AS well_count, ROUND(AVG(es.EUR_GAS_30YR), 0) AS avg_eur_gas_mcf, ROUND(AVG(es.EUR_DRY_GAS_30YR), 0) AS avg_eur_dry_gas_mcf, ROUND(AVG(es.EUR_NGL_30YR), 0) AS avg_eur_ngl_bbl, ROUND(AVG(es.IP_GAS), 1) AS avg_ip_gas_mcfdFROM NOVI_INTEL.WELL_ECONOMICS_SUMMARY esJOIN NOVI_INTEL.WELL w ON es.WELL_ID = w.WELL_IDJOIN NOVI_INTEL.OPERATOR o ON w.OPERATOR_ID = o.OPERATOR_IDWHERE w.BASIN = 'Haynesville' AND es.WELL_ID IS NOT NULL -- PDP wells onlyGROUP BY o.NAME_NORMALIZEDHAVING COUNT(*) >= 10ORDER BY avg_eur_gas_mcf DESCEUR distribution by formation
SELECT wb.FORMATION, COUNT(*) AS well_count, ROUND(PERCENTILE_CONT(0.10) WITHIN GROUP (ORDER BY es.EUR_GAS_30YR), 0) AS p10_eur_gas, ROUND(PERCENTILE_CONT(0.50) WITHIN GROUP (ORDER BY es.EUR_GAS_30YR), 0) AS p50_eur_gas, ROUND(PERCENTILE_CONT(0.90) WITHIN GROUP (ORDER BY es.EUR_GAS_30YR), 0) AS p90_eur_gasFROM NOVI_INTEL.WELL_ECONOMICS_SUMMARY esJOIN NOVI_INTEL.WELL w ON es.WELL_ID = w.WELL_IDJOIN NOVI_INTEL.WELLBORE wb ON wb.WELL_ID = w.WELL_IDWHERE w.BASIN = 'Haynesville'GROUP BY wb.FORMATIONORDER BY p50_eur_gas DESCDaily forecast for a sample well (first 365 days)
Note: PRODUCTION_FORECAST only has PLANNED_WELL_ID (WELL_ID is NULL), so query via PLANNED_WELL_ID directly.
SELECT pf.PLANNED_WELL_ID, pf.FORECAST_DAY, pf.GAS_PER_DAY, pf.CUMULATIVE_GAS, pf.WATER_PER_DAY, pf.CUMULATIVE_WATERFROM NOVI_INTEL.PRODUCTION_FORECAST pfWHERE pf.PLANNED_WELL_ID IS NOT NULL AND pf.BASIN = 'Haynesville' AND pf.FORECAST_DAY <= 365ORDER BY pf.PLANNED_WELL_ID, pf.FORECAST_DAYLIMIT 504. Economics breakeven
Section titled “4. Economics breakeven”Well economics: NPV, IRR, breakeven analysis.
It reproduces Report Figure 1 (Remaining vs Drilled by NPV25 Breakeven Tranche) and Executive Summary average NPV25 breakeven of $3.06/Mcf.
Tables: WELL_ECONOMICS_SUMMARY, WELL, PLANNED_WELL, ECON_PRICE_ASSUMPTION.
Average breakeven and NPV by basin (all planned inventory: Base Case + Emerging)
For Base Case only, add: AND pw.INVENTORY_CLASS = ‘BASE_CASE’ to the WHERE clause.
SELECT pw.BASIN, COUNT(*) AS planned_well_count, ROUND(AVG(es.BREAKEVEN_1YR), 2) AS avg_breakeven_1yr, ROUND(AVG(es.NPV25_BREAKEVEN), 2) AS avg_npv25_breakeven, ROUND(AVG(es.IRR * 100), 1) AS avg_irr_pct, ROUND(AVG(es.PAYBACK_MONTHS), 0) AS avg_payback_monthsFROM NOVI_INTEL.WELL_ECONOMICS_SUMMARY esJOIN NOVI_INTEL.PLANNED_WELL pw ON es.PLANNED_WELL_ID = pw.PLANNED_WELL_IDWHERE pw.BASIN = 'Haynesville'GROUP BY pw.BASINNPV25 breakeven tranche distribution (all planned inventory)
Matches Report Figure 1: % drilled vs undrilled by breakeven bracket.
SELECT CASE WHEN es.NPV25_BREAKEVEN <= 1.5 THEN '<= $1.50/Mcf' WHEN es.NPV25_BREAKEVEN <= 2.0 THEN '<= $2.00/Mcf' WHEN es.NPV25_BREAKEVEN <= 2.5 THEN '<= $2.50/Mcf' WHEN es.NPV25_BREAKEVEN <= 3.0 THEN '<= $3.00/Mcf' WHEN es.NPV25_BREAKEVEN <= 3.5 THEN '<= $3.50/Mcf' ELSE '> $3.50/Mcf' END AS breakeven_tranche, COUNT(*) AS location_count, ROUND(AVG(es.NPV10), 0) AS avg_npv10_usd, ROUND(AVG(es.IRR * 100), 1) AS avg_irr_pctFROM NOVI_INTEL.WELL_ECONOMICS_SUMMARY esJOIN NOVI_INTEL.PLANNED_WELL pw ON es.PLANNED_WELL_ID = pw.PLANNED_WELL_IDWHERE pw.BASIN = 'Haynesville'GROUP BY breakeven_trancheORDER BY breakeven_trancheRemaining planned-inventory value by discount rate (Base Case + Emerging)
SELECT pw.BASIN, ROUND(SUM(es.NPV5), 0) AS total_npv5_usd, ROUND(SUM(es.NPV10), 0) AS total_npv10_usd, ROUND(SUM(es.NPV25), 0) AS total_npv25_usdFROM NOVI_INTEL.WELL_ECONOMICS_SUMMARY esJOIN NOVI_INTEL.PLANNED_WELL pw ON es.PLANNED_WELL_ID = pw.PLANNED_WELL_IDWHERE pw.BASIN = 'Haynesville'GROUP BY pw.BASINPrice deck assumptions
SELECT epa.NAME, epa.OIL_PRICE AS wti_price, epa.GAS_PRICE AS hh_price, epa.NGL_PRICE, epa.OIL_PRICE_DIFFERENTIAL AS wti_diff, epa.GAS_PRICE_DIFFERENTIAL AS hh_diffFROM NOVI_INTEL.ECON_PRICE_ASSUMPTION epa5. Rock quality tiers
Section titled “5. Rock quality tiers”Rock quality tier analysis by operator and formation.
It reproduces Executive Summary Figures 1-2 (PDP / Base Case by tier), Report Figure 2 ~5.2k tier-1, ~5.4k tier-2, ~6.1k tier-3, ~5.9k tier-4.
Tables: WELL_ROCK_QUALITY, WELL, PLANNED_WELL, OPERATOR.
Tier distribution for PDP wells (drilled)
SELECT rq.ROCK_QUALITY_TIER, COUNT(*) AS well_countFROM NOVI_INTEL.WELL_ROCK_QUALITY rqWHERE rq.WELL_CLASS = 'PDP' AND rq.BASIN = 'Haynesville' AND rq.STREAM = 'gas'GROUP BY rq.ROCK_QUALITY_TIERORDER BY rq.ROCK_QUALITY_TIERTier distribution for Base Case wells (remaining inventory)
SELECT rq.ROCK_QUALITY_TIER, COUNT(*) AS location_countFROM NOVI_INTEL.WELL_ROCK_QUALITY rqWHERE rq.WELL_CLASS = 'BASE_CASE' AND rq.BASIN = 'Haynesville' AND rq.STREAM = 'gas'GROUP BY rq.ROCK_QUALITY_TIERORDER BY rq.ROCK_QUALITY_TIEROperator benchmarking: remaining inventory weighting by tier
Reproduces: Report Figure 2 (Estimated Operated Remaining Location Weighting).
SELECT o.NAME_NORMALIZED AS operator, COUNT(*) AS total_locations, COUNT(CASE WHEN rq.ROCK_QUALITY_TIER = 'Tier-1' THEN 1 END) AS tier_1, COUNT(CASE WHEN rq.ROCK_QUALITY_TIER = 'Tier-2' THEN 1 END) AS tier_2, COUNT(CASE WHEN rq.ROCK_QUALITY_TIER = 'Tier-3' THEN 1 END) AS tier_3, COUNT(CASE WHEN rq.ROCK_QUALITY_TIER = 'Tier-4' THEN 1 END) AS tier_4, ROUND(100.0 * COUNT(CASE WHEN rq.ROCK_QUALITY_TIER IN ('Tier-1', 'Tier-2') THEN 1 END) / NULLIF(COUNT(*), 0), 1) AS pct_top_tierFROM NOVI_INTEL.WELL_ROCK_QUALITY rqJOIN NOVI_INTEL.OPERATOR o ON rq.OPERATOR_ID = o.OPERATOR_IDWHERE rq.WELL_CLASS = 'BASE_CASE' AND rq.BASIN = 'Haynesville' AND rq.STREAM = 'gas'GROUP BY o.NAME_NORMALIZEDHAVING COUNT(*) >= 50ORDER BY pct_top_tier DESCRock quality by formation
SELECT rq.FORMATION, rq.ROCK_QUALITY_TIER, COUNT(*) AS cntFROM NOVI_INTEL.WELL_ROCK_QUALITY rqWHERE rq.BASIN = 'Haynesville' AND rq.STREAM = 'gas'GROUP BY rq.FORMATION, rq.ROCK_QUALITY_TIERORDER BY rq.FORMATION, rq.ROCK_QUALITY_TIER6. Completion design
Section titled “6. Completion design”Completion design analysis: proppant, fluid, lateral length trends.
It reproduces Report Figures 18-21 (lateral length over time, proppant/rig efficiency).
Tables: WELL_COMPLETION, WELLBORE, WELL, OPERATOR.
Average completion design metrics (all wells by basin)
Note: WELL_COMPLETION only has PLANNED_WELL_ID (WELL_ID is NULL).
SELECT wc.BASIN, COUNT(*) AS well_count, ROUND(AVG(wc.LATERAL_LENGTH_FT), 0) AS avg_lateral_ft, ROUND(AVG(wc.PROPPANT_MASS), 0) AS avg_proppant_lbs, ROUND(AVG(wc.FLUID_VOLUME), 0) AS avg_fluid_gal, ROUND(AVG(wc.PROPPANT_LOADING), 0) AS avg_proppant_lbs_per_ftFROM NOVI_INTEL.WELL_COMPLETION wcWHERE wc.BASIN = 'Haynesville'GROUP BY wc.BASINLong lateral trend (>12,500 ft)
Reproduces: Report Figure 19.
SELECT YEAR(w.FIRST_PRODUCTION_DATE) AS fpy, COUNT(*) AS total_wells, COUNT(CASE WHEN wb.LATERAL_LENGTH > 12500 THEN 1 END) AS long_laterals, ROUND(100.0 * COUNT(CASE WHEN wb.LATERAL_LENGTH > 12500 THEN 1 END) / NULLIF(COUNT(*), 0), 1) AS pct_long_lateralFROM NOVI_INTEL.WELL wJOIN NOVI_INTEL.WELLBORE wb ON wb.WELL_ID = w.WELL_IDWHERE w.BASIN = 'Haynesville' AND w.FIRST_PRODUCTION_DATE IS NOT NULLGROUP BY fpyORDER BY fpyCompletion design by operator (top 10)
Join to OPERATOR via WELLBORE -> WELL or PLANNED_WELL for operator name.
SELECT o.NAME_NORMALIZED AS operator, COUNT(*) AS well_count, ROUND(AVG(wc.LATERAL_LENGTH_FT), 0) AS avg_lateral_ft, ROUND(AVG(wc.PROPPANT_LOADING), 0) AS avg_proppant_lbs_per_ft, ROUND(AVG(wc.FLUID_LOADING), 0) AS avg_fluid_gal_per_ftFROM NOVI_INTEL.WELL_COMPLETION wcJOIN NOVI_INTEL.PLANNED_WELL pw ON pw.PLANNED_WELL_ID = wc.PLANNED_WELL_IDJOIN NOVI_INTEL.OPERATOR o ON o.OPERATOR_ID = pw.OPERATOR_IDWHERE wc.BASIN = 'Haynesville'GROUP BY o.NAME_NORMALIZEDHAVING COUNT(*) >= 20ORDER BY well_count DESCLIMIT 107. Arps decline curve
Section titled “7. Arps decline curve”Arps decline curve parameters per well per stream. ARPS_FORECAST pre-joins the segment structure with the Arps parameters (qi, Di, b), so reconstructing the decline model is a single SELECT.
View: ARPS_FORECAST.
Arps segments for wells in the Williston basin
Note: Arps segments are keyed by WELL_REF (UWI_API for completed wells, ‘PW-<planned_well_id>’ for planned wells).
SELECT WELL_REF, STREAM, SEGMENT_NUMBER, SEGMENT_CURVE_TYPE, DAY_START, DAY_STOP, B_FACTOR, NOMINAL_DECLINE_RATE AS di, SEGMENT_START_RATE AS qi, SEGMENT_END_RATEFROM NOVI_INTEL.ARPS_FORECASTWHERE BASIN = 'Williston'ORDER BY WELL_REF, STREAM, SEGMENT_NUMBERLIMIT 50Average Arps parameters by basin (oil stream, segment 1 only)
Note: Haynesville has no arps data; Williston, Permian, Appalachia do.
SELECT BASIN, COUNT(*) AS segment_count, ROUND(AVG(B_FACTOR), 3) AS avg_b_factor, ROUND(AVG(NOMINAL_DECLINE_RATE), 4) AS avg_di, ROUND(AVG(SEGMENT_START_RATE), 1) AS avg_qiFROM NOVI_INTEL.ARPS_FORECASTWHERE STREAM = 'oil' AND SEGMENT_NUMBER = 1GROUP BY BASINORDER BY avg_qi DESC8. Cost summary
Section titled “8. Cost summary”D&C and DCET cost analysis by operator and basin.
It reproduces Inventory sheet cost columns.
Tables: WELL_COST_SUMMARY, WELL, PLANNED_WELL, OPERATOR.
Average D&C costs by operator (PDP wells)
SELECT o.NAME_NORMALIZED AS operator, COUNT(*) AS well_count, ROUND(AVG(cs.TOTAL_DC_COST), 0) AS avg_dc_cost_usd, ROUND(AVG(cs.TOTAL_DCET_COST), 0) AS avg_dcet_cost_usd, ROUND(AVG(cs.NORMALIZED_DC_COST_PER_FT), 0) AS avg_dc_per_ft_usd, ROUND(AVG(cs.NORMALIZED_DCET_COST_PER_FT), 0) AS avg_dcet_per_ft_usdFROM NOVI_INTEL.WELL_COST_SUMMARY csJOIN NOVI_INTEL.WELL w ON cs.WELL_ID = w.WELL_IDJOIN NOVI_INTEL.OPERATOR o ON w.OPERATOR_ID = o.OPERATOR_IDWHERE w.BASIN = 'Haynesville'GROUP BY o.NAME_NORMALIZEDHAVING COUNT(*) >= 10ORDER BY avg_dc_cost_usdCost breakdown: D&C vs equip + tie-in by basin
Note: the intelligence inventory source carries only total D&C and DCET costs, not a discrete drilling / completion / facilities / other split (those columns are always NULL for rows from basin research), so the equip + tie-in portion is derived as DCET - D&C.
SELECT w.BASIN, COUNT(*) AS well_count, ROUND(AVG(cs.TOTAL_DC_COST), 0) AS avg_dc_cost_usd, ROUND(AVG(cs.TOTAL_DCET_COST), 0) AS avg_dcet_cost_usd, ROUND(AVG(cs.TOTAL_DCET_COST - cs.TOTAL_DC_COST), 0) AS avg_equip_tiein_usdFROM NOVI_INTEL.WELL_COST_SUMMARY csJOIN NOVI_INTEL.WELL w ON cs.WELL_ID = w.WELL_IDWHERE w.BASIN = 'Haynesville'GROUP BY w.BASIN9. Inventory by operator
Section titled “9. Inventory by operator”Remaining inventory analysis by operator.
It reproduces Report “Total Remaining by Operator” sheet and Figure 2.
Tables: PLANNED_WELL, WELLBORE, OPERATOR, WELL_ECONOMICS_SUMMARY.
Remaining Base Case locations by operator with economics
SELECT o.NAME_NORMALIZED AS operator, COUNT(*) AS remaining_locations, ROUND(AVG(pw.LATERAL_LENGTH), 0) AS avg_lateral_ft, ROUND(SUM(pw.LATERAL_LENGTH), 0) AS total_lateral_ft, ROUND(AVG(es.NPV25_BREAKEVEN), 2) AS avg_npv25_breakeven, ROUND(AVG(es.IRR * 100), 1) AS avg_irr_pctFROM NOVI_INTEL.PLANNED_WELL pwJOIN NOVI_INTEL.OPERATOR o ON pw.OPERATOR_ID = o.OPERATOR_IDLEFT JOIN NOVI_INTEL.WELL_ECONOMICS_SUMMARY es ON es.PLANNED_WELL_ID = pw.PLANNED_WELL_IDWHERE pw.BASIN = 'Haynesville' AND pw.INVENTORY_CLASS = 'BASE_CASE'GROUP BY o.NAME_NORMALIZEDHAVING COUNT(*) >= 20ORDER BY remaining_locations DESCImplied inventory life at current drilling cadence
Assumes ~500 wells/year (~4.9 MM ft/year) based on 2023-2024 cadence.
SELECT o.NAME_NORMALIZED AS operator, COUNT(*) AS remaining_locations, ROUND(SUM(pw.LATERAL_LENGTH), 0) AS total_remaining_ft, ROUND(SUM(pw.LATERAL_LENGTH) / 4900000.0, 1) AS implied_years_at_basin_cadenceFROM NOVI_INTEL.PLANNED_WELL pwJOIN NOVI_INTEL.OPERATOR o ON pw.OPERATOR_ID = o.OPERATOR_IDWHERE pw.BASIN = 'Haynesville' AND pw.INVENTORY_CLASS = 'BASE_CASE'GROUP BY o.NAME_NORMALIZEDHAVING COUNT(*) >= 50ORDER BY implied_years_at_basin_cadence DESCInventory by pad (planned wells grouped by pad)
SELECT p.NAME AS pad_name, p.OPERATOR_NAME, p.BASIN, COUNT(pw.PLANNED_WELL_ID) AS wells_on_padFROM NOVI_INTEL.PAD pJOIN NOVI_INTEL.PLANNED_WELL pw ON pw.PAD_ID = p.PAD_IDWHERE p.BASIN = 'Haynesville'GROUP BY p.NAME, p.OPERATOR_NAME, p.BASINORDER BY wells_on_pad DESCLIMIT 2011. Data freshness
Section titled “11. Data freshness”Check which basin reports are loaded and when they were last refreshed. Useful for verifying data currency before analysis.
Tables: SOURCE, WELL, BASIN.
Available basin reports
SELECT s.COLLECTION AS report_name, s.SYSTEM, MIN(s.CREATED_AT) AS first_loaded, COUNT(DISTINCT w.WELL_ID) AS well_countFROM NOVI_INTEL.SOURCE sLEFT JOIN NOVI_INTEL.WELL w ON w.SOURCE_ID = s.SOURCE_IDGROUP BY s.COLLECTION, s.SYSTEMORDER BY s.COLLECTIONBasin dimension: all available basins and subbasins
SELECT b.BASIN, b.SUBBASINFROM NOVI_INTEL.BASIN bORDER BY b.BASIN, b.SUBBASINRow counts per entity (data completeness check)
SELECT 'WELL' AS entity, COUNT(*) AS row_count FROM NOVI_INTEL.WELLUNION ALL SELECT 'WELLBORE', COUNT(*) FROM NOVI_INTEL.WELLBOREUNION ALL SELECT 'PLANNED_WELL', COUNT(*) FROM NOVI_INTEL.PLANNED_WELLUNION ALL SELECT 'WELL_COMPLETION', COUNT(*) FROM NOVI_INTEL.WELL_COMPLETIONUNION ALL SELECT 'PRODUCTION_FORECAST', COUNT(*) FROM NOVI_INTEL.PRODUCTION_FORECASTUNION ALL SELECT 'WELL_ECONOMICS_SUMMARY', COUNT(*) FROM NOVI_INTEL.WELL_ECONOMICS_SUMMARYUNION ALL SELECT 'WELL_ROCK_QUALITY', COUNT(*) FROM NOVI_INTEL.WELL_ROCK_QUALITYUNION ALL SELECT 'WELL_COST_SUMMARY', COUNT(*) FROM NOVI_INTEL.WELL_COST_SUMMARYORDER BY entity12. Oil basin economics
Section titled “12. Oil basin economics”Oil-focused economics for basins like Williston (Bakken/Three Forks). Haynesville uses $/Mcf (gas) breakevens, Williston uses $/bbl (oil) breakevens.
It reproduces Williston Exec Summary avg NPV25 breakeven ~$89/bbl (WTI).
Tables: WELL_ECONOMICS_SUMMARY, PLANNED_WELL, OPERATOR.
NPV25 breakeven tranche distribution ($/bbl for oil basins)
SELECT CASE WHEN es.NPV25_BREAKEVEN <= 40 THEN '<= $40/bbl' WHEN es.NPV25_BREAKEVEN <= 50 THEN '<= $50/bbl' WHEN es.NPV25_BREAKEVEN <= 60 THEN '<= $60/bbl' WHEN es.NPV25_BREAKEVEN <= 70 THEN '<= $70/bbl' WHEN es.NPV25_BREAKEVEN <= 80 THEN '<= $80/bbl' WHEN es.NPV25_BREAKEVEN <= 90 THEN '<= $90/bbl' ELSE '> $90/bbl' END AS breakeven_tranche, COUNT(*) AS location_count, ROUND(AVG(es.IRR * 100), 1) AS avg_irr_pct, ROUND(AVG(es.PAYBACK_MONTHS), 0) AS avg_payback_monthsFROM NOVI_INTEL.WELL_ECONOMICS_SUMMARY esJOIN NOVI_INTEL.PLANNED_WELL pw ON es.PLANNED_WELL_ID = pw.PLANNED_WELL_IDWHERE pw.BASIN = 'Williston'GROUP BY breakeven_trancheORDER BY breakeven_trancheOil EUR by operator (Williston is oil-primary)
SELECT o.NAME_NORMALIZED AS operator, COUNT(*) AS well_count, ROUND(AVG(es.EUR_OIL_30YR), 0) AS avg_eur_oil_bbl, ROUND(AVG(es.EUR_GAS_30YR), 0) AS avg_eur_gas_mcf, ROUND(AVG(es.IP_OIL), 1) AS avg_ip_oil_bpd, ROUND(AVG(es.NGL_YIELD), 1) AS avg_ngl_yieldFROM NOVI_INTEL.WELL_ECONOMICS_SUMMARY esJOIN NOVI_INTEL.WELL w ON es.WELL_ID = w.WELL_IDJOIN NOVI_INTEL.OPERATOR o ON w.OPERATOR_ID = o.OPERATOR_IDWHERE w.BASIN = 'Williston'GROUP BY o.NAME_NORMALIZEDHAVING COUNT(*) >= 20ORDER BY avg_eur_oil_bbl DESCTwo-year payout breakeven by first production year
Williston report: wells drilled now to 2030 can generate sub-$70/bbl payout.
SELECT YEAR(w.FIRST_PRODUCTION_DATE) AS fpy, COUNT(*) AS well_count, ROUND(AVG(es.BREAKEVEN_2YR), 2) AS avg_2yr_breakeven, ROUND(AVG(es.PAYBACK_MONTHS), 0) AS avg_payback_monthsFROM NOVI_INTEL.WELL_ECONOMICS_SUMMARY esJOIN NOVI_INTEL.WELL w ON es.WELL_ID = w.WELL_IDWHERE w.BASIN = 'Williston' AND w.FIRST_PRODUCTION_DATE IS NOT NULLGROUP BY fpyORDER BY fpy13. Base case vs emerging inventory
Section titled “13. Base case vs emerging inventory”Base Case vs Emerging inventory split. Williston: ~37.8k Base Case + ~5.2k Emerging locations.
It reproduces Exec Summary “37,801 Base Case locations and 5,184 Emerging locations”.
Tables: PLANNED_WELL, WELL_ROCK_QUALITY, OPERATOR.
Base Case vs Emerging counts by basin
SELECT pw.BASIN, pw.INVENTORY_CLASS, COUNT(*) AS location_count, ROUND(AVG(pw.LATERAL_LENGTH), 0) AS avg_lateral_ftFROM NOVI_INTEL.PLANNED_WELL pwGROUP BY pw.BASIN, pw.INVENTORY_CLASSORDER BY pw.BASIN, pw.INVENTORY_CLASSRock quality tier distribution by well class (Base Case vs Emerging)
SELECT rq.WELL_CLASS, rq.ROCK_QUALITY_TIER, COUNT(*) AS location_countFROM NOVI_INTEL.WELL_ROCK_QUALITY rqWHERE rq.BASIN = 'Williston' AND rq.WELL_CLASS IN ('BASE_CASE', 'EMERGING') AND rq.STREAM = 'oil'GROUP BY rq.WELL_CLASS, rq.ROCK_QUALITY_TIERORDER BY rq.WELL_CLASS, rq.ROCK_QUALITY_TIERTop operators by Base Case + Emerging inventory
SELECT o.NAME_NORMALIZED AS operator, COUNT(CASE WHEN pw.INVENTORY_CLASS = 'BASE_CASE' THEN 1 END) AS base_case_count, COUNT(CASE WHEN pw.INVENTORY_CLASS = 'EMERGING' THEN 1 END) AS emerging_count, COUNT(*) AS totalFROM NOVI_INTEL.PLANNED_WELL pwJOIN NOVI_INTEL.OPERATOR o ON pw.OPERATOR_ID = o.OPERATOR_IDWHERE pw.BASIN = 'Williston'GROUP BY o.NAME_NORMALIZEDORDER BY total DESCLIMIT 1514. Multi formation comparison
Section titled “14. Multi formation comparison”Compare performance across formations within a basin. Williston: Middle Bakken vs Three Forks (primary targets). Haynesville: Haynesville Shale vs Bossier Shale.
It reproduces Report Figures 13-14 (production by formation).
Tables: WELLBORE, WELL, WELL_ECONOMICS_SUMMARY, WELL_ROCK_QUALITY.
Well count and EUR by formation (Williston)
SELECT wb.FORMATION, COUNT(DISTINCT w.WELL_ID) AS pdp_well_count, ROUND(AVG(es.EUR_OIL_30YR), 0) AS avg_eur_oil_bbl, ROUND(AVG(es.EUR_GAS_30YR), 0) AS avg_eur_gas_mcf, ROUND(AVG(es.IP_OIL), 1) AS avg_ip_oil_bpd, ROUND(AVG(wb.LATERAL_LENGTH), 0) AS avg_lateral_ftFROM NOVI_INTEL.WELL wJOIN NOVI_INTEL.WELLBORE wb ON wb.WELL_ID = w.WELL_IDLEFT JOIN NOVI_INTEL.WELL_ECONOMICS_SUMMARY es ON es.WELL_ID = w.WELL_IDWHERE w.BASIN = 'Williston'GROUP BY wb.FORMATIONHAVING COUNT(DISTINCT w.WELL_ID) >= 10ORDER BY pdp_well_count DESCRock quality tier distribution by formation
SELECT rq.FORMATION, rq.ROCK_QUALITY_TIER, COUNT(*) AS cnt, ROUND(100.0 * COUNT(*) / SUM(COUNT(*)) OVER (PARTITION BY rq.FORMATION), 1) AS pctFROM NOVI_INTEL.WELL_ROCK_QUALITY rqWHERE rq.BASIN = 'Williston' AND rq.STREAM = 'oil' AND rq.WELL_CLASS = 'BASE_CASE'GROUP BY rq.FORMATION, rq.ROCK_QUALITY_TIERORDER BY rq.FORMATION, rq.ROCK_QUALITY_TIERAverage breakeven by formation (all planned inventory: Base Case + Emerging)
For Base Case only, add: AND pw.INVENTORY_CLASS = ‘BASE_CASE’ to the WHERE clause.
SELECT wb.FORMATION, COUNT(*) AS planned_well_count, ROUND(AVG(es.NPV25_BREAKEVEN), 2) AS avg_npv25_breakeven, ROUND(AVG(es.BREAKEVEN_2YR), 2) AS avg_2yr_breakevenFROM NOVI_INTEL.WELL_ECONOMICS_SUMMARY esJOIN NOVI_INTEL.PLANNED_WELL pw ON es.PLANNED_WELL_ID = pw.PLANNED_WELL_IDJOIN NOVI_INTEL.WELLBORE wb ON wb.PLANNED_WELL_ID = pw.PLANNED_WELL_IDWHERE pw.BASIN = 'Williston'GROUP BY wb.FORMATIONHAVING COUNT(*) >= 50ORDER BY avg_npv25_breakeven15. Cross basin comparison
Section titled “15. Cross basin comparison”Compare key metrics across all loaded basins. Useful when your subscription covers several basins.
Tables: WELL, PLANNED_WELL, WELL_ECONOMICS_SUMMARY, WELL_ROCK_QUALITY.
Basin-level summary card
SELECT BASIN, COUNT(*) AS pdp_wellsFROM NOVI_INTEL.WELLGROUP BY BASINORDER BY pdp_wells DESCBase Case inventory and economics by basin
SELECT pw.BASIN, COUNT(*) AS base_case_locations, ROUND(AVG(es.NPV25_BREAKEVEN), 2) AS avg_npv25_breakeven, ROUND(AVG(es.IRR * 100), 1) AS avg_irr_pct, ROUND(AVG(es.PAYBACK_MONTHS), 0) AS avg_payback_months, ROUND(AVG(es.EUR_OIL_30YR), 0) AS avg_eur_oil_bbl, ROUND(AVG(es.EUR_GAS_30YR), 0) AS avg_eur_gas_mcfFROM NOVI_INTEL.PLANNED_WELL pwLEFT JOIN NOVI_INTEL.WELL_ECONOMICS_SUMMARY es ON es.PLANNED_WELL_ID = pw.PLANNED_WELL_IDWHERE pw.INVENTORY_CLASS = 'BASE_CASE'GROUP BY pw.BASINORDER BY base_case_locations DESCRock quality distribution comparison across basins
SELECT rq.BASIN, rq.ROCK_QUALITY_TIER, COUNT(*) AS cntFROM NOVI_INTEL.WELL_ROCK_QUALITY rqWHERE rq.WELL_CLASS = 'BASE_CASE'GROUP BY rq.BASIN, rq.ROCK_QUALITY_TIERORDER BY rq.BASIN, rq.ROCK_QUALITY_TIERTop operators across all basins (counts all planned inventory: Base Case + Emerging)
For Base Case only, add: AND pw.INVENTORY_CLASS = ‘BASE_CASE’ to the LEFT JOIN ON clause.
SELECT o.NAME_NORMALIZED AS operator, COUNT(DISTINCT w.BASIN) AS basins_active, COUNT(DISTINCT w.WELL_ID) AS total_pdp_wells, COUNT(DISTINCT pw.PLANNED_WELL_ID) AS total_planned_locationsFROM NOVI_INTEL.OPERATOR oLEFT JOIN NOVI_INTEL.WELL w ON w.OPERATOR_ID = o.OPERATOR_IDLEFT JOIN NOVI_INTEL.PLANNED_WELL pw ON pw.OPERATOR_ID = o.OPERATOR_IDGROUP BY o.NAME_NORMALIZEDHAVING COUNT(DISTINCT w.WELL_ID) > 0 OR COUNT(DISTINCT pw.PLANNED_WELL_ID) > 0ORDER BY total_pdp_wells + total_planned_locations DESCLIMIT 20Completion design evolution comparison across basins
Average completion design by basin (all wells). Note: WELL_COMPLETION only has PLANNED_WELL_ID (WELL_ID is NULL).
SELECT wc.BASIN, COUNT(*) AS well_count, ROUND(AVG(wc.LATERAL_LENGTH_FT), 0) AS avg_lateral_ft, ROUND(AVG(wc.PROPPANT_LOADING), 0) AS avg_proppant_lbs_per_ftFROM NOVI_INTEL.WELL_COMPLETION wcGROUP BY wc.BASINORDER BY wc.BASIN16. Breakeven by stream
Section titled “16. Breakeven by stream”Breakeven analysis faceted by commodity stream. The STREAM column on WELL_ECONOMICS_SUMMARY lets you separate breakevens by commodity unit basis. Without this faceting, gas wells (avg ~$3/MMBtu HH) and oil wells (avg ~$57/bbl WTI) get co-mingled on the same color scale, which makes gas basins dominate the lower end. Important: STREAM is a well-classification tag, NOT a unit discriminator. Wet Gas wells are tagged ‘ngl’ (consistent with WELL_ROCK_QUALITY.STREAM) but their breakeven values are still in gas $/MMBtu units. For unit-aware faceting: STREAM IN (‘gas’, ‘ngl’) -> gas-unit breakevens ($/MMBtu HH). STREAM = ‘oil’ -> oil-unit breakevens ($/bbl WTI).
Tables: WELL_ECONOMICS_SUMMARY, WELL, PLANNED_WELL, BASIN.
Average breakeven by basin and stream (UNION across drilled + planned for full coverage)
WITH well_basin_econ AS ( SELECT e.STREAM, e.NPV10_BREAKEVEN, b.BASIN AS basin_name FROM NOVI_INTEL.WELL_ECONOMICS_SUMMARY e JOIN NOVI_INTEL.WELL w ON w.WELL_ID = e.WELL_ID JOIN NOVI_INTEL.BASIN b ON b.BASIN_ID = w.BASIN_ID WHERE e.WELL_ID IS NOT NULL UNION ALL SELECT e.STREAM, e.NPV10_BREAKEVEN, b.BASIN AS basin_name FROM NOVI_INTEL.WELL_ECONOMICS_SUMMARY e JOIN NOVI_INTEL.PLANNED_WELL pw ON pw.PLANNED_WELL_ID = e.PLANNED_WELL_ID JOIN NOVI_INTEL.BASIN b ON b.BASIN_ID = pw.BASIN_ID WHERE e.PLANNED_WELL_ID IS NOT NULL)SELECT basin_name, STREAM, ROUND(AVG(NPV10_BREAKEVEN), 2) AS avg_npv10_breakeven, ROUND(MIN(NPV10_BREAKEVEN), 2) AS min_breakeven, ROUND(MAX(NPV10_BREAKEVEN), 2) AS max_breakeven, COUNT(*) AS wellsFROM well_basin_econWHERE STREAM IN ('oil', 'gas', 'ngl')GROUP BY 1, 2ORDER BY 1, 2Gas-unit breakeven only (STREAM IN (‘gas’, ‘ngl’)): color-by-breakeven on a single map
WITH well_basin_econ AS ( SELECT e.STREAM, e.NPV10_BREAKEVEN, b.BASIN AS basin_name FROM NOVI_INTEL.WELL_ECONOMICS_SUMMARY e JOIN NOVI_INTEL.WELL w ON w.WELL_ID = e.WELL_ID JOIN NOVI_INTEL.BASIN b ON b.BASIN_ID = w.BASIN_ID WHERE e.WELL_ID IS NOT NULL UNION ALL SELECT e.STREAM, e.NPV10_BREAKEVEN, b.BASIN AS basin_name FROM NOVI_INTEL.WELL_ECONOMICS_SUMMARY e JOIN NOVI_INTEL.PLANNED_WELL pw ON pw.PLANNED_WELL_ID = e.PLANNED_WELL_ID JOIN NOVI_INTEL.BASIN b ON b.BASIN_ID = pw.BASIN_ID WHERE e.PLANNED_WELL_ID IS NOT NULL)SELECT basin_name, ROUND(AVG(NPV10_BREAKEVEN), 2) AS avg_be_per_mmbtu, COUNT(*) AS wellsFROM well_basin_econWHERE STREAM IN ('gas', 'ngl')GROUP BY 1ORDER BY 2Oil-unit breakeven only (STREAM = ‘oil’)
WITH well_basin_econ AS ( SELECT e.STREAM, e.NPV10_BREAKEVEN, b.BASIN AS basin_name FROM NOVI_INTEL.WELL_ECONOMICS_SUMMARY e JOIN NOVI_INTEL.WELL w ON w.WELL_ID = e.WELL_ID JOIN NOVI_INTEL.BASIN b ON b.BASIN_ID = w.BASIN_ID WHERE e.WELL_ID IS NOT NULL UNION ALL SELECT e.STREAM, e.NPV10_BREAKEVEN, b.BASIN AS basin_name FROM NOVI_INTEL.WELL_ECONOMICS_SUMMARY e JOIN NOVI_INTEL.PLANNED_WELL pw ON pw.PLANNED_WELL_ID = e.PLANNED_WELL_ID JOIN NOVI_INTEL.BASIN b ON b.BASIN_ID = pw.BASIN_ID WHERE e.PLANNED_WELL_ID IS NOT NULL)SELECT basin_name, ROUND(AVG(NPV10_BREAKEVEN), 2) AS avg_be_per_bbl, COUNT(*) AS wellsFROM well_basin_econWHERE STREAM = 'oil'GROUP BY 1ORDER BY 217. Well master overview
Section titled “17. Well master overview”Unified well inventory: PDP + Base Case + Emerging in one view. REPORT_NAME identifies the basin report quarter (e.g., ‘basin_research__Midland_Basin__2025Q3’).
Basin summary: count by inventory class (single report)
SELECT BASIN, INVENTORY_CLASS, COUNT(*) AS well_countFROM NOVI_INTEL.WELL_MASTERWHERE REPORT_NAME = 'basin_research__Midland_Basin__2025Q3'GROUP BY 1, 2 ORDER BY 1, 2Top 10 operators by total inventory
SELECT OPERATOR_NAME, COUNT(*) AS total_wells, COUNT(CASE WHEN INVENTORY_CLASS = 'PDP' THEN 1 END) AS pdp, COUNT(CASE WHEN INVENTORY_CLASS = 'BASE_CASE' THEN 1 END) AS base_case, COUNT(CASE WHEN INVENTORY_CLASS = 'EMERGING' THEN 1 END) AS emergingFROM NOVI_INTEL.WELL_MASTERGROUP BY 1 ORDER BY total_wells DESC LIMIT 10Available reports
SELECT REPORT_NAME, INVENTORY_CLASS, COUNT(*) AS well_countFROM NOVI_INTEL.WELL_MASTERGROUP BY 1, 2 ORDER BY 1, 2Wells with geometry for a specific report (for GIS mapping)
SELECT WELL_REF, INVENTORY_CLASS, LATITUDE, LONGITUDE, GEOMETRY_GEO, OPERATOR_NAME, FORMATIONFROM NOVI_INTEL.WELL_MASTERWHERE GEOMETRY_GEO IS NOT NULL AND REPORT_NAME = 'basin_research__Midland_Basin__2025Q3'LIMIT 10018. Economics scorecard
Section titled “18. Economics scorecard”Economics scorecard: breakevens faceted by stream (oil vs gas vs ngl). Note: STREAM is a well-classification tag, NOT a unit discriminator. Wet Gas wells are tagged ‘ngl’ but breakeven values are in gas $/MMBtu. For unit-aware faceting: STREAM IN (‘gas’,‘ngl’) = gas-unit, STREAM = ‘oil’ = oil-unit.
Average breakeven by stream for a specific report
SELECT REPORT_NAME, STREAM, COUNT(*) AS wells, ROUND(AVG(NPV10_BREAKEVEN), 2) AS avg_npv10_be, ROUND(AVG(IRR * 100), 1) AS avg_irr_pct, ROUND(AVG(PAYBACK_MONTHS), 0) AS avg_paybackFROM NOVI_INTEL.WELL_ECONOMICSWHERE STREAM IN ('oil', 'gas', 'ngl') AND REPORT_NAME = 'basin_research__Midland_Basin__2025Q3'GROUP BY 1, 2 ORDER BY 1, 2Oil-only: top basins by NPV10 (cross-report comparison)
SELECT BASIN, REPORT_NAME, COUNT(*) AS wells, ROUND(SUM(NPV10), 0) AS total_npv10_usd, ROUND(AVG(NPV10_BREAKEVEN), 2) AS avg_be_per_bblFROM NOVI_INTEL.WELL_ECONOMICSWHERE STREAM = 'oil'GROUP BY 1, 2 ORDER BY total_npv10_usd DESCCross-view join: economics + well master for operator benchmarking (single report)
SELECT wm.OPERATOR_NAME, wm.BASIN, COUNT(*) AS wells, ROUND(AVG(we.NPV10_BREAKEVEN), 2) AS avg_be, ROUND(AVG(we.IRR * 100), 1) AS avg_irr_pct, ROUND(AVG(wm.LATERAL_LENGTH), 0) AS avg_lateral_ftFROM NOVI_INTEL.WELL_ECONOMICS weJOIN NOVI_INTEL.WELL_MASTER wm USING (WELL_REF)WHERE we.STREAM = 'oil' AND we.REPORT_NAME = 'basin_research__Midland_Basin__2025Q3'GROUP BY 1, 2 HAVING COUNT(*) >= 20ORDER BY avg_be19. ML score analysis
Section titled “19. ML score analysis”Rock quality scores by stream and tier.
Tier distribution by basin (gas stream)
SELECT BASIN, ROCK_QUALITY_TIER, COUNT(*) AS well_countFROM NOVI_INTEL.ML_SCOREWHERE STREAM = 'gas'GROUP BY 1, 2 ORDER BY 1, 2Average score by operator (oil, Base Case only)
SELECT OPERATOR_NAME, COUNT(*) AS locations, ROUND(AVG(ROCK_QUALITY_SCORE), 3) AS avg_score, COUNT(CASE WHEN ROCK_QUALITY_TIER IN ('Tier-1','Tier-2') THEN 1 END) AS top_tier_count, ROUND(100.0 * COUNT(CASE WHEN ROCK_QUALITY_TIER IN ('Tier-1','Tier-2') THEN 1 END) / NULLIF(COUNT(*), 0), 1) AS pct_top_tierFROM NOVI_INTEL.ML_SCOREWHERE STREAM = 'oil' AND INVENTORY_CLASS = 'BASE_CASE'GROUP BY 1 HAVING COUNT(*) >= 50ORDER BY pct_top_tier DESCCross-view: economics + rock quality for tier-weighted breakeven
SELECT ms.ROCK_QUALITY_TIER, COUNT(*) AS wells, ROUND(AVG(we.NPV10_BREAKEVEN), 2) AS avg_be, ROUND(AVG(we.IRR * 100), 1) AS avg_irr_pctFROM NOVI_INTEL.ML_SCORE msJOIN NOVI_INTEL.WELL_ECONOMICS we USING (WELL_REF)WHERE ms.STREAM = 'oil' AND ms.BASIN = 'Permian'GROUP BY 1 ORDER BY 120. Inventory forecast
Section titled “20. Inventory forecast”Time-series production forecast for Base Case / Emerging inventory.
First 5 years of monthly oil forecast for a report
SELECT WELL_REF, OPERATOR_NAME, YEAR, MONTH, OIL_PER_DAY, CUMULATIVE_OILFROM NOVI_INTEL.INVENTORY_FORECASTWHERE REPORT_NAME = 'basin_research__Midland_Basin__2025Q3' AND FORECAST_DAY <= 1825ORDER BY WELL_REF, FORECAST_DAYLIMIT 100Basin-level aggregate forecast by year (derived from FORECAST_DAY)
YEAR/MONTH columns are NULL in intelligence data; use FORECAST_DAY instead.
SELECT BASIN, FLOOR(FORECAST_DAY / 365) + 1 AS forecast_year, COUNT(DISTINCT WELL_REF) AS wells, ROUND(AVG(OIL_PER_DAY), 0) AS avg_oil_bpd, ROUND(AVG(GAS_PER_DAY), 0) AS avg_gas_mcfdFROM NOVI_INTEL.INVENTORY_FORECASTWHERE FORECAST_DAY <= 1825GROUP BY 1, 2 ORDER BY 1, 221. Arps decline parameters
Section titled “21. Arps decline parameters”Arps decline curve parameters by basin and stream.
Average decline parameters by basin (oil, segment 1)
SELECT BASIN, COUNT(*) AS segment_count, ROUND(AVG(B_FACTOR), 3) AS avg_b, ROUND(AVG(NOMINAL_DECLINE_RATE), 4) AS avg_di, ROUND(AVG(SEGMENT_START_RATE), 1) AS avg_qiFROM NOVI_INTEL.ARPS_FORECASTWHERE STREAM = 'oil' AND SEGMENT_NUMBER = 1GROUP BY 1 ORDER BY avg_qi DESCFull decline model for a specific report
SELECT WELL_REF, STREAM, SEGMENT_NUMBER, SEGMENT_CURVE_TYPE, B_FACTOR, NOMINAL_DECLINE_RATE AS di, SEGMENT_START_RATE AS qi, SEGMENT_END_RATE, DAY_START, DAY_STOPFROM NOVI_INTEL.ARPS_FORECASTWHERE REPORT_NAME = 'basin_research__Williston_Basin__2025Q4'ORDER BY WELL_REF, STREAM, SEGMENT_NUMBERLIMIT 5022. Report deep dive
Section titled “22. Report deep dive”Single-report deep dive using all 5 presentation views. Replace the REPORT_NAME value with any loaded report (e.g., ‘basin_research__Midland_Basin__2025Q3’, ‘basin_research__Haynesville_Basin__2025Q4’, ‘basin_research__Delaware_Basin__2025Q3’).
1. Well Master: full inventory for the report
SELECT WELL_REF, INVENTORY_CLASS, OPERATOR_NAME, FORMATION, LATERAL_LENGTH, LATITUDE, LONGITUDE, STATUSFROM NOVI_INTEL.WELL_MASTERWHERE REPORT_NAME = 'basin_research__Midland_Basin__2025Q3'ORDER BY INVENTORY_CLASS, OPERATOR_NAME2. Well Economics: breakeven + returns for the report
SELECT WELL_REF, INVENTORY_CLASS, STREAM, OPERATOR_NAME, NPV10_BREAKEVEN, IRR, PAYBACK_MONTHS, EUR_OIL_30YR, EUR_GAS_30YR, TOTAL_DCET_COSTFROM NOVI_INTEL.WELL_ECONOMICSWHERE REPORT_NAME = 'basin_research__Midland_Basin__2025Q3'ORDER BY NPV10_BREAKEVEN3. ML Score: rock quality distribution for the report
SELECT WELL_REF, INVENTORY_CLASS, STREAM, ROCK_QUALITY_SCORE, ROCK_QUALITY_TIER, OPERATOR_NAMEFROM NOVI_INTEL.ML_SCOREWHERE REPORT_NAME = 'basin_research__Midland_Basin__2025Q3'ORDER BY ROCK_QUALITY_SCORE DESC4. Inventory Forecast: first-year rates for the report (YEAR is NULL; use FORECAST_DAY)
SELECT WELL_REF, NAME, OPERATOR_NAME, SCENARIO, FORECAST_DAY, OIL_PER_DAY, GAS_PER_DAY, CUMULATIVE_OIL, CUMULATIVE_GASFROM NOVI_INTEL.INVENTORY_FORECASTWHERE REPORT_NAME = 'basin_research__Midland_Basin__2025Q3' AND FORECAST_DAY <= 365ORDER BY WELL_REF, FORECAST_DAYLIMIT 1005. Arps Forecast: decline parameters for the report
SELECT WELL_REF, STREAM, SEGMENT_NUMBER, B_FACTOR, NOMINAL_DECLINE_RATE AS di, SEGMENT_START_RATE AS qi, SEGMENT_END_RATE, DAY_START, DAY_STOPFROM NOVI_INTEL.ARPS_FORECASTWHERE REPORT_NAME = 'basin_research__Midland_Basin__2025Q3'ORDER BY WELL_REF, STREAM, SEGMENT_NUMBER6. Cross-view: report summary dashboard
SELECT wm.INVENTORY_CLASS, COUNT(DISTINCT wm.WELL_REF) AS total_wells, ROUND(AVG(we.NPV10_BREAKEVEN), 2) AS avg_breakeven, ROUND(AVG(we.IRR * 100), 1) AS avg_irr_pct, ROUND(AVG(wm.LATERAL_LENGTH), 0) AS avg_lateral_ft, ROUND(AVG(ms.ROCK_QUALITY_SCORE), 2) AS avg_rq_scoreFROM NOVI_INTEL.WELL_MASTER wmLEFT JOIN NOVI_INTEL.WELL_ECONOMICS we ON we.WELL_REF = wm.WELL_REF AND we.REPORT_NAME = wm.REPORT_NAMELEFT JOIN NOVI_INTEL.ML_SCORE ms ON ms.WELL_REF = wm.WELL_REF AND ms.REPORT_NAME = wm.REPORT_NAME AND ms.STREAM = 'oil'WHERE wm.REPORT_NAME = 'basin_research__Midland_Basin__2025Q3'GROUP BY 1 ORDER BY 1Join patterns
Section titled “Join patterns”Most queries join through the WELL or PLANNED_WELL tables as the central dimension:
WELL → WELLBORE (geometry, formation)WELL → OPERATOR (name, contact)WELL → WELL_COMPLETION (proppant, fluid)WELL → WELL_ECONOMICS_SUMMARY (NPV, IRR, EUR)WELL → WELL_COST_SUMMARY (D&C costs)WELL → WELL_ROCK_QUALITY (ML tier scores)WELL → PRODUCTION_FORECAST (daily rates)WELL → ARPS_FORECAST (presentation view: pre-joined Arps qi, Di, b)- Monetary values (NPV, PV, costs) are stored as exact decimals (
NUMBER(28,7)) in whole currency units: query them directly, no scaling. - IRR is stored as a decimal fraction (0.15 = 15%). Multiply by 100 for percentage.
- Formation is on
WELLBORE, notWELL. BASINandSUBBASINcolumns are available on all entity views for filtering.REPORT_NAMEidentifies which basin research report the data came from.- A report can carry more than one price deck;
PRICE_DECK_IDis scoped to its report, and a forward-curve deck has NULL headline prices.