Querying through multiple DB of single server

Please give me a solution for joining tables from multiple DBs like I want to find the customer name who has highest number of purchase. But in Purchase DB I've the table only with Customer ID not names, address and other personal details. These personal details are in another DB. So please give me the solution for overcome this problem.

We are running into huge problem because of this, as we could not use the dashboard to find the insights.

This is just the glimpse of the problem. Please help me out.

Hi @SaravananJP
Metabase does not support queries across different database connections:
https://github.com/metabase/metabase/issues/3953 - upvote by clicking :+1: on the first post

You would have to add all your databases to a single warehouse.