Archive - Datawise — SQL, BigQuery & Python for Data Engineers
Skip to main content
Hashnode
Datawise — SQL, BigQuery & Python for Data Engineers
Open search (press Control or Command and K)
Toggle theme
Open menu
Hashnode
Datawise — SQL, BigQuery & Python for Data Engineers
Python for Data Engineers
Practical SQL
My Data Journey
More
Open search (press Control or Command and K)
Toggle theme
Write
Command Palette
Search for a command to run...
Archive
207 posts published so far
May 20, 2026
pre_ and post_operations in Dataform
Constantin Lungu
May 15, 2026
BigQuery Object Tables: A Practical Introduction
Constantin Lungu
Apr 26, 2026
BigQuery BigLake Tables Explained: What They Are and When to Use Them
Constantin Lungu
Mar 5, 2026
BigQuery Saves Your Query Results — Here's How to Find Them
Constantin Lungu
Feb 7, 2026
Parameters in BigQuery
Constantin Lungu
Dec 7, 2025
Flattening JSON arrays in BigQuery
Constantin Lungu
Oct 5, 2025
Using LAST_VALUE with STRUCTS
Constantin Lungu
Oct 4, 2025
Table grain quick validation with SQL
Constantin Lungu
Sep 30, 2025
WITH expressions in BigQuery
Constantin Lungu
Sep 30, 2025
Beware of ROW_NUMBER without ORDER BY
Constantin Lungu
Jun 11, 2025
Aggregating Multiple SCD-2 Attribute Timelines in BigQuery
Constantin Lungu
Jun 9, 2025
Why you should think twice before UNNESTing arrays or date intervals
Constantin Lungu
Jun 9, 2025
Cross-dataset foreign key relationships in BigQuery
Constantin Lungu
Jun 9, 2025
Compacting date intervals in BigQuery
Constantin Lungu
May 6, 2025
Null-safe comparison: IS DISTINCT/NOT DISTINCT FROM
Constantin Lungu
Mar 27, 2025
Transforming cumulative sums into monthly values
Constantin Lungu
Mar 8, 2025
A quick walkthrough BigQuery Remote Functions
Constantin Lungu
Mar 6, 2025
Change history in BigQuery
Constantin Lungu
Mar 2, 2025
A quick overview of BigQuery functions
Constantin Lungu
Feb 23, 2025
Expressing multiple repeated joins as a correlated subquery
Constantin Lungu
Feb 22, 2025
Revisiting GROUP BY ROLLUP with a more realistic example
Constantin Lungu
Feb 21, 2025
Revisiting Why SQL’s Order of Execution Matters
Constantin Lungu
Feb 19, 2025
Exploring the BigQuery Query History
Constantin Lungu
Feb 13, 2025
How ARRAY() can function as UNPIVOT and UNNEST as PIVOT?
Constantin Lungu
Feb 12, 2025
Choosing the Right Ranking Function: Why Ties in SQL Matter
Constantin Lungu
Previous
1
2
3
4
...
9
Page 1 of 9
Next
