id - Relationships

Omni-generated identifier for duplicate joins; automatically added when duplicate joins are detected 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

⌘I

Getting started

Manage content

Analyze & build

Visualize & present

Deliver content

Model data

Manage integrations

id - Relationships

Syntax

Properties

Examples

​Syntax

​Properties

​Examples

Syntax

Properties

Examples