BigQuery BigLake Tables Explained: What They Are and When to Use Them
Constantin Lungu
Command Palette
Search for a command to run...
Archive
205 posts published so far
BigQuery Saves Your Query Results — Here's How to Find Them
Constantin Lungu
Parameters in BigQuery
Constantin Lungu
Flattening JSON arrays in BigQuery
Constantin Lungu
Using LAST_VALUE with STRUCTS
Constantin Lungu
Table grain quick validation with SQL
Constantin Lungu
WITH expressions in BigQuery
Constantin Lungu
Beware of ROW_NUMBER without ORDER BY
Constantin Lungu
Aggregating Multiple SCD-2 Attribute Timelines in BigQuery
Constantin Lungu
Why you should think twice before UNNESTing arrays or date intervals
Constantin Lungu
Cross-dataset foreign key relationships in BigQuery
Constantin Lungu
Compacting date intervals in BigQuery
Constantin Lungu
Null-safe comparison: IS DISTINCT/NOT DISTINCT FROM
Constantin Lungu
Transforming cumulative sums into monthly values
Constantin Lungu
A quick walkthrough BigQuery Remote Functions
Constantin Lungu
Change history in BigQuery
Constantin Lungu
A quick overview of BigQuery functions
Constantin Lungu
Expressing multiple repeated joins as a correlated subquery
Constantin Lungu
Revisiting GROUP BY ROLLUP with a more realistic example
Constantin Lungu
Revisiting Why SQL’s Order of Execution Matters
Constantin Lungu
Exploring the BigQuery Query History
Constantin Lungu
How ARRAY() can function as UNPIVOT and UNNEST as PIVOT?
Constantin Lungu
Choosing the Right Ranking Function: Why Ties in SQL Matter
Constantin Lungu
A closer look at STRING_AGG in BigQuery
Constantin Lungu
Here's a great use case for GenAI writing SQL
Constantin Lungu