#google-cloud
Read more stories on Hashnode
Articles with this tag
Rounding numbers in SQL is one of the simplest operation, but it's important to we pay attention to how we apply it. 1) Consider the sequence in...
If you're just getting started with SQL, this post is for you. So, it's worth looking at the order of precedence of SQL operators. One particular case...
For a long time I didn't even know transactions existed in BigQuery. How are they useful? Say you are performing a number of operations that you would...
Here's an example of how QUALIFY fits into the order of execution in SQL. In the BigQuery example below, we want to compute the second-to-last...
Another new time series function in BigQuery in addition to the ones previously presented is the GAPS_FILL table-valued function. It allows us to fill...
I've posted some time ago about "rounding" timestamps and datetime values, but in the past few months BigQuery has added Time Series functions (in...