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