User Guide Getting Started Help Center Documentation Community Training
New LookML
Old LookML
New LookML
Looker
  
English
日本語
sql_foreign_key

sql_foreign_key should be avoided as of Looker 3.16.

Use foreign_key instead.

Usage

explore: explore_name {
  join: view_name {
    sql_foreign_key: A SQL clause ;;
  }
}

Hierarchy

sql_foreign_key

Default Value

None

Accepts

A SQL clause

Special Rules

sql_foreign_key, foreign_key, and sql_on may not be used at the same time within the same join

Definition

The sql_foreign_key parameter specifies a SQL statement that produces a foreign key.

Top