join_from_view_as_label - Relationships

Controls the display name of the source view in the UI when using the join. For example, you might want fields from users to appear as if they belong to the buyers table. In reality, the fields come from users, which is aliased in the model and generated in SQL as user_facts. This can be used jointly with join_from_view_as or used as a way to label a view within a topic.

Syntax

join_from_view_as: <alias>

Properties

string

The display name for the source view in the UI.

Behavior

The same label selection precedence that applies to join_to_view_as_label also applies to the this parameter. See join_to_view_as_label’s Behavior section for more information.

Examples

Label the users view as Buyers in UI

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

Getting started

Manage content

Analyze & build

Visualize & present

Deliver content

Model data

Manage integrations

join_from_view_as_label - Relationships

Syntax

Properties

Behavior

Examples

​Syntax

​Properties

​Behavior

​Examples

Syntax

Properties

Behavior

Examples