query

For an easier building experience, build your query view using the workbook and then promote it to the shared model.

Syntax

query:
  fields:
    <view_name>.<field_name>
    <view_name>.<field_name>: <optional_alias>
  base_view: <view_name>
  filters: [ ... ]

Properties

fields

array

Fields to include in the query view, specified as view_name.field_name. To alias fields, specify as view_name.field_name: alias.

base_view

string

The view to use as the base for the query.

filters

object

Filters to apply to the query view, specified using filter syntax.

Examples

In this example, query.fields contains aliased fields - that is, the string after the colon defines the alias. For example, created_at. The dimensions.sales field is an example of a field that was not aliased.

Example with aliased fields

query:
  fields:
    order_items.created_at[date]: created_at
    order_items.user_id: user_id
    order_items.total_sales
  filters:
    orders.amount_returns:
      not: 0
  base_view: order_items

dimensions:
  created_at:
    timeframes: [date]
    sql: created_at
  user_id:
    sql: user_id
  sales:
    sql: order_items__total_sales

name

required_access_grants

⌘I

Getting started

Manage content

Analyze & build

Visualize & present

Deliver content

Model data

Manage integrations

Syntax

Properties

Examples

​Syntax

​Properties

​Examples

Syntax

Properties

Examples