
Counting distinct values across rolling windows in BigQuery using HyperLogLog++ sketches
How do we count distinct rolling 90 day active users in a data set of billions? At Pex, we actively monitor all visible content on our supported platforms – over