Looker · JSON Structure

Looker Query Structure

Type: object Properties: 22
AnalyticsBI PlatformBusiness IntelligenceData AnalyticsData Visualization

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

Properties

id model view fields pivots fill_fields filters filter_expression sorts limit column_limit total row_total subtotals dynamic_fields vis_config query_timezone client_id slug share_url url has_table_calculations

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

JSON Structure

Raw ↑ 
{
  "$schema": "https://json-structure.org/draft/2020-12/schema",
  "name": "Query",
  "type": "object",
  "properties": {
    "id": {
      "type": "integer"
    },
    "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"
    },
    "client_id": {
      "type": "string"
    },
    "slug": {
      "type": "string"
    },
    "share_url": {
      "type": "string"
    },
    "url": {
      "type": "string"
    },
    "has_table_calculations": {
      "type": "boolean"
    }
  }
}