Constantin LunguinData Engineer’s NotesInstalling Python packages with pipHere are the basics you need to know about installing Python packages.7h ago7h ago
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…Jul 6Jul 6
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?Jul 6Jul 6
Constantin LunguinData Engineer’s NotesSystem variables in BigQueryToday’s quick post is about system variables in BigQuery. What are they?Jul 5Jul 5
Constantin LunguinData Engineer’s NotesIngestion-time partitioning in BigQueryHave you ever used ingestion-time partitioning in BigQuery?Jul 4Jul 4
Constantin LunguinData Engineer’s NotesShort, almost non-technical guide to SQL query tuning as a Data EngineerIt’s not all about those fancy detailsJul 3Jul 3
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.Jul 3Jul 3
Constantin LunguinData Engineer’s NotesDECLARE and SET variables in BigQueryHere’s a part of procedural language that I use quite a lot in BigQuery.Jul 3Jul 3
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