observedRelationships
observedRelationshipsDiscover empirically observed equi-join column pairs from stored queries, with support counts and contributing query IDs. Excludes non-equi joins.
Instructions
Discover empirically observed equi-join column pairs from stored queries, with support counts and contributing query IDs. Use findJoinPaths for declared/combined paths between endpoints; non-equi joins are excluded.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | No | Require either join side to use this table. | |
| schema | No | Case-insensitive filter. | |
| connection | Yes | Database to run against. Call listConnections for valid names; do not guess. | |
| minSupport | No | Minimum supporting queries (default 1). |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| count | Yes | Number of observed relationships returned after filtering. | |
| table | No | Optional table filter used when aggregating observed relationships. | |
| schema | No | ||
| minSupport | Yes | Minimum observed support threshold applied to relationship aggregation. | |
| relationships | No | Relationship edges relevant to the context, graph, or observed-relationships result. |