Joining Data From Two Different Databases

Hello, everyone

There is an ongoing discussion in my workplace about gathering all our data in one place to avoid creatind data silos. Is it possible to pull the data from different silos direct to metabase?

I can give a more concrete example. Whenever I have to write a Query, I have to pick a data source:

To get all the Data in one place, we have to direct it from the different sources to a common database. This database is connected to Metabase and it is what we’re using to make queries.

Is there a way to “load” all the different Databases into Metabase - and merge them. Let’s say, is there a way to cut off the middle man? Or do we always have to “prepare” the data into a common database, from which metabase then retrieves it’s data?

Thanks for the Clarification

Hi @celioxf
No, Metabase does not support queries across databases. You would need to setup a warehouse in SQL Server, BigQuery, Athena or any other supported database that supports that.
https://github.com/metabase/metabase/issues/3953 - upvote by clicking :+1: on the first post

1 Like