Set Relationship
set_relationshipManage relationships between two columns by accepting, rejecting, adding, annotating, or deleting joins; approved relationships persist across re-scans and are used for join paths.
Instructions
Accept, reject, add, annotate or delete a join between two columns. Reviewed relationships survive re-scans. Only accepted relationships are used for join paths.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| role | No | Business role when several columns reference the same table, e.g. 'billing'. | |
| action | Yes | What to do. | |
| source | No | Foreign-key side, 'table.column'. | |
| target | No | Referenced key, 'table.column'. | |
| datasource | No | Datasource name. Optional when only one datasource is registered. | |
| is_default | No | Make this the default join between the two tables. | |
| description | No | What the relationship means. | |
| relationship_id | No | Id from list_relationships (or give source and target). |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||