An analyst needs a cost estimate before executing a large on-demand BigQuery query. Which approach best fits?

Published
  1. Evaluate clustering on the frequently filtered identifier and measure the effect.
  2. Evaluate a compatible materialized view.
  3. Perform a dry run and set an appropriate maximum bytes billed where supported.
  4. Filter on the relevant partition column using a pruning-compatible predicate.

Comments — 0