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
View JSON Schema on GitHub

JSON Schema

looker-write-query-schema.json Raw ↑ 
{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "title": "WriteQuery",
  "type": "object",
  "description": "Writable fields for creating a new query",
  "properties": {
    "model": {
      "type": "string",
      "description": "LookML model name"
    },
    "view": {
      "type": "string",
      "description": "LookML explore (view) name"
    },
    "fields": {
      "type": "array",
      "description": "List of field names to include"
    },
    "pivots": {
      "type": "array",
      "description": "Fields to pivot on"
    },
    "fill_fields": {
      "type": "array",
      "description": "Fields to fill missing values for"
    },
    "filters": {
      "type": "object",
      "description": "Filter expressions keyed by field name"
    },
    "filter_expression": {
      "type": "string",
      "description": "Custom filter expression"
    },
    "sorts": {
      "type": "array",
      "description": "Sort order for results"
    },
    "limit": {
      "type": "string",
      "description": "Maximum rows to return"
    },
    "column_limit": {
      "type": "string",
      "description": "Maximum columns for pivoted results"
    },
    "total": {
      "type": "boolean",
      "description": "Include row totals"
    },
    "row_total": {
      "type": "string",
      "description": "Row total setting"
    },
    "subtotals": {
      "type": "array",
      "description": "Fields to subtotal on"
    },
    "dynamic_fields": {
      "type": "string",
      "description": "JSON string of dynamic field definitions"
    },
    "vis_config": {
      "type": "object",
      "description": "Visualization configuration"
    },
    "query_timezone": {
      "type": "string",
      "description": "Timezone for date/time calculations"
    }
  }
}