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 ;;
}
}
join: view_name {
sql_foreign_key: A SQL clause ;;
}
}
Hierarchysql_foreign_key |
Default ValueNoneAcceptsA SQL clauseSpecial Rulessql_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.