Get All Running Queries

Version 4.0.24.20 (latest)

Get information about all running queries.

Request

GET /running_queries
Datatype
Description
Request
HTTP Request

Response

200: Running Queries.

Datatype
Description
(array)
can
object
Operations the current user is able to perform on this object
id
string
Unique Id
user
User who initiated the query
Expand UserPublic definition...
can
object
Operations the current user is able to perform on this object
id
string
Unique Id
first_name
string
First Name
last_name
string
Last Name
display_name
string
Full name for display (available only if both first_name and last_name are set)
avatar_url
string
URL for the avatar image (may be generic)
url
string
Link to get this item
query
Query that was run
Expand Query definition...
can
object
Operations the current user is able to perform on this object
id
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
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
string
Share Url
expanded_share_url
string
Expanded Share Url
url
string
Expanded Url
query_timezone
string
Query Timezone
has_table_calculations
boolean
Has Table Calculations
sql_query
SQL Query that was run
Expand SqlQuery definition...
can
object
Operations the current user is able to perform on this object
slug
string
The identifier of the SQL query
last_runtime
number
Number of seconds this query took to run the most recent time it was run
run_count
integer
Number of times this query has been run
browser_limit
integer
Maximum number of rows this query will display on the SQL Runner page
sql
string
SQL query text
last_run_at
string
The most recent time this query was run
connection
Connection this query uses
Expand DBConnectionBase definition...
can
object
Operations the current user is able to perform on this object
name
string
Name of the connection. Also used as the unique identifier
dialect
(Read-only) SQL Dialect details
snippets
pdts_enabled
boolean
True if PDTs are enabled on this connection
model_name
string
Model name this query uses
creator
User who created this SQL query
Expand UserPublic definition...
can
object
Operations the current user is able to perform on this object
id
string
Unique Id
first_name
string
First Name
last_name
string
Last Name
display_name
string
Full name for display (available only if both first_name and last_name are set)
avatar_url
string
URL for the avatar image (may be generic)
url
string
Link to get this item
explore_url
string
Explore page URL for this SQL query
plaintext
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.
look
Look of query that was run
Expand LookBasic definition...
can
object
Operations the current user is able to perform on this object
content_metadata_id
string
Id of content metadata
id
string
Unique Id
title
string
Look Title
user_id
string
User Id
created_at
string
Date/Time Query was initiated
completed_at
string
Date/Time Query was completed
query_id
string
Query Id
source
string
Source (look, dashboard, queryrunner, explore, etc.)
node_id
string
Node Id
slug
string
Slug
query_task_id
string
ID of a Query Task
cache_key
string
Cache Key
connection_name
string
Connection
dialect
string
Dialect
connection_id
string
Connection ID
message
string
Additional Information(Error message or verbose status)
status
string
Status description
runtime
number
Number of seconds elapsed running the Query
sql
string
SQL text of the query as run
sql_interface_sql
string
SQL text of the SQL Interface query as run

404: Not Found

Datatype
Description
(object)
message
string
Error details
documentation_url
string
Documentation link

429: Too Many Requests

Datatype
Description
(object)
message
string
Error details
documentation_url
string
Documentation link

Examples