Can we join more than 50 views to create a single explore?
If it is possible , then do we have to write multiple join statements (i.e more than 50 join statements )in the look ml ?
For instance , lets just say there are views like A,B,C , D….Z
To create one common explore , do we have to write multiple join statements as shown below?
explore: A {
join: B {
type: left_outer
sql_on: ${A.id}=${B.id};;
relationship:one_to_one
}
join: C {
type: left_outer
sql_on: ${A.id}=${C.id} ;;
relationship: one_to_one
}
join: D {
type: left_outer
sql_on: ${A.id}=${D.id} ;;
relationship: one_to_one
}
and so on till Z
}