#SQL
4 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 Object Tables: A Practical Introduction
Learn how BigQuery Object Tables work, how to create them, and how to use ML.GENERATE_TEXT to run AI inference on unstructured data stored in GCS.
- 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.