Spanner supports approximate aggregate functions in GoogleSQL and PostgreSQL

Spanner supports approximate aggregate functions for both GoogleSQL and PostgreSQL dialects. These functions produce statistical estimates of distinct counts, allowing you to compute results faster and save resources on large datasets compared to exact aggregation.

For more information, see approximate aggregate functions (GoogleSQL and PostgreSQL), HyperLogLog++ functions, and Sketches.