Hello,
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 tableusers
. - 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 tableusers
and a columnexternal_id
which is equal toapp_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