approximate_threshold

LookML
Version

On this Page
Docs Menu

Go to Field Parameter List

Definition

Google BigQuery Legacy SQL calculates an exact count distinct if there are less 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

- measure: unique_count type: count_distinct approximate_threshold: 100000 # default value is 1000 sql: ${id}

Still have questions?
Go to Discourse - or - Email Support
Top