Skip to main content

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.

This parameter is often used for multiple joins, such as when both buyers and sellers are populated via the users table.

Syntax

join_to_view_as: <alias>

Properties

join_to_view_as
string
The alias name for the joined view. Both the original view name (join_to_view) and this alias can be used in the on_sql parameter.

Examples

Relabels user_facts as buyer_facts in the join
- 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