join_to_view_as_label - Relationships

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

Syntax

join_to_view_as_label: <display_label>

Properties

string

The display name for the joined view in the UI.

Examples

Label the buyer_facts view as Buyers in the UI

- join_from_view: buyers
  join_to_view: user_facts
  join_to_view_as: buyer_facts
  join_to_view_as_label: Buyers
  join_type: always_left
  on_sql: ${buyers.id} = ${buyer_facts.id}
  relationship_type: one_to_one

join_to_view_as - Relationships

join_type - Relationships

⌘I

Getting started

Manage content

Analyze & build

Visualize & present

Deliver content

Model data

Manage integrations

join_to_view_as_label - Relationships

Syntax

Properties

Examples

​Syntax

​Properties

​Examples

Syntax

Properties

Examples