Find warehouse tables by describing what you want in plain English.

Call this before writing SQL whenever you are not certain which table holds the data — table names alone do not tell you whether a table is current, correct, or maintained. Returns candidates ranked by relevance, each with its owner and status. Deprecated tables are included and labelled, so you can recognize them in existing queries rather than assuming they are fine.

Args: query: What you are looking for, e.g. "daily net revenue" or "customer churn". limit: Maximum candidates to return (1-25).

Get the full meaning of one table: purpose, grain, owner, status, and columns.

Call this before using any table you have not already described in this conversation. The column unit field is the part that matters most — it distinguishes gross from net and cents from dollars, which the schema alone cannot tell you. A unit of "unknown" means nobody documented it; say so rather than guessing.

Args: table: Table name, fully qualified or bare (e.g. "main.fct_revenue_daily"). include_columns: Set False when you only need purpose, owner, and status.

Trace where a table or column's data comes from, and what depends on it.

Call this when you need to justify a number, when a value looks wrong and you need to find where it was computed, or before suggesting a change to a table so you can say what it would break. Pass column for column-level lineage. Edges marked model_only mean the SQL could not be parsed down to the column — the dependency is real, the precision is not.

Args: table: Table name, fully qualified or bare. column: Optional column to trace; omit for table-level lineage. direction: "up" for sources, "down" for dependents, "both" (default). depth: How many hops to follow (1-5).

Check whether a table is safe to rely on right now.

Call this before presenting any number derived from a table you have not already checked, and whenever a user mentions a table you did not choose yourself. Reports freshness, row-count movement, null rates, and dbt test results, plus a one-line verdict. A verdict of "deprecated" or "failing" means you should warn the user before using the table, not silently proceed.

Args: table: Table name, fully qualified or bare.