#database
Read more stories on Hashnode
Articles with this tag
There’s one concept that is central when working with data and goes beyond specific technology or SQL dialects. You just can’t miss it. I’m talking...
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...
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...
After my previous STRUCTS in BigQuery post, I could not have skipped to mention number of options when it comes to construct one. You can choose...
What function do you use to explicitly de-duplicate in BigQuery?I normally use ROW_NUMBER(), but I've recently encountered a really interesting blog...
