#data-analytics
Read more stories on Hashnode
Articles with this tag
So NULLs are definitely beasts of their own and as Data Engineers we come to learn to take them into account. That is because not knowing their...
It's not all about those fancy details. ยท So I spend quite a bit of time optimizing SQL data processing pipelines in BigQuery. Scale-wise, I might have...
Starting your journey in Analytics can feel like standing at the base of a big mountain. Iโve seen it around me, and Iโve experienced it myself:...
So you have to write a SQL query and after tirelessly working on it, you get more rows than you expected. It looks otherwise correct, but some of the...
If you're looking to generate a random number in BigQuery, check out the RAND() function. It's a pseudo-random number generator, generating a float in...
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...