Console
    Start free

    LookmlModelExploreJoins

    Version 4.0.25.20 (latest)
    Datatype
    Description
    (object)
    object
    name
    string
    Name of this join (and name of the view to join)
    dependent_fields
    string[]
    fields
    string[]
    foreign_key
    string
    Name of the dimension in this explore whose value is in the primary key of the joined view
    from
    string
    Name of view to join
    outer_only
    boolean
    Specifies whether all queries must use an outer join
    relationship
    string
    many_to_one, one_to_one, one_to_many, many_to_many
    required_joins
    string[]
    sql_foreign_key
    string
    SQL expression that produces a foreign key
    sql_on
    string
    SQL ON expression describing the join condition
    sql_table_name
    string
    SQL table name to join
    type
    string
    The join type: left_outer, full_outer, inner, or cross
    view_label
    string
    Label to display in UI selectors
    Create a Mobile Website
    View Site in Mobile | Classic
    Share by: