LookmlModelExploreJoins Stay organized with collections Save and categorize content based on your preferences.
Version 4.0.26.2 (latest)
Datatype
Description
(object)
object
name
lock
string
Name of this join (and name of the view to join)
dependent_fields
string[]
fields
string[]
foreign_key
lock
string
Name of the dimension in this explore whose value is in the primary key of the joined view
from
lock
string
Name of view to join
outer_only
lock
boolean
Specifies whether all queries must use an outer join
relationship
lock
string
many_to_one, one_to_one, one_to_many, many_to_many
required_joins
string[]
sql_foreign_key
lock
string
SQL expression that produces a foreign key
sql_on
lock
string
SQL ON expression describing the join condition
sql_table_name
lock
string
SQL table name to join
type
lock
string
The join type: left_outer, full_outer, inner, or cross
view_label
lock
string
Label to display in UI selectors
Related Types
Except as otherwise noted, the content of this page is licensed under theCreative Commons Attribution 4.0 License, and code samples are licensed under theApache 2.0 License. For details, see theGoogle Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2026-02-09 UTC.