Constantin LunguNON-EQUI joins in SQLSo 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 ago1d ago
Constantin LunguLAX JSON conversion functions in BigQuerySo if you’re looking to decompress after a long week and relax, check out the LAX conversion functions for handling JSON conversions in…2d ago2d ago
Constantin LunguDetermining JSON types in BigQueryHere’s a mildly interesting function if you’re working with JSON in BigQuery.3d ago3d ago
Constantin LunguReplicating datasets across regions in BigQuerySo 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 ago4d ago
Constantin LunguNATURAL JOIN in SQLAnother 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 ago5d ago
Constantin LunguShort, almost non-technical guide to SQL query tuning as a Data EngineerSo I spend quite a bit of time optimizing SQL data processing pipelines in BigQuery. Scale-wise, I might have an occasional encounter with…5d ago5d ago
Constantin LunguSEMI-JOINS in SQLContinuing our series about lesser-know types of SQL joins, let’s look at the SEMI-JOIN today.6d ago6d ago
Constantin LunguAnti-joins in SQLHere’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 17Jun 17
Constantin LunguSelf-joins in SQLLet’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 16Jun 16
Constantin LunguThe relationship between ARRAY_AGG and UNNESTIf you’re working with nested data in BigQuery, you’ve might’ve seen UNNEST, which helps ‘unpack’ arrays into individual rows.Jun 8Jun 8