How to use the Qualify Function in BigQuery SQL

New Update on Google Cloud makes it general available

A maybe useful function for you is now generally available in Google BigQuery. The QUALIFY clause, which lets you filter the results of analytic functions in Google Standard SQL.

Functionality

The evaluation of a query with a QUALIFY clause is usually performed in this order[1]:

Here is a small example of how this function works:

And the result — as expected:

A small new feature, but one that is justified and may be used in some of your analysis use cases. In addition, there have been other interesting updates recently that might also interest you:

Related posts:

The beautiful game of football has a long and extensive history. In present day terms, football is the most popular and watched sport, loved by between 3 and 4 billion fans around the world. The…

Coming into the spring, very little was known about David Bote. Sure, he’s listed as the #15 prospect on MLB Pipeline’s Top 30 Cubs prospects. But to be fair, usually the guys towards the bottom of…

I read an article on Twitter earlier today (I cannot relocate it) that was challenging what it cited as ‘the myth of human-centered design.’ I was aware that my ego was jumping to the defense of 18…