Describe the dataset
describe_datasetLearn the dataset before writing SQL for query_dataset. Call it with no arguments first. Returns text. Prefer a typed tool when one answers the question.
No arguments: one line per view, the join map, the four invariants, the causes of empty results, and the recipe index. The invariants: dev-branch isolation, no SUM(usage), *_seq compares, adoption polarity. Empty results come from fqn forms, placeholders and machine name forms.
view=, or views=[…] for several in one call. Returns the columns with types and descriptions, an example filter that returns rows, and the joins into the view.
recipe=: a ready-to-run statement for a common question. Fill in the placeholders and run it with query_dataset. Recipes cover who uses a symbol, deprecated symbols per project, and a change record's adoption. Others cover symbols deprecated between minors, one project's deprecated uses, and change records between minors.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| view | No | One view name. Returns its columns with types and descriptions, an example filter, and the joins into it. Leave empty for the overview. | |
| views | No | Up to 8 views at once, documented one after the other in one call. | |
| recipe | No | One recipe id from the overview's index. Returns a ready-to-run query_dataset statement with its placeholders explained. |