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…3d ago3d ago
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?4d ago4d ago
Constantin LunguSystem variables in BigQueryToday’s quick post is about system variables in BigQuery. What are they?5d ago5d ago
Constantin LunguIngestion-time partitioning in BigQueryHave you ever used ingestion-time partitioning in BigQuery?6d ago6d ago
Constantin LunguShort, almost non-technical guide to SQL query tuning as a Data EngineerIt’s not all about those fancy details6d ago6d ago
Constantin LunguMy day as a Data Engineer 8 years agoLet’s look day in the life of a Data Engineer in 2016.6d ago6d ago
Constantin LunguDECLARE and SET variables in BigQueryHere’s a part of procedural language that I use quite a lot in BigQuery.6d ago6d ago
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