list_scheduled_queries
View scheduled queries to see what they write, when they run, and their state. Identify disabled or failing queries that cause table staleness.
Instructions
List scheduled queries: what they write, when they run, and their state.
Use this to answer "what populates this table?" and "why is this table stale?" — a disabled or failing scheduled query is the usual cause, and check_table_freshness can see the staleness but not the reason.
The SQL is not included here; call get_scheduled_query for one of them.
Args: dataset: Only queries writing into this destination dataset. contains: Only queries whose name contains this text. include_disabled: Keep disabled queries in the result. They are the most likely explanation for a table that stopped updating, so this defaults to True. environment: Which configured environment to look in. Scheduled queries are regional, so this must be the environment whose location holds them.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| dataset | No | ||
| contains | No | ||
| environment | No | ||
| include_disabled | No |