home User Guide Getting Started Help Center Documentation Community Training Certification
menu
close
settings
Looker keyboard_arrow_down
language keyboard_arrow_down
English
Français
Deutsch
日本語
search
print
sql_foreign_key

block

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