I hope i can find a solution or even a work-around to my problem, as I’ve already searched the community for similar problems and unfortunately I’ve found no valid answer till end of 2018.
I’ve created 4 models with 3 different connection to 3 different Databases [The main reason for creating 3 different data bases is security as different person handle each database and so we are limiting access to other DBs]
Explores are working fine if I queried data only from the same Model , But when I try to join data from different Models together I get the following error message:
After searching the community and the documentations, I have discovered the the error message appears because I query data from multiple connections and the model can only use one connection.
I believe that getting data from multiple sources in a very normal practice, So how can Looker join these Data sources together while insisting on not talking to multiple connection at same time?
Is there a solution or a work-around for that ?
Appreciate your swift assistance please