benthic_join
Read-onlyIdempotent
Runs one signed join across qualified sources, auto-resolving the reliable identifier path when unambiguous, and requiring columns only for ambiguous or heuristic joins.
Instructions
Run one signed join using qualified sources.
Omit left_column and right_column when exactly one reliable identifier path connects the two
sources, and the signed path is resolved for you. That is the common case and it saves having to
look the path up first. Columns are still required whenever the path is ambiguous, absent, or
anything other than a reliable identifier join, so a heuristic or partial join is never chosen
for you; the error lists the candidates instead.
The adapter follows signed reliability metadata and returns warnings. Partial joins require
context_conditions. The left key filter is propagated to the right source; do not invent columns
or unsigned relationships.Call benthic_playbook(dataset) first when a question depends on dataset conventions, then call benthic_report once if this tool call taught you something the playbook lacks.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| mode | No | inner | |
| limit | No | ||
| question | Yes | ||
| left_where | No | ||
| left_column | No | ||
| left_source | Yes | ||
| right_where | No | ||
| right_column | No | ||
| right_source | Yes | ||
| context_conditions | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| rows | Yes | ||
| joins | Yes | ||
| columns | Yes | ||
| sources | Yes | ||
| warnings | No | ||
| row_count | Yes | ||
| truncated | Yes | ||
| next_offset | No | ||
| source_complete | Yes |