Querying data from multiple database


I am new to Metabase and I want some help to me on the right path to setup a question that queries from 2 databases. Our databases are configured in 1 Metabase instance.

I have 2 apps:

  • App A which has a db app_a with a table users.
  • App B which has a db totally on a diff server but is communicating with App A by some REST api. This db is app_b with a table users and a column external_id which is equal to app_a.users.id

My question should somehow output these columns

App A User Id | App B External User Id | … | some other columns from App A and App B.

Is this possible?

Thanks for the help

Hi @john_ferraris
You need to setup a data warehouse that joins the two databases.

1 Like

Appreciate the inputs @flamber I was really hoping for the non data warehouse solution. But seems like my scenario is a good use case for its own data warehouse

@john_ferraris Then Metabase would have to act as the warehouse, which is something that we’re looking at, but that’s a gigantic task by itself:
https://github.com/metabase/metabase/issues/3953 - upvote by clicking :+1: on the first post