Estimating Bigquery result row count without running the whole query
How to estimate BigQuery result count without running the full query using dry run.
Running a full BigQuery query just to get a row count is wasteful and expensive. In this article I show how to use BigQuery’s dry run feature to estimate result counts without actually executing the query.