get_scheduled_query
Retrieve a scheduled query's SQL, destination table, and recent runs to diagnose failures or trace which SQL creates a table. Use after listing queries.
Instructions
Get one scheduled query in full: its SQL, destination, and recent runs.
Call this after list_scheduled_queries to see why a query is failing, or what SQL actually produces a table.
Args: query: The scheduled query's name, or the id from list_scheduled_queries. runs: How many recent runs to include, newest first. environment: Which configured environment to look in.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| runs | No | ||
| query | Yes | ||
| environment | No |