id - Omni Docs

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

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

Relationship file parameters

join_from_view

⌘I

Getting started

Manage content

Analyze & build

Visualize & present

Deliver content

Model data

Manage integrations

id

Syntax

Properties

Examples

​Syntax

​Properties

​Examples

Syntax

Properties

Examples