Console

    JsonBiMetadata

    Version 4.0.25.14 (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
    Create a Mobile Website
    View Site in Mobile | Classic
    Share by: