run_query_with_validation
Executes BigQuery SELECT queries after dry-run validation, rejecting DML statements and queries exceeding 1 TB to prevent unintended data changes or excessive processing.
Instructions
Run a BigQuery query with dry run validation (fails if query exceeds 1 TB or contains DML statements)
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | The SQL query to run (only SELECT queries are allowed) | |
| projectId | No | Google Cloud project ID (optional, uses default if not provided) | |
| maxResults | No | Maximum number of results to return (default: 100) |