bq_dry_run_sql
Analyze BigQuery SQL queries with a dry-run to estimate costs, validate syntax, and preview schema without executing the query.
Instructions
Perform a dry-run of a BigQuery SQL query to get cost estimates and metadata
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| params | No | Optional query parameters (key-value pairs) | |
| pricePerTiB | No | Price per TiB for cost estimation (defaults to env var or 5.0) | |
| sql | Yes | The SQL query to dry-run |
Input Schema (JSON Schema)
{
"properties": {
"params": {
"additionalProperties": true,
"description": "Optional query parameters (key-value pairs)",
"type": "object"
},
"pricePerTiB": {
"description": "Price per TiB for cost estimation (defaults to env var or 5.0)",
"type": "number"
},
"sql": {
"description": "The SQL query to dry-run",
"type": "string"
}
},
"required": [
"sql"
],
"type": "object"
}