User Guide Getting Started Help Center Documentation Community Training
New LookML
Old LookML
New LookML
Join Parameters

This page links to all of the LookML parameters that are children of the join parameter. You can learn more about using joins on this page.

A join is what allows multiple views to be added to a single Explore, allowing users to access and compare fields from various views at the same time. You declare the Explore and any desired join parameters in a model file.

Example Usage

Hover over a parameter name to see a quick description; click it to jump to that page.
When a parameter can be set to one of several specific options, the default value is listed first.

explore: explore_name {
  # Desired explore parameters (described on Explore Parameters page)

  join: join_name {

    view_label: "View Label I Want"

    fields: [field_or_set, field_or_set, …]
    foreign_key: dimension_name
    from: view_name
    outer_only: no | yes
    relationship: many_to_one | many_to_many | one_to_many | one_to_one
    required_joins: [view_name, view_name, …]
    sql_on: SQL ON clause ;;
    sql_table_name: table_name ;;
    type: left_outer | cross | full_outer | inner

    required_access_grants: [access_grant_name, access_grant_name, …]
    sql_where: SQL WHERE condition ;;
  # Possibly more join declarations

Parameter Definitions

Parameter Name Description
Structural Parameters
join Join an additional view to an Explore
Display Parameters
view_label (for join) Change the way the join’s view name appears in the Field Picker
Join Parameters
fields (for join) Determine which fields from a join are brought into an Explore
foreign_key Specify a relationship between an Explore and a join using the joined view’s primary key
from (for join) Specify the view on which a join will be based
outer_only Specify whether all queries must use an outer join
relationship Declare a join as having a one-to-one, many-to-one, one-to-many, or many-to-many relationship
required_joins Specify which joins should be applied to an Explore when fields from a certain join are chosen
sql_on Specify a relationship between an Explore and a join by writing a SQL ON clause
sql_table_name (for join) Specify the database table on which a join will be based
type (for join) Declare a join as being a left, full, inner, or cross type
Query Parameters
required_access_grants (for join) ADDED6.0 Limit access to the join to only users whose user attribute values match the access grants
sql_where If this join is included in the query, inserts conditions into the query’s WHERE clause that a user cannot change or remove for this Explore. (For BigQuery only)
Parameters to Avoid
sql (for join) AVOID3.10 Replaced by a combination of sql_on, foreign_key, type, and/or sql_table_name, as described here
sql_foreign_key AVOID3.16 Replaced by foreign_key

Note: The always_join parameter specifies any joins that must always be applied to an Explore. That parameter is defined in an Explore, so it is listed on the explore parameter page.