Skip to main content
This parameter works in conjunction with join_from_view to establish the relationship between two views in your data model.

​
Limitations

Views representing a data input table (CSV/XLSX upload) can’t be used in a join unless the table has been uploaded to a database. This requires defining an Upload schema for the underlying database connection.

​
Syntax

join_to_view: <target_view>

​
Properties

​
join_to_view
string
required
The name of the view to join into the source view. This view must exist in your data model.

​
Examples

Join buyers to user_facts
- 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