Estimate BigQuery query cost
estimate_query_costCalculate BigQuery query cost before running it by performing a free dry run that reports bytes processed, estimated on-demand USD charges, and flags SELECT * or missing partition filters.
Instructions
Runs a BigQuery dry run (free; no data is read or billed) for the given standard SQL and returns bytes processed, the estimated on-demand cost in USD, and warnings such as SELECT * usage or missing filters on partitioned tables.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | BigQuery standard SQL query to estimate, e.g. SELECT ... FROM ... |