#analytics
Read more stories on Hashnode
Articles with this tag
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...
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...
Whenever you're UNNESing an ARRAY, you're getting a Cartesian product between the row and the array contents. If you were to unnest another array,...