join_type - Relationships

Specifies the type of SQL join to perform. This parameter defaults to left join (always_left) and supports several standard SQL join types, as well as two directional join types that are specific to Omni.

Syntax

join_type: <type>

Properties

string

default:"always_left"

The type of join to perform. Can be:A standard join type:

always_left - Generates LEFT JOIN
inner - Generates INNER JOIN
full_outer - Generates FULL JOIN
cross - Generates CROSS JOIN

Or a directional join type:

right_left - Generates a RIGHT JOIN when used in the FROM/TO direction, and a LEFT JOIN when used in the opposite direction
left_right - Generates a LEFT JOIN when used in the FROM/TO direction, and a RIGHT JOIN when used in the opposite direction

Examples

Create LEFT JOIN with always_left

- 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

Create LEFT JOIN with left_right type

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

Create RIGHT JOIN with right_left type

- join_from_view: buyers
  join_to_view: user_facts
  join_to_view_as: buyer_facts
  join_type: right_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

join_type - Relationships

Syntax

Properties

Examples

​Syntax

​Properties

​Examples

Syntax

Properties

Examples