Joining multiple views(more than 50 ) to create a single explore

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
 }

0 1 985
1 REPLY 1
Top Labels in this Space
Top Solution Authors