> ## Documentation Index
> Fetch the complete documentation index at: https://docs.omni.co/llms.txt
> Use this file to discover all available pages before exploring further.

<AgentInstructions>

## Submitting Feedback

If you encounter incorrect, outdated, or confusing documentation on this page, submit feedback:

POST https://docs.omni.co/feedback

```json
{
  "path": "/modeling/relationships/parameters/index",
  "feedback": "Description of the issue"
}
```

Only submit feedback when you have something specific and actionable to report.

</AgentInstructions>

# Relationship file parameters

> Reference for all relationship YAML parameters in Omni, including join type, cardinality, on_sql conditions, and reversibility.

| Parameter                                                                                 | Description                                                                 |
| ----------------------------------------------------------------------------------------- | --------------------------------------------------------------------------- |
| [id](/modeling/relationships/parameters/id)                                               | Omni-generated identifier for duplicate joins.                              |
| [join\_from\_view\_as\_label](/modeling/relationships/parameters/join-from-view-as-label) | Controls the display name of the source view in the UI when using the join. |
| [join\_from\_view\_as](/modeling/relationships/parameters/join-from-view-as)              | Aliases the source view with a new name.                                    |
| [join\_from\_view](/modeling/relationships/parameters/join-from-view)                     | Defines the source view from which the join originates.                     |
| [join\_to\_view\_as\_label](/modeling/relationships/parameters/join-to-view-as-label)     | Controls the display name of the joined view in the UI when using the join. |
| [join\_to\_view\_as](/modeling/relationships/parameters/join-to-view-as)                  | Aliases the joined view with a new name.                                    |
| [join\_to\_view](/modeling/relationships/parameters/join-to-view)                         | Specifies the view to join to the source view.                              |
| [join\_type](/modeling/relationships/parameters/join-type)                                | Specifies the type of SQL join to perform.                                  |
| [on\_sql](/modeling/relationships/parameters/on-sql)                                      | Specifies the SQL condition that determines how to perform the join.        |
| [relationship\_type](/modeling/relationships/parameters/relationship-type)                | Defines the cardinality relationship between joined tables.                 |
| [reversible](/modeling/relationships/parameters/reversible)                               | Controls whether the join can function bi-directionally for topics.         |
| [where\_sql](/modeling/relationships/parameters/where-sql)                                | Adds a WHERE clause to the generated SQL when a join is established.        |