#sql
Read more stories on Hashnode
Articles with this tag
I've recently had to perform a validation of differences between 2 data sources, so I've figured it would be interesting to see the distribution of...
One of these days, I had to handle missing value imputation and stumbled upon the need to calculate a median in BigQuery SQL. Since there is no...
I was asked today about dynamically extracting key-value pairs from heterogeneous JSON-like strings in BigQuery SQL and I've remembered this...
Here'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 correlated...
Query parameters in BigQuery. You need to know about them if you're constructing queries based on user input. What do they do? They can help secure...
Today's quick post is about system variables in BigQuery. What are they? They are a special type of variables, available in scripts (multi-statement...
