Pay attention to cardinality & grain when UNNESTING in BigQuery!
Constantin Lungu
Command Palette
Search for a command to run...
Archive
207 posts published so far
Constructing STRUCTS in BigQuery
Constantin Lungu
Using STRUCTS for quick analysis in BigQuery
Constantin Lungu
Understanding STRUCTS in BigQuery
Constantin Lungu
Sharded tables in BigQuery
Constantin Lungu
Why does your Data Warehouse need to look more like a pharmacy than a retail store?
Constantin Lungu
Comparing tables with FULL OUTER JOIN
Constantin Lungu
Splitting a STRING in BigQuery
Constantin Lungu
Search Indexes in BigQuery
Constantin Lungu
A portable Data Analytics stack using Docker, Mage, dbt-core, DuckDB and Superset
Constantin Lungu
Extract all pattern occurrences in BigQuery
Constantin Lungu
Why you should use UNION DISTINCT sparingly
Constantin Lungu
ORDER BY expressions in SQL
Constantin Lungu
Accessing ARRAY elements in BigQuery
Constantin Lungu
Enumerating ARRAY elements in BigQuery using WITH OFFSET
Constantin Lungu
UNNESTING ARRAYS in BigQuery
Constantin Lungu
Boolean data type in BigQuery
Constantin Lungu
COALESCE vs IFNULL vs NULLIF in BigQuery
Constantin Lungu
GREATEST & LEAST in BigQuery
Constantin Lungu
RANGE data type in BigQuery
Constantin Lungu
DELETE + INSERT vs MERGE in BigQuery
Constantin Lungu
Using GROUP BY ALL in BigQuery
Constantin Lungu
Using zip in Python
Constantin Lungu
Why you should care about partition pruning in BigQuery
Constantin Lungu
Calculating the MODE in BigQuery
Constantin Lungu