join_from_view - Relationships

Defines the source view from which the join originates. This parameter works in conjunction with join_to_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_from_view: <source_view>

Properties

string

required

The name of the source view from which the join originates. This view must exist in your data model.

Examples

Join originating from the buyers view

- join_from_view: buyers
  join_from_view_as: users
  join_to_view: user_facts
  join_type: always_left
  on_sql: ${users.id} = ${user_facts.id}
  relationship_type: one_to_one

⌘I

Getting started

Manage content

Analyze & build

Visualize & present

Deliver content

Model data

Manage integrations

join_from_view - Relationships

Limitations

Syntax

Properties

Examples

​Limitations

​Syntax

​Properties

​Examples

Limitations

Syntax

Properties

Examples