Constantin LunguA 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…Jul 6Jul 6
Constantin LunguQuery 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?Jul 6Jul 6
Constantin LunguSystem variables in BigQueryToday’s quick post is about system variables in BigQuery. What are they?Jul 5Jul 5
Constantin LunguIngestion-time partitioning in BigQueryHave you ever used ingestion-time partitioning in BigQuery?Jul 4Jul 4
Constantin LunguShort, almost non-technical guide to SQL query tuning as a Data EngineerIt’s not all about those fancy detailsJul 3Jul 3
Constantin LunguMy day as a Data Engineer 8 years agoLet’s look day in the life of a Data Engineer in 2016.Jul 3Jul 3
Constantin LunguDECLARE and SET variables in BigQueryHere’s a part of procedural language that I use quite a lot in BigQuery.Jul 3Jul 3
Constantin LunguComments in SQLLet’s look at the available options in terms of SQL comments in BigQuery.Jun 26Jun 26
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.Jun 23Jun 23
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…Jun 22Jun 22