I have a Snowflake instance which has multiple databases.
Each database is for one customer.
I now want to create one internal dashboard with a filter where my team can select which customer and accordingly query has to be routed to that database in snowflake to get that customer details and show in the vizualisations. How to do this ?
Thanks in Advance
we're building a PoC to make this happen. Right now all your tenants need to be in the same table and you should use sandboxing or impersonation
I"m interested in something similar. Currently building out a PoC of Metabase to see if it will work for our Multi-Tenant SaaS as well. We want our internal staff to build Dashboards, pre-defined questions etc that we can embed into our application where the embed jwt would define the "schema" or database to talk to. Will parameterization of the database/schema be a part of the PoC you are working on at Metabase be now? We have 50+ tenants at this time, so we really don't want to have to set up a Metabase per tenant to be able to do this.