join_via_map - Query views

Maps joins when the query view is based on SQL and the joins are non-default joins.

Syntax

query:
  join_via_map:
    <view_name>: []
    <view_name>: [<view_name_to_map_to>]

Properties

object[]

An object containing the individual parameters that make up a query view’s query definition.

Hide query properties

object

A mapping of view names to arrays indicating how joins should be made. Empty arrays indicate direct joins, while non-empty arrays specify intermediate views to join through.

Examples

Join order_items to orders

query:
  fields:
    users.id: id
    order_items.sale_price_sum: sales
  base_view: order_items
  join_via_map:
    orders: []
    order_items: [ orders ]

⌘I

Getting started

Manage content

Analyze & build

Visualize & present

Deliver content

Model data

Manage integrations

join_via_map - Query views

Syntax

Properties

Examples

​Syntax

​Properties

​Examples

Syntax

Properties

Examples