Constantin Lungu

Constantin Lungu

28 followers

Data Engineer with a passion for transforming complex data landscapes into insightful stories. Here on my blog, I share insights, challenges, and the ever-evolving dance of technology and business.

Raising ERRORS in BigQuery

Apr 24, 20241 min read

Does anyone have interesting use cases for the ERROR function in BigQuery? If you like BQ errors so much that you've decided to create your own, or...

Raising ERRORS in BigQuery

Cleaning up STRINGS in BigQuery

Apr 24, 20241 min read

Data is collected and processed in a number of ways, and it should come as no surprise that it's not always perfect. Perhaps the most important...

Cleaning up STRINGS in BigQuery

Lessons from Chernobyl and how it relates to software engineering

Apr 22, 20242 min read

Growing up in post-Soviet Moldova, I was repeatedly reminded of the Chernobyl disaster. It was a topic at school, we had liquidators in our small...

Lessons from Chernobyl and how it relates to software engineering

Using INSTR in BigQuery

Apr 22, 20241 min read

If you ever need to do something different based on the existence of a particular substring in hashtag#BigQuery, take a look at the INSTR function. It...

Using INSTR in BigQuery

Cross-dataset Foreign Key referencing in BigQuery

Apr 19, 20241 min read

In one of my previous posts I've written about the then-newly-added Primary Key/Foreign Key constraints in BigQuery. While they are not enforced like...

Cross-dataset Foreign Key referencing in BigQuery

Pay attention to cardinality & grain when UNNESTING in BigQuery!

Apr 19, 20241 min read

Whenever you're UNNESing an ARRAY, you're getting a Cartesian product between the row and the array contents. If you were to unnest another array,...

Pay attention to cardinality & grain when UNNESTING in BigQuery!