Constantin LunguinData Engineer’s NotesComments in SQLLet’s look at the available options in terms of SQL comments in BigQuery.2d ago2d ago
Constantin LunguinData Engineer’s NotesNON-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.5d ago5d ago
Constantin LunguinData Engineer’s NotesLAX 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…6d ago6d ago
Constantin LunguinData Engineer’s NotesDetermining JSON types in BigQueryHere’s a mildly interesting function if you’re working with JSON in BigQuery.Jun 22Jun 22
Constantin LunguinData Engineer’s NotesReplicating 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…Jun 21Jun 21
Constantin LunguinData Engineer’s NotesNATURAL 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…Jun 20Jun 20
Constantin LunguinData Engineer’s NotesShort, 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…Jun 19Jun 19
Constantin LunguinData Engineer’s NotesSEMI-JOINS in SQLContinuing our series about lesser-know types of SQL joins, let’s look at the SEMI-JOIN today.Jun 19Jun 19
Constantin LunguinData Engineer’s NotesAnti-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 LunguinData Engineer’s NotesSelf-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