I'm looking for a good product to use across two clouds at once for Data Engineering, Data modeling and governance. I currently have a GCP platform, but most of my data and future data goes through Azure, and currently is then transfered to GCS/BQ.

Currently I use Looker as my main tool for visualisation, but will incorperate Power BI as a secondary tool soon. But to skip the transfere of data from Azure, to GCP and then back to Power BI I've been looking to make some changes. Here I've been looking at Databricks to be able to query both data in Bigquery and send to Looker/Power BI, but also be able to crunch data in Azure, and maybe combine with a small subset of data or pre-aggregations of data from Bigquery, if the majority of the data already reside in the Azure cloud.

Databricks talks a lot about mutlicloud, but I still havent figured out if its a good way to use only one instance to control both clouds/lakes at the same time.

Is there any good examples out there? except Databricks own multicloud solution for monitoring, as that one seems to run 3 different cloud instances of databricks, isolated from each other.