APPROX_TOP_COUNT

1
SELECT
2
  APPROX_TOP_COUNT(product_name, 5) as top_products
3
FROM `project.dataset.orders`;

1
SELECT
2
  top_keyword.value as keyword,
3
  top_keyword.count as search_count
4
FROM `project.dataset.search_logs`,
5
UNNEST(APPROX_TOP_COUNT(search_query, 10)) as top_keyword;

1
SELECT
2
  service_name,
3
  APPROX_TOP_COUNT(error_code, 3) as top_errors
4
FROM `project.dataset.error_logs`
5
WHERE DATE(timestamp) = CURRENT_DATE()
6
GROUP BY service_name;