Warehouse SQL

Write and run finance queries against BigQuery or Snowflake with point-in-time correctness, close-cutoff and timezone discipline, slowly-changing-dimension handling, cost-aware execution (dry-run byte estimates, partition pruning), and reproducible query artifacts. Use for any warehouse query whose result will become a reported number. Trigger on "BigQuery", "Snowflake", "SQL", "query the warehouse", "pull the data", "bq", "snowsql", "dbt", "why is this query slow", "why did the number change".

Lukehle Updated 1 repo stars

File contents

Lukehle/closeloop commit 52a7c95261

Frequently asked questions

npx get-skill add lukehle/warehouse-sql