A data analyst is setting up an automated workflow in BigQuery that executes a daily SQL aggregation query to refresh an executive reporting table. Before configuring the scheduled query, the analyst wants to validate the SQL syntax and estimate the number of bytes the query will scan to optimize performance and prevent unexpected billing, without executing the query or incurring on-demand query costs. Which feature should the analyst use in BigQuery?

Perform a query dry run: ### **What a BigQuery dry run is:** A **dry run** in BigQuery is a query execution simulation mode that evaluates and parses the SQL statement without actually running it against the data engine or scanning table rows. When a query is submitted as a dry run (by setting the `dryRun` flag to `true` in API requests, client libraries, or the Google Cloud console), BigQuery validates query syntax, verifies schema and table references, and calculates the exact number of **bytes billed** and processed if the query were executed. ### **How it meets the requirements:** - **Validates SQL syntax (✓):** A dry run fully parses the query and returns specific syntax errors or missing column/table notifications before scheduling. - **Estimates processed bytes (✓):** Returns the `totalBytesProcessed` metric in the returned job statistics, allowing the analyst to understand resource usage and query cost. - **Zero query charges (✓):** Dry runs do not scan data, consume slots, or incur processing costs under either on-demand or capacity-based billing. - **Optimizes query design (✓):** Enables testing different filtering, partitioning, and clustering strategies to observe how they reduce byte scans prior to automating the workload. ### **Key advantages:** - **Cost governance:** Helps data teams prevent expensive full-table scans by testing queries before placing them on recurring schedules. - **Fast feedback loop:** Returns validation results and byte estimates almost instantaneously without waiting for long compute tasks. - **Automation integration:** Can be embedded into CI/CD pipelines or deployment scripts to test scheduled query definitions automatically. - **Optimization validation:** Confirms whether partition filters (such as date or timestamp clauses) are effectively pruning unneeded partitions. ### **Why this is optimal:** A dry run is the only native BigQuery capability designed specifically to validate query correctness and calculate byte consumption without running the job or incurring execution costs. It provides the exact prerequisite metrics needed before committing queries to automated schedules.