Cookbook
Ready-to-run Snowflake SQL recipes for Novi Wells, Novi Intelligence and Novi M&A Intelligence, one collection per dataset.
Paste a recipe into a Snowflake worksheet to answer one engineering question. Each collection matches the release your account reads today. Your welcome email points to the full cookbook.
Novi WellsFind wells, production and cumulatives, type wells, forecasts and decline, gunbarrels, rigs.
Novi IntelligenceBasin research: inventory, rock quality, completion design, economics and breakevens, Arps curves.
Novi M&A IntelligenceUpstream deals: recent deals, deals by basin, deal value and metrics, valuation, advisors.
Before you run a recipe
Section titled “Before you run a recipe”- Connect to the
NOVI_DATA_ACCESSdatabase, as Delivery describes. - Run
USE DATABASE NOVI_DATA_ACCESS;once per session. - Change the filters in the recipe (basin, subbasin, formation, dates) to your own and run it.
Column meanings are in Tables. Recipes that name a company or a specific well are in the full cookbook only: see “In the notebook only” or “More recipes” on each page.