QueryFormats

Version 4.0.24.6 (latest)
Datatype
Description
(object)
object
json_bi
Expand JsonBi definition...
metadata
Metadata about the query
Expand JsonBiMetadata definition...
big_query_metadata
Metadata returned from Bigquery. Null if any other dialect.
fields
Fields
pivots
has_subtotals
boolean
If the query has subtotals
has_totals
boolean
If the query has totals
columns_truncated
string
If the query results hit the maximum column limit and additional columns were truncated
filter_expression
string
Filter expression applied to the query results
filters
object
Filters applied to the query results
sql
string
Raw sql query. Null if user does not have permission to view sql
rows
string[]
json
string
json_detail
string
csv
string
txt
string
html
string
md
string
xlsx
string
sql
string