Scenario with more than one database per client


I am trying to figure out if its possible to reach the goal of my company with Metabase. We have a software(SaaS) with one database per client(same structure for all databases).

The goal is to embed a BI platform in our software and create shared dashboards to our clients. For the clients who want some custom report we would do with a consultant.

Is it possible in some way?

Ps. One way that I could imagine is to connect in our API instead to connect directly on the databases(We have one unique API that knows which database should to connect using the token of the user).

Ps.2: I saw this another question , but seems to me that was not resolved.

Thank you very much :smiley: