JsonBiMetadata

Version 4.0.24.20 (latest)
Datatype
Description
(object)
object
big_query_metadata
Metadata returned from Bigquery. Null if any other dialect.
Expand JsonBiBigQueryMetadata definition...
total_bytes_processed
integer
Total bytes processed by the BigQuery job
backend_cache_hit
boolean
Return whether or not query results were served from the BigQuery cache.
fields
Fields
Expand JsonBiFields definition...
dimensions
Expand JsonBiField definition...
sql
string
SQL expressions for the field
view
string
Explore name
dimension_group
string
Which dimension group created this dimension
category
string
Dimension, Measure, etc.
field_group_label
string
Field Group Label
name
string
Field Name
type
string
Field Type
view_label
string
View Label
label
string
Field Label
field_group_variant
string
Field Group Variant
hidden
boolean
If the field is marked as hidden in the Lookml
description
string
Field Description
measures
Expand JsonBiField definition...
sql
string
SQL expressions for the field
view
string
Explore name
dimension_group
string
Which dimension group created this dimension
category
string
Dimension, Measure, etc.
field_group_label
string
Field Group Label
name
string
Field Name
type
string
Field Type
view_label
string
View Label
label
string
Field Label
field_group_variant
string
Field Group Variant
hidden
boolean
If the field is marked as hidden in the Lookml
description
string
Field Description
pivots
Expand JsonBiField definition...
sql
string
SQL expressions for the field
view
string
Explore name
dimension_group
string
Which dimension group created this dimension
category
string
Dimension, Measure, etc.
field_group_label
string
Field Group Label
name
string
Field Name
type
string
Field Type
view_label
string
View Label
label
string
Field Label
field_group_variant
string
Field Group Variant
hidden
boolean
If the field is marked as hidden in the Lookml
description
string
Field Description
table_calculations
Expand JsonBiTableCalc definition...
name
string
Table Calc Name
label
string
Table Calc Label
align
string
Alignment
expression
string
Evaluated table calculation expression
value_format
string
Value format
measure
boolean
If table calculation is a measure
pivots
Expand JsonBiPivots definition...
key
string
Pivot Column Value
data
object
Pivot Data
sort_values
object
Pivot Sort Values
is_total
boolean
If the value is a total
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