Looker · Schema
Query
A query defines a data request against a LookML model. Queries are immutable once created and contain the model, view, fields, filters, sorts, and limit needed to generate SQL and retrieve results.
AnalyticsBI PlatformBusiness IntelligenceData AnalyticsData Visualization
Properties
| Name | Type | Description |
|---|---|---|
| id | integer | Unique numeric identifier for this query |
| model | string | LookML model name |
| view | string | LookML explore (view) name |
| fields | array | List of field names to include in the query results (e.g. orders.count, users.created_date) |
| pivots | array | List of field names to pivot on |
| fill_fields | array | Fields to fill missing date values for |
| filters | object | Key-value map of filter expressions. Keys are field names and values are Looker filter expressions. |
| filter_expression | string | Custom filter expression using Looker filter syntax |
| sorts | array | Sort order for results. Each item is a field name optionally followed by asc or desc. |
| limit | string | Maximum number of rows to return (as string) |
| column_limit | string | Maximum number of columns for pivoted results |
| total | boolean | Whether to include row totals |
| row_total | string | Row total display setting |
| subtotals | array | Fields to subtotal on |
| dynamic_fields | string | JSON string of dynamic field definitions |
| vis_config | object | Visualization configuration object |
| query_timezone | string | Timezone for date/time calculations |
| client_id | string | Client-generated hash of the query for caching |
| slug | string | Short unique URL slug for this query |
| share_url | string | Shareable URL for this query |
| url | string | Relative URL for this query in the Looker UI |
| has_table_calculations | boolean | Whether this query has table calculations |