# Cookbook

Source: https://developers.novilabs.com/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 Wells](https://developers.novilabs.com/cookbook/wells/): Find wells, production and cumulatives, type wells, forecasts and decline, gunbarrels, rigs.
- [Novi Intelligence](https://developers.novilabs.com/cookbook/intelligence/): Basin research: inventory, rock quality, completion design, economics and breakevens, Arps curves.
- [Novi M&A Intelligence](https://developers.novilabs.com/cookbook/ma-intelligence/): Upstream deals: recent deals, deals by basin, deal value and metrics, valuation, advisors.

## Before you run a recipe

1. Connect to the `NOVI_DATA_ACCESS` database, as [Delivery](https://developers.novilabs.com/data/delivery/) describes.
2. Run `USE DATABASE NOVI_DATA_ACCESS;` once per session.
3. Change the filters in the recipe (basin, subbasin, formation, dates) to your own and run it.

Column meanings are in [Tables](https://developers.novilabs.com/data/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.
