Source view parameters
| Name | Description |
|---|---|
join_from_view | Defines the source view from which the join originates. |
join_from_view_as | Aliases the source view with a new name. |
join_from_view_as_label | Controls the display name of the source view in Omni when using the join. |
Target view parameters
| Name | Description |
|---|---|
join_to_view | Specifies the view to join to the source view. |
join_to_view_as | Aliases the joined view with a new name. |
join_to_view_as_label | Controls the display name of the joined view in Omni when using the join. |
Join configuration
| Name | Description |
|---|---|
join_type | Specifies the type of SQL join to perform. |
on_sql | Specifies the SQL condition that determines how to perform the join. |
Relationship properties
| Name | Description |
|---|---|
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. |
Special cases
| Name | Description |
|---|---|
id | Do not use. Omni-generated identifier for duplicate joins. |