View
.view
View defines fields that can be gathered from table or query.
Each View must be stored as view_name.view YAML file:
view: view_name
connection: connection_name
label: 'view label in UI'
description: 'description in UI'
table: table_name
derived_table: |
'SELECT ... FROM ...'
udfs:
- user_defined_function_name
- user_defined_function_name
- ...
fields:
# List of fields (Dimensions, Time, Measures, Calculations, Filters)
# - dimension: dimension_name
# ...
View Parameters
Name | Type | Default | Description |
---|---|---|---|
view* | string | - | View name |
connection* | string | - | Connection name |
label | string | - | View label in UI |
description | string | - | View description in UI |
table** | string | - | Specify existing table as a source for a view |
derived_table** | string | - | Way to derive table for a view through custom SQL query |
udfs | string[] | - | List all of user defined functions needed by current View |
fields | (Dimension | Time | Measure | Calculation | Filter) [] | - | Begin a section of fields |