Skip to main content
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