Skip to content

Instantly share code, notes, and snippets.

View aveer28's full-sized avatar

Aveer Ramnath aveer28

View GitHub Profile
@sayle-doit
sayle-doit / bq_project_storage_model_recommendation.sql
Last active October 26, 2023 09:18
BigQuery project dataset storage model recommendations
/*
* This query will look at a single project (by default in US multi-region) and
* calculate the logical and physical billing prices for each dataset inside of it
* then provide a recommendation on whether to keep it on logical storage
* or switch to the physical billing model.
*
* Physical (also called compressed) Storage will be GA and released for public
* consumption on July 5, 2023.
*
* It also includes inside of the storage CTE lots of extra values that can be used