View the original community article here
Last tested: May 15, 2020
Joins in explores have to have either a sql (docs) or sql_on (docs) parameter to define the relationship of one view to another.
Using sql_on:
explore: order {
join: customer {
sql_on: ${order.customer_id} = ${customer.id} ;;
}
}
Using sql:
explore: order {
join: customer {
sql: LEFT JOIN ON ${order.customer_id} = ${customer.id} ;;
}
}
This content is subject to limited support.