Articles in this series
Have you ever worked with sharded tables in BigQuery? I've encountered them in a project long time ago and haven't seen them much around since. Does...
Does your Data Engineering project use a data-diffing tool? Say you're preparing to deploy a change to a prod table. You've changed the way some...
Splitting a string in BigQuery works pretty much the same as in Excel. SPLIT works in a similar way as its Excel cousin TEXTSPLIT - taking a string...
Here's something that might be interesting if you analyze large volumes of STRING or JSON data in BigQuery. Let's look at SEARCH indexes and what...
If you ever need to extract information based on a pattern in a BigQuery string, check out the REGEXP_EXTRACT_ALL function. This will return an...
Let's help BigQuery do less unneeded work! If you're UNIONING two sources known to have distinct values (and they don't have duplicates), go for...