Get All Running Queries

can

lock

object

Operations the current user is able to perform on this object

id

lock

string

Unique Id

first_name

lock

string

First Name

last_name

lock

string

Last Name

display_name

lock

string

Full name for display (available only if both first_name and last_name are set)

avatar_url

lock

string

URL for the avatar image (may be generic)

url

lock

string

Link to get this item

can

lock

object

Operations the current user is able to perform on this object

id

lock

string

Unique Id

model

string

Model

view

string

Explore Name

fields

string[]

pivots

string[]

fill_fields

string[]

filters

object

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

string

Filter Expression

sorts

string[]

limit

string

Row limit. To download unlimited results, set the limit to -1 (negative one).

column_limit

string

Column Limit

total

boolean

Total

row_total

string

Raw Total

subtotals

string[]

vis_config

object

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

object

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

string

Visible UI Sections

slug

lock

string

Slug

dynamic_fields

string

Dynamic Fields

client_id

string

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

string

Share Url

expanded_share_url

lock

string

Expanded Share Url

url

lock

string

Expanded Url

query_timezone

string

Query Timezone

has_table_calculations

lock

boolean

Has Table Calculations

can

lock

object

Operations the current user is able to perform on this object

slug

lock

string

The identifier of the SQL query

last_runtime

lock

number

Number of seconds this query took to run the most recent time it was run

run_count

lock

integer

Number of times this query has been run

browser_limit

lock

integer

Maximum number of rows this query will display on the SQL Runner page

sql

lock

string

SQL query text

last_run_at

lock

string

The most recent time this query was run

connection

lock

DBConnectionBase

Connection this query uses

model_name

lock

string

Model name this query uses

creator

lock

UserPublic

User who created this SQL query

explore_url

lock

string

Explore page URL for this SQL query

plaintext

lock

boolean

Should this query be rendered as plain text

vis_config

object

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.

result_maker_id

string

ID of the ResultMakerLookup entry.

can

lock

object

Operations the current user is able to perform on this object

content_metadata_id

lock

string

Id of content metadata

id

lock

string

Unique Id

title

lock

string

Look Title

user_id

string

User Id