default_drill_query

Refer to the Measure documentation for more information.

Syntax

default_drill_query:
  fields: [ <field1>, <field2> ... ]
  base_view: <view_name>
  limit: number
  sorts: [ <view>.<field>, ... ]

fields

array

An array of fields to include in the drill query.

base_view

string

The table that will act as the FROM clause of the query.

limit

number

The number of rows to return in the drill query.

sorts

array

An array of fields used to sort the query, specified as view_name.field_name.

Default drill query configuration for orders

default_drill_query:
  fields: [ sale_price, margin ]
  base_view: orders
  limit: 10
  sorts: [ orders.user_id ]