Skip to main content
The id parameter is added when Omni has detected duplicate joins in your model. This identifier helps distinguish between multiple joins to the same table, but its presence typically indicates that your model needs attention.
Rather than using this parameter explicitly, you should review your join relationships and eliminate any unnecessary duplicates.

​
Syntax

id: <identifier>

​
Properties

​
id
string
An identifier Omni adds to relationships when duplicate joins are detected. Avoid explicit use.

​
Examples

Duplicate joins for buyers to buyer_facts
- id: buyers_0
  join_from_view: buyers
  join_to_view: user_facts
  join_to_view_as: buyer_facts
  join_type: always_left
  on_sql: ${buyers.id} = ${buyer_facts.id}
  relationship_type: one_to_one

- id: buyers_1
  join_from_view: buyers
  join_to_view: user_facts
  join_to_view_as: buyer_facts
  join_type: always_left
  on_sql: ${buyers.id} = ${buyer_facts.id}
  relationship_type: one_to_one