Looker · JSON Structure

Looker Write Query Structure

Type: object Properties: 16
AnalyticsBI PlatformBusiness IntelligenceData AnalyticsData Visualization

WriteQuery is a JSON Structure definition published by Looker, describing 16 properties. It conforms to the https://json-structure.org/draft/2020-12/schema meta-schema.

Properties

model view fields pivots fill_fields filters filter_expression sorts limit column_limit total row_total subtotals dynamic_fields vis_config query_timezone

Meta-schema: https://json-structure.org/draft/2020-12/schema

JSON Structure

Raw ↑ 
{
  "$schema": "https://json-structure.org/draft/2020-12/schema",
  "name": "WriteQuery",
  "type": "object",
  "properties": {
    "model": {
      "type": "string"
    },
    "view": {
      "type": "string"
    },
    "fields": {
      "type": "array"
    },
    "pivots": {
      "type": "array"
    },
    "fill_fields": {
      "type": "array"
    },
    "filters": {
      "type": "object"
    },
    "filter_expression": {
      "type": "string"
    },
    "sorts": {
      "type": "array"
    },
    "limit": {
      "type": "string"
    },
    "column_limit": {
      "type": "string"
    },
    "total": {
      "type": "boolean"
    },
    "row_total": {
      "type": "string"
    },
    "subtotals": {
      "type": "array"
    },
    "dynamic_fields": {
      "type": "string"
    },
    "vis_config": {
      "type": "object"
    },
    "query_timezone": {
      "type": "string"
    }
  }
}