Looker · Schema
WriteQuery
Writable fields for creating a new query
AnalyticsBI PlatformBusiness IntelligenceData AnalyticsData Visualization
Properties
| Name | Type | Description |
|---|---|---|
| model | string | LookML model name |
| view | string | LookML explore (view) name |
| fields | array | List of field names to include |
| pivots | array | Fields to pivot on |
| fill_fields | array | Fields to fill missing values for |
| filters | object | Filter expressions keyed by field name |
| filter_expression | string | Custom filter expression |
| sorts | array | Sort order for results |
| limit | string | Maximum rows to return |
| column_limit | string | Maximum columns for pivoted results |
| total | boolean | Include row totals |
| row_total | string | Row total setting |
| subtotals | array | Fields to subtotal on |
| dynamic_fields | string | JSON string of dynamic field definitions |
| vis_config | object | Visualization configuration |
| query_timezone | string | Timezone for date/time calculations |