I’m exploring the possibility of creating Explores by joining tables from databases hosted on different physical machines. Judging from this article, Looker recommends performing the federated join at the database level (which is not possible in my case).
However, Looker also offers the Merged Results feature, which appears to do what I’m looking for but appears to be intended for one-off tasks. Is there a way to create merged results in LookML and save them in a model as an Explore? Is there any other mechanism that I can use to create joins from different connections?
Thanks for any help!