Constantin Lungu

Constantin Lungu

57 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.

Why you should care about VS Code Remote Development

Nov 12, 20242 min read

Maybe save a bit on that next expensive laptop upgrade? Over the weekend, I worked on some small personal projects and decided to try out remote...

Why you should care about VS Code Remote Development

For quality work, understand your data grain first

Nov 9, 20242 min read

There’s one concept that is central when working with data and goes beyond specific technology or SQL dialects. You just can’t miss it. I’m talking...

Sometimes, you have to use subqueries!

Nov 1, 20241 min read

Query without FROM clause cannot have a WHERE clause, goes the old SQL adage. So I had this interesting problem the other day. Let's say an order has...

Sometimes, you have to use subqueries!

Not all NULLS are the same

Oct 27, 20241 min read

So NULLs are definitely beasts of their own and as Data Engineers we come to learn to take them into account. That is because not knowing their quirks...

Not all NULLS are the same

Extracting keys from JSON in BigQuery

Oct 27, 20241 min read

A couple of months ago, I've posted about dynamically extracting key-value pairs from JSON in BigQuery SQL which leveraged regex (check...

Extracting keys from JSON in BigQuery

Computing a hash aggregation in BigQuery

Oct 21, 20241 min read

So I've seen Snowflake has an HASH_AGG function. When would we need it? Every time we'd like to work out if ANY value in a group (or the entire table)...

Computing a hash aggregation in BigQuery