Using INCLUDE NULLS with UNPIVOT in BigQuery
Constantin Lungu
Command Palette
Search for a command to run...
Archive
207 posts published so far
Watch out when using SAFE_CAST in BigQuery
Constantin Lungu
Rolling period calculation in BigQuery
Constantin Lungu
Generating date intervals in BigQuery
Constantin Lungu
DATETIME vs TIMESTAMP in BigQuery
Constantin Lungu
Using RANGE in Window Functions in BigQuery
Constantin Lungu
Computing a cumulative sum in BigQuery
Constantin Lungu
Optimizing storage costs in BigQuery
Constantin Lungu
Optimizing compute cost in BigQuery
Constantin Lungu
Leveraging ARRAYS in BigQuery for query performance
Constantin Lungu
Decorators in Python
Constantin Lungu
Using COUNTIF() in BigQuery
Constantin Lungu
Partial functions in Python
Constantin Lungu
Approximate Aggregate Functions in BigQuery
Constantin Lungu
Using ARRAY_CONCAT_AGG() in BigQuery
Constantin Lungu
Using ANY_VALUE() in BigQUERY
Constantin Lungu
Using LOGICAL_AND and LOGICAL_OR in BigQuery
Constantin Lungu
Comprehensions in Python
Constantin Lungu
LIKE ALL and LIKE ANY in BigQuery
Constantin Lungu
SELECT AS STRUCT and SELECT AS VALUE
Constantin Lungu
Does order of expressions in the WHERE clause matter?
Constantin Lungu
Filling up missing values with LAST_VALUE
Constantin Lungu
De-duplicating with ROW_NUMBER vs ARRAY_AGG
Constantin Lungu
Using SELECT * with EXCEPT and REPLACE
Constantin Lungu
Dunder / magic functions in Python
Constantin Lungu