find_code_assets_using_table
Find which Colab notebooks, saved queries, or data canvases reference a BigQuery table before altering or dropping it.
Instructions
Find which Colab notebooks and saved queries reference a table.
The question to ask before changing or dropping a table:
list_scheduled_queries says what writes it, this says who reads it.
Unlike the other tools here this one opens every asset it considers, which
costs Dataform read quota. It is bounded by max_assets and reports how
much of the project it actually covered -- a result is evidence about the
assets scanned, never proof that nothing else uses the table.
Args: table: Table name to search for. A bare name matches any qualification; 'dataset.table' or a fully-qualified name narrows it. environment: Which configured environment to read. Omit for the default. asset_type: Restrict to 'sql', 'notebook' or 'data_canvas'. max_assets: Ceiling on how many bodies to read.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | ||
| asset_type | No | ||
| max_assets | No | ||
| environment | No |