Version 4.0.24.14
Datatype
Description
(object)
metadata
lock
Metadata about the query
Expand JsonBiMetadata definition...
big_query_metadata
lock
Metadata returned from Bigquery. Null if any other dialect.
Expand JsonBiBigQueryMetadata definition...
total_bytes_processed
lock
Total bytes processed by the BigQuery job
backend_cache_hit
lock
Return whether or not query results were served from the BigQuery cache.
fields
lock
Fields
Expand JsonBiFields definition...
dimensions
measures
pivots
table_calculations
pivots
Expand JsonBiPivots definition...
key
lock
Pivot Column Value
data
lock
Pivot Data
sort_values
lock
Pivot Sort Values
is_total
lock
If the value is a total
has_subtotals
lock
If the query has subtotals
has_totals
lock
If the query has totals
columns_truncated
lock
If the query results hit the maximum column limit and additional columns were truncated
filter_expression
lock
Filter expression applied to the query results
filters
lock
Filters applied to the query results
sql
lock
Raw sql query. Null if user does not have permission to view sql
rows