Ingestion-time partitioning in BigQuery
Constantin Lungu
Command Palette
Search for a command to run...
Archive
207 posts published so far
My day as a Data Engineer 8 years ago
Constantin Lungu
DECLARE and SET variables in BigQuery
Constantin Lungu
Comments in SQL
Constantin Lungu
NON-EQUI joins in SQL
Constantin Lungu
LAX JSON conversion functions in BigQuery
Constantin Lungu
Determining JSON types in BigQuery
Constantin Lungu
Replicating datasets across regions in BigQuery
Constantin Lungu
NATURAL JOIN in SQL
Constantin Lungu
Short, almost non-technical guide to SQL query tuning as a Data Engineer
Constantin Lungu
SEMI-JOINS in SQL
Constantin Lungu
Anti-joins in SQL
Constantin Lungu
Self-joins in SQL
Constantin Lungu
The relationship between ARRAY_AGG and UNNEST
Constantin Lungu
Why basic roles in BigQuery are a bad idea
Constantin Lungu
A couple of fun things about NULL in SQL
Constantin Lungu
FLOAT vs NUMERIC in BigQuery
Constantin Lungu
Breaking Free from Tutorial Hell: Tips for Aspiring Data Professionals
Constantin Lungu
Easy with that SELECT DISTINCT!
Constantin Lungu
The PARTITIONS view in INFORMATION_SCHEMA
Constantin Lungu
Here's how GROUP BY works differently across SQL dialects
Constantin Lungu
Controlling ordering of NULL values in the ORDER BY clause
Constantin Lungu
Joining with USING vs ON in BigQuery
Constantin Lungu
Another look at LOGICAL_AND & LOGICAL_OR in BigQuery
Constantin Lungu
The first thing I do when analyzing a SQL table
Constantin Lungu