#google cloud
3 posts
- Using WHERE inside aggregate functions
Filter the input rows of any BigQuery aggregate with WHERE. What it does, how it compares to HAVING MAX / HAVING MIN, and why it beats CASE WHEN.
- pre_ and post_operations in Dataform
Learn how to use pre_ and post_operations in Dataform to manage variables, incremental watermarks, cleanup logic, and post-run tasks.
- BigQuery BigLake Tables Explained: What They Are and When to Use Them
BigQuery BigLake tables improve on classic external tables with access delegation, row-level security, and metadata caching. Includes a SQL example.