| Parameter | Description |
|---|---|
| id | Omni-generated identifier for duplicate joins. |
| join_from_view_as_label | Controls the display name of the source view in the UI when using the join. |
| join_from_view_as | Aliases the source view with a new name. |
| join_from_view | Defines the source view from which the join originates. |
| join_to_view_as_label | Controls the display name of the joined view in the UI when using the join. |
| join_to_view_as | Aliases the joined view with a new name. |
| join_to_view | Specifies the view to join to the source view. |
| join_type | Specifies the type of SQL join to perform. |
| on_sql | Specifies the SQL condition that determines how to perform the join. |
| relationship_type | Defines the cardinality relationship between joined tables. |
| reversible | Controls whether the join can function bi-directionally for topics. |
| where_sql | Adds a WHERE clause to the generated SQL when a join is established. |