[[["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 SQL Interface Query\n\nVersion 4.0.25.10\n| **Note:** These docs are for an older version of the API. The API reference is also available for [the latest version, 4.0.25.14](/looker/docs/reference/looker-api/latest).\n\n### Run a saved SQL interface query.\n\nThis runs a previously created SQL interface query.\n\nThe 'result_format' parameter specifies the desired structure and format of the response.\n\nSupported formats:\n\nRequest\n-------\n\nGET /sql_interface_queries/{query_id}/run/{result_format} \nDatatype \nDescription \nRequest \nHTTP Request \npath \nHTTP Path \nExpand HTTP Path definition... \nquery_id \ninteger \nInteger id of query \nresult_format \nstring \nFormat of result, options are: \\[\"json_bi\"\\]\n\nResponse\n--------\n\n### 200: Query Result\n\nDatatype \nDescription \n(object) \n[JsonBi](/looker/docs/reference/looker-api/4.0/25.10/types/JsonBi) \nmetadata \n*lock* \n[JsonBiMetadata](/looker/docs/reference/looker-api/4.0/25.10/types/JsonBiMetadata) \nMetadata about the query\nExpand JsonBiMetadata definition... \nbig_query_metadata \n*lock* \n[JsonBiBigQueryMetadata](/looker/docs/reference/looker-api/4.0/25.10/types/JsonBiBigQueryMetadata) \nMetadata returned from Bigquery. Null if any other dialect.\nExpand JsonBiBigQueryMetadata definition... \ntotal_bytes_processed \n*lock* \ninteger \nTotal bytes processed by the BigQuery job \nbackend_cache_hit \n*lock* \nboolean \nReturn whether or not query results were served from the BigQuery cache. \nfields \n*lock* \n[JsonBiFields](/looker/docs/reference/looker-api/4.0/25.10/types/JsonBiFields) \nFields\nExpand JsonBiFields definition... \ndimensions \n[JsonBiField](/looker/docs/reference/looker-api/4.0/25.10/types/JsonBiField)\\[\\] \nmeasures \n[JsonBiField](/looker/docs/reference/looker-api/4.0/25.10/types/JsonBiField)\\[\\] \npivots \n[JsonBiField](/looker/docs/reference/looker-api/4.0/25.10/types/JsonBiField)\\[\\] \ntable_calculations \n[JsonBiTableCalc](/looker/docs/reference/looker-api/4.0/25.10/types/JsonBiTableCalc)\\[\\] \npivots \n[JsonBiPivots](/looker/docs/reference/looker-api/4.0/25.10/types/JsonBiPivots)\\[\\] \nExpand JsonBiPivots definition... \nkey \n*lock* \nstring \nPivot Column Value \ndata \n*lock* \nobject \nPivot Data \nsort_values \n*lock* \nobject \nPivot Sort Values \nis_total \n*lock* \nboolean \nIf the value is a total \nhas_subtotals \n*lock* \nboolean \nIf the query has subtotals \nhas_totals \n*lock* \nboolean \nIf the query has totals \ncolumns_truncated \n*lock* \nstring \nIf the query results hit the maximum column limit and additional columns were truncated \nfilter_expression \n*lock* \nstring \nFilter expression applied to the query results \nfilters \n*lock* \nobject \nFilters applied to the query results \nsql \n*lock* \nstring \nRaw sql query. Null if user does not have permission to view sql \nrows \nstring\\[\\] \n\n### 400: Bad Request\n\nDatatype \nDescription \n(object) \n[Error](/looker/docs/reference/looker-api/4.0/25.10/types/Error) \nmessage \n*lock* \nstring \nError details \ndocumentation_url \n*lock* \nstring \nDocumentation link\n\n### 403: Permission Denied\n\nDatatype \nDescription \n(object) \n[Error](/looker/docs/reference/looker-api/4.0/25.10/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/4.0/25.10/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/4.0/25.10/types/ValidationError) \nmessage \n*lock* \nstring \nError details \nerrors \n[ValidationErrorDetail](/looker/docs/reference/looker-api/4.0/25.10/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/4.0/25.10/types/Error) \nmessage \n*lock* \nstring \nError details \ndocumentation_url \n*lock* \nstring \nDocumentation link"]]
