Usage
measure: field_name {
approximate_threshold: 100000
}
}
Hierarchyapproximate_threshold |
Possible Field TypesMeasureAcceptsAn integer |
Definition
Google BigQuery Legacy SQL calculates an exact count_distinct
if there are fewer than 1,000 distinct values, but performs an approximation for larger numbers of distinct values. The approximate count is faster, but typically has an error of a few percent.
If you want BigQuery Legacy SQL to calculate an exact count_distinct
for more than 1,000 distinct values, you can set that amount with the approximate_threshold
parameter.
Examples
Return an exact count_distinct
for up to 100,000 distinct values: