[[["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,["# JsonBi\n\nVersion 4.0.25.14 (latest) \nDatatype \nDescription \n(object) \nobject \nmetadata \n*lock* \n[JsonBiMetadata](/looker/docs/reference/looker-api/latest/types/JsonBiMetadata) \nMetadata about the query\nExpand JsonBiMetadata definition... \nbig_query_metadata \n*lock* \n[JsonBiBigQueryMetadata](/looker/docs/reference/looker-api/latest/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/latest/types/JsonBiFields) \nFields\nExpand JsonBiFields definition... \ndimensions \n[JsonBiField](/looker/docs/reference/looker-api/latest/types/JsonBiField)\\[\\] \nmeasures \n[JsonBiField](/looker/docs/reference/looker-api/latest/types/JsonBiField)\\[\\] \npivots \n[JsonBiField](/looker/docs/reference/looker-api/latest/types/JsonBiField)\\[\\] \ntable_calculations \n[JsonBiTableCalc](/looker/docs/reference/looker-api/latest/types/JsonBiTableCalc)\\[\\] \npivots \n[JsonBiPivots](/looker/docs/reference/looker-api/latest/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\nRelated Methods\n---------------\n\n- [SqlInterfaceQuery/run_sql_interface_query](../methods/SqlInterfaceQuery/run_sql_interface_query \"SqlInterfaceQuery/run_sql_interface_query\")"]]
