Constantin Lungu – Medium

Constantin Lungu

Constantin Lungu
in
Data Engineer’s Notes

NON-EQUI joins in SQL

So here’s another post about SQL joins. Based on the type of condition we use for joining we distinguish equi joins and non-equi joins.

1d ago

NON-EQUI joins in SQL

1d ago

Constantin Lungu
in
Data Engineer’s Notes

LAX JSON conversion functions in BigQuery

So if you’re looking to decompress after a long week and relax, check out the LAX conversion functions for handling JSON conversions in…

2d ago

LAX JSON conversion functions in BigQuery

2d ago

Constantin Lungu
in
Data Engineer’s Notes

Determining JSON types in BigQuery

Here’s a mildly interesting function if you’re working with JSON in BigQuery.

3d ago

Determining JSON types in BigQuery

3d ago

Constantin Lungu
in
Data Engineer’s Notes

Replicating datasets across regions in BigQuery

So this has been up for almost a year, but I’ve just found out that you can replicate datasets across regions in BigQuery. Obligatory…

4d ago

Replicating datasets across regions in BigQuery

4d ago

Constantin Lungu
in
Data Engineer’s Notes

NATURAL JOIN in SQL

Another lesser known JOIN — the natural join. But maybe the NATURAL JOIN is not as obscure after all, since it has its own keyword, at…

5d ago

NATURAL JOIN in SQL

5d ago

Constantin Lungu
in
Data Engineer’s Notes

Short, almost non-technical guide to SQL query tuning as a Data Engineer

So I spend quite a bit of time optimizing SQL data processing pipelines in BigQuery. Scale-wise, I might have an occasional encounter with…

5d ago

Short, almost non-technical guide to SQL query tuning as a Data Engineer

5d ago

Constantin Lungu
in
Data Engineer’s Notes

SEMI-JOINS in SQL

Continuing our series about lesser-know types of SQL joins, let’s look at the SEMI-JOIN today.

6d ago

SEMI-JOINS in SQL

6d ago

Constantin Lungu
in
Data Engineer’s Notes

Anti-joins in SQL

Here’s the SQL Anti-Join, another type of join that doesn’t have its own keyword but it’s very much a thing. You might have used it a lot…

Jun 17

Anti-joins in SQL

Jun 17

Constantin Lungu
in
Data Engineer’s Notes

Self-joins in SQL

Let’s talk about self-joins in SQL. It’s one of the join types that don’t have their own keyword, but is more of a concept.

Jun 16

Self-joins in SQL

Jun 16

Constantin Lungu
in
Data Engineer’s Notes

The relationship between ARRAY_AGG and UNNEST

If you’re working with nested data in BigQuery, you’ve might’ve seen UNNEST, which helps ‘unpack’ arrays into individual rows.

Jun 8

The relationship between ARRAY_AGG and UNNEST

Jun 8

Constantin Lungu

Constantin Lungu

Software Engineer with a focus on Analytics — Data Engineering, Data Science & Business Intelligence | Opinions are my own

Following

Help
Status
About
Careers
Press
Blog
Privacy
Terms
Text to speech
Teams