Row limit (may override the limit in the saved query).
apply_formatting
boolean
Apply model-specified formatting to each result.
apply_vis
boolean
Apply visualization options to results.
cache
boolean
Get results from cache if available.
generate_drill_links
boolean
Generate drill links (only applicable to 'json_detail' format.
force_production
boolean
Force use of production models even if the user is in development mode. Note that this flag being false does not guarantee development models will be used.
cache_only
boolean
Retrieve any results from cache even if the results have expired.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-20 UTC."],[],[],null,["# Run Query Async\n\nVersion 4.0.25.14 (latest)\n\n### Create an async query task\n\nCreates a query task (job) to run a previously created query asynchronously. Returns a Query Task ID.\n\nUse [query_task(query_task_id)](/looker/docs/reference/looker-api/latest/methods/Query/query_task) to check the execution status of the query task.\nAfter the query task status reaches \"Complete\", use [query_task_results(query_task_id)](/looker/docs/reference/looker-api/latest/methods/Query/query_task_results) to fetch the results of the query.\n\nRequest\n-------\n\nPOST /query_tasks \nDatatype \nDescription \nRequest \nHTTP Request \nbody \nHTTP Body \nExpand HTTP Body definition... \nbody \n[CreateQueryTask](/looker/docs/reference/looker-api/latest/types/CreateQueryTask) \nQuery parameters\nExpand CreateQueryTask definition... \ncan \n*lock* \nobject \nOperations the current user is able to perform on this object \nquery_id \nstring \nId of query to run \nresult_format \nstring \nDesired async query result format. Valid values are: \"inline_json\", \"json\", \"json_detail\", \"json_fe\", \"json_bi\", \"csv\", \"html\", \"md\", \"txt\", \"xlsx\", \"gsxml\", \"sql\", \"odc\". \nsource \nstring \nSource of query task \ndeferred \nboolean \nCreate the task but defer execution \nlook_id \nstring \nId of look associated with query. \ndashboard_id \nstring \nId of dashboard associated with query. \nquery \nHTTP Query \nExpand HTTP Query definition... \nlimit \ninteger \nRow limit (may override the limit in the saved query). \napply_formatting \nboolean \nApply model-specified formatting to each result. \napply_vis \nboolean \nApply visualization options to results. \ncache \nboolean \nGet results from cache if available. \ngenerate_drill_links \nboolean \nGenerate drill links (only applicable to 'json_detail' format. \nforce_production \nboolean \nForce use of production models even if the user is in development mode. Note that this flag being false does not guarantee development models will be used. \ncache_only \nboolean \nRetrieve any results from cache even if the results have expired. \npath_prefix \nstring \nPrefix to use for drill links (url encoded). \nrebuild_pdts \nboolean \nRebuild PDTS used in query. \nserver_table_calcs \nboolean \nPerform table calculations on query results \nfields \nstring \nRequested fields\n\nResponse\n--------\n\n### 200: query_task\n\nDatatype \nDescription \n(object) \n[QueryTask](/looker/docs/reference/looker-api/latest/types/QueryTask) \ncan \n*lock* \nobject \nOperations the current user is able to perform on this object \nid \n*lock* \nstring \nUnique Id \nquery_id \nstring \nId of query \nquery \n*lock* \n[Query](/looker/docs/reference/looker-api/latest/types/Query) \nQuery\nExpand Query definition... \ncan \n*lock* \nobject \nOperations the current user is able to perform on this object \nid \n*lock* \nstring \nUnique Id \nmodel \nstring \nModel \nview \nstring \nExplore Name \nfields \nstring\\[\\] \npivots \nstring\\[\\] \nfill_fields \nstring\\[\\] \nfilters \nobject \nFilters 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. \nfilter_expression \nstring \nFilter Expression \nsorts \nstring\\[\\] \nlimit \nstring \nRow limit. To download unlimited results, set the limit to -1 (negative one). \ncolumn_limit \nstring \nColumn Limit \ntotal \nboolean \nTotal \nrow_total \nstring \nRaw Total \nsubtotals \nstring\\[\\] \nvis_config \nobject \nVisualization 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. \nfilter_config \nobject \nThe 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. \nvisible_ui_sections \nstring \nVisible UI Sections \nslug \n*lock* \nstring \nSlug \ndynamic_fields \nstring \nDynamic Fields \nclient_id \nstring \nClient Id: used to generate shortened explore URLs. If set by client, must be a unique 22 character alphanumeric string. Otherwise one will be generated. \nshare_url \n*lock* \nstring \nShare Url \nexpanded_share_url \n*lock* \nstring \nExpanded Share Url \nurl \n*lock* \nstring \nExpanded Url \nquery_timezone \nstring \nQuery Timezone \nhas_table_calculations \n*lock* \nboolean \nHas Table Calculations \ngenerate_links \nboolean \nwhether or not to generate links in the query response. \nforce_production \nboolean \nUse production models to run query (even is user is in dev mode). \npath_prefix \nstring \nPrefix to use for drill links. \ncache \nboolean \nWhether or not to use the cache \nserver_table_calcs \nboolean \nWhether or not to run table calculations on the server \ncache_only \nboolean \nRetrieve any results from cache even if the results have expired. \ncache_key \n*lock* \nstring \ncache key used to cache query. \nstatus \nstring \nStatus of query task. \nsource \nstring \nSource of query task. \nruntime \n*lock* \nnumber \nRuntime of prior queries. \nrebuild_pdts \nboolean \nRebuild PDTS used in query. \nresult_source \n*lock* \nstring \nSource of the results of the query. \nlook_id \nstring \nId of look associated with query. \ndashboard_id \nstring \nId of dashboard associated with query. \nresult_format \n*lock* \nstring \nThe data format of the query results.\n\n### 400: Bad Request\n\nDatatype \nDescription \n(object) \n[Error](/looker/docs/reference/looker-api/latest/types/Error) \nmessage \n*lock* \nstring \nError details \ndocumentation_url \n*lock* \nstring \nDocumentation link\n\n### 404: Not Found\n\nDatatype \nDescription \n(object) \n[Error](/looker/docs/reference/looker-api/latest/types/Error) \nmessage \n*lock* \nstring \nError details \ndocumentation_url \n*lock* \nstring \nDocumentation link\n\n### 409: Resource Already Exists\n\nDatatype \nDescription \n(object) \n[Error](/looker/docs/reference/looker-api/latest/types/Error) \nmessage \n*lock* \nstring \nError details \ndocumentation_url \n*lock* \nstring \nDocumentation link\n\n### 422: Validation Error\n\nDatatype \nDescription \n(object) \n[ValidationError](/looker/docs/reference/looker-api/latest/types/ValidationError) \nmessage \n*lock* \nstring \nError details \nerrors \n[ValidationErrorDetail](/looker/docs/reference/looker-api/latest/types/ValidationErrorDetail)\\[\\] \nExpand ValidationErrorDetail definition... \nfield \n*lock* \nstring \nField with error \ncode \n*lock* \nstring \nError code \nmessage \n*lock* \nstring \nError info message \ndocumentation_url \n*lock* \nstring \nDocumentation link \ndocumentation_url \n*lock* \nstring \nDocumentation link\n\n### 429: Too Many Requests\n\nDatatype \nDescription \n(object) \n[Error](/looker/docs/reference/looker-api/latest/types/Error) \nmessage \n*lock* \nstring \nError details \ndocumentation_url \n*lock* \nstring \nDocumentation link\n\nExamples\n--------\n\n### Python\n\n\n### Kotlin\n\n\n### TypeScript"]]
