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.
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...
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...
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...
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...
A couple of months ago, I've posted about dynamically extracting key-value pairs from JSON in BigQuery SQL which leveraged regex (check...
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)...