BigQuery supports a WHERE analog that works on window statements:
https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax#qualify_clause
Typically when trying to subset data according to a condition on a window, we need to first assign a temporary variable, then WHERE on it, but using QUALIFY directly instead will simplify translations.
(filing this quickly now, I can add some reprex if requested)
BigQuery supports a
WHEREanalog that works on window statements:https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax#qualify_clause
Typically when trying to subset data according to a condition on a window, we need to first assign a temporary variable, then
WHEREon it, but usingQUALIFYdirectly instead will simplify translations.(filing this quickly now, I can add some reprex if requested)