base_view - Query views

References the view that is used in the FROM of the generated SQL. Alternatively, think of the base view as the view that all subsequent views will join to when building a query.

Syntax

query:
  base_view: <view_name>

Properties

object[]

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

Hide query properties

string

The name of the view to use as the base for the query. Only one base view is allowed per query view.

Examples

Query with a users base_view

query:
  fields:
    users.age: age
    users.created_at[year]: created_at_year
    calc_1: calc_1
  base_view: users

⌘I

Getting started

Manage content

Analyze & build

Visualize & present

Deliver content

Model data

Manage integrations

base_view - Query views

Syntax

Properties

Examples

​Syntax

​Properties

​Examples

Syntax

Properties

Examples