We have custom react application running on looker instance. Currently we are facing issue for solution we need to create a view where drive table will be joined from two table. While one table reside on mssql while other one is in databricks. We are able to fetch data separately, but we are not able to fetch through one view.
Please let us know if there is any solution for this situation.
Hello tauseef881,
I understand that you want to use data from two distinct connections/sources in a single result. Generally speaking, you should consider whether processes can be put in place to land the data into a single database/location. This will open up possibilities for robust queries which reference both datasets.
If you are unable to set up such data pipelines, you may consider Looker’s Merged Results feauture. This feature effectively allows you to run two separate queries on two separate connections, get aggregated results, and then join those in the browser. To be clear, though, Merged results are often considered challenging for end users to build/edit on their own, and can only join not on raw granular data but rather on query results (which are limited to 5000 rows).
I hope this helps!
-Kevin