join_from_view_as

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

Syntax

join_from_view_as: <alias>

Properties

join_from_view_as

string

The alias name for the source view. Both the original view name (join_from_view) and this alias can be used in the on_sql parameter.

This alias only exists within this relationship’s on_sql and the topic’s joins parameter. It can’t be referenced in a view file’s own field or dimension SQL, declared in a topic’s views parameter without an extends parameter, or used as a join target in a different relationship — doing so produces a Relationship alias duplicates view name or Table not found error. See Alias scope for the workaround.

Examples

Re-labels buyers as users in the join

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

join_from_view

join_from_view_as_label

⌘I

Getting started

Manage content

Analyze & build

Visualize & present

Deliver content

Model data

Manage integrations

Syntax

Properties

Examples

​Syntax

​Properties

​Examples

Syntax

Properties

Examples