View the original community article here
Last tested: May 2020
No, you can only reference LookML fields from other views. This is why we recommend making a base dimension for each field in the database.
Example
In the first view, make a dimension that references the database table.
view: orders {
...
dimension: id {
type: string
sql: ${TABLE}.id ;;
}
In the second view, reference that dimension.
dimension: order_id {
type: string
sql: ${orders.id} ;;
}
This content is subject to limited support.