List Tables for SQL Queries
link_tablesThe tables link_query can read and the keys that join them: datasets to lookup tables to Census geography. With no arguments, a short index: each dataset's table name for SQL (e.g. 'education.attendance', its default detail level), what one row is (grain), detail levels, and join keys, plus each lookup table's name (e.g. 'dimensions.districts'). tables (names from the index, e.g. 'education.attendance', 'education/gosa/attendance', 'attendance', or 'districts') returns those tables in full: every column and a table name per detail level ('education.attendance__districts'). main_topic limits either form to one subject area.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| tables | No | Tables to return in full. Omit for the short index. | |
| main_topic | No | Only datasets in this subject area. Omit for all. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||