get_table_documentation
Get comprehensive documentation for a table including wiki descriptions.
IMPORTANT: Use this tool FIRST when you need to understand what a table
contains, its purpose, business context, or column meanings.
Returns detailed information about a table including:
- Wiki documentation (user-written descriptions, business context,
data lineage, column explanations - very valuable!)
- Column definitions (name, type, nullable, description from wiki)
- View SQL definition (for views)
- Sample SQL queries for the table
- Related tables in the same schema
- Business metrics — formulas and SQL expressions for calculating KPIs
(e.g., DAU, AOV, Revenue, Conversion Rate)
- Glossary — business terms and their definitions relevant to this table
- Relations — links to dictionary/lookup/dimension tables with JOIN conditions
The wiki field contains rich documentation written by data engineers
explaining what the table is for, how to use it, and what each column means.
The business_metrics field contains ready-to-use SQL formulas for key metrics.
The relations field shows how to JOIN this table with dictionaries and other tables.
get_catalog_documentation
Get documentation for all available catalogs in Dremio.
Use this tool to get an overview of all data sources and their structure.
Returns information about all catalogs including:
- Catalog names and descriptions
- Number of schemas per catalog
- Number of tables per catalog
- Summary totals