Articles in this series
You might have encountered the slightly odd-looking || in SQL before, whether in BigQuery or your other database system. If not yet, it's called the...
The code we write daily as Data Engineers is not necessarily complicated. We're solving a lot of problems like the following: Given a schedule per day...
Does anyone have interesting use cases for the ERROR function in BigQuery? If you like BQ errors so much that you've decided to create your own, or if...
Data is collected and processed in a number of ways, and it should come as no surprise that it's not always perfect. Perhaps the most important thing...
If you ever need to do something different based on the existence of a particular substring in hashtag#BigQuery, take a look at the INSTR function. It...
In one of my previous posts I've written about the then-newly-added Primary Key/Foreign Key constraints in BigQuery. While they are not enforced like...