Constantin LunguinData Engineer’s NotesA practical exercise working with ARRAYS and correlated subqueries in BigQueryHere’s an interesting SQL problem, similar to one I had to solve the other day. It involves some of our favourite BigQuery ARRAYS, but also…3d ago3d ago
Constantin LunguinData Engineer’s NotesQuery parameters in BigQueryQuery parameters in BigQuery. You need to know about them if you’re constructing queries based on user input. What do they do?4d ago4d ago
Constantin LunguinData Engineer’s NotesSystem variables in BigQueryToday’s quick post is about system variables in BigQuery. What are they?5d ago5d ago
Constantin LunguinData Engineer’s NotesIngestion-time partitioning in BigQueryHave you ever used ingestion-time partitioning in BigQuery?6d ago6d ago
Constantin LunguinData Engineer’s NotesShort, almost non-technical guide to SQL query tuning as a Data EngineerIt’s not all about those fancy details6d ago6d ago
Constantin LunguinData Engineer’s NotesMy day as a Data Engineer 8 years agoLet’s look day in the life of a Data Engineer in 2016.6d ago6d ago
Constantin LunguinData Engineer’s NotesDECLARE and SET variables in BigQueryHere’s a part of procedural language that I use quite a lot in BigQuery.6d ago6d ago
Constantin LunguinData Engineer’s NotesComments in SQLLet’s look at the available options in terms of SQL comments in BigQuery.Jun 26Jun 26
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.Jun 23Jun 23
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…Jun 22Jun 22