Version 4.0.24.20 (latest)
Datatype
Description
(object)
id
lock
Unique Id.
dynamic_fields
lock
JSON string of dynamic field information.
filterables
Expand ResultMakerFilterables definition...
model
lock
The model this filterable comes from (used for field suggestions).
view
lock
The view this filterable comes from (used for field suggestions).
name
lock
The name of the filterable thing (Query or Merged Results).
listen
Expand ResultMakerFilterablesListen definition...
dashboard_filter_name
The name of a dashboard filter to listen to.
field
The name of the field in the filterable to filter with the value of the dashboard filter.
sorts
merge_result_id
lock
ID of merge result if this is a merge_result.
total
lock
Total of the constituent Look, Query, or Merge Query
query_id
lock
ID of query if this is a query.
sql_query_id
lock
ID of SQL Query if this is a SQL Runner Query
query
lock
Query
Expand Query definition...
can
lock
Operations the current user is able to perform on this object
id
lock
Unique Id
model
Model
view
Explore Name
fields
pivots
fill_fields
filters
Filters will contain data pertaining to complex filters that do not contain "or" conditions. When "or" conditions are present, filter data will be found on the `filter_expression` property.
filter_expression
Filter Expression
sorts
limit
Row limit. To download unlimited results, set the limit to -1 (negative one).
column_limit
Column Limit
total
Total
row_total
Raw Total
subtotals
vis_config
Visualization configuration properties. These properties are typically opaque and differ based on the type of visualization used. There is no specified set of allowed keys. The values can be any type supported by JSON. A "type" key with a string value is often present, and is used by Looker to determine which visualization to present. Visualizations ignore unknown vis_config properties.
filter_config
The filter_config represents the state of the filter UI on the explore page for a given query. When running a query via the Looker UI, this parameter takes precedence over "filters". When creating a query or modifying an existing query, "filter_config" should be set to null. Setting it to any other value could cause unexpected filtering behavior. The format should be considered opaque.
visible_ui_sections
Visible UI Sections
slug
lock
Slug
dynamic_fields
Dynamic Fields
client_id
Client Id: used to generate shortened explore URLs. If set by client, must be a unique 22 character alphanumeric string. Otherwise one will be generated.
share_url
lock
Share Url
expanded_share_url
lock
Expanded Share Url
url
lock
Expanded Url
query_timezone
Query Timezone
has_table_calculations
lock
Has Table Calculations
vis_config
lock
Vis config of the constituent Query, or Merge Query.