The thing is i have separate merchant databases for unique merchants with the same database schema. how can i isolate data and create questions.
{{db_name)).table_name won’t works for me and i guess it’s a issue already concerned in metabase.
is there any other way people follow? open to discuss more ways to resolve this and best practises to create questions in this scenario.
If you have a 1 customer 1 database model then you will need the database routing feature to keep from having to clone or recreate all your questions and dashboards for each new customer. This is a paid feature.
If you’re not willing to upgrade to a paid Metabase version, this recently posted tool may be useful to you, but search the board as there have been others.
Thanks @dwhitemv for the suggestions.
I have to create separate users for separate merchants in case i use database routing. an
d as i have 5000+ merchants i don’t afford to pay 12$ per user just to show them analytics. is there any smart way we have so that i don’t have to create users and i can achieve the functionality i want? please provide solutions which are feasible because it’s not feasible to create separate questions or dashboards for separate merchants.
Use embedded dashboards and pass a locked filter using ‘some other’ security mechanism.
Cool @AndrewMBaines !
Can I pass db_name as a locked filter in Metabase? As far as I understand, Metabase does not allow using identifiers (like database names) as variables.
Yoiu need to do some db work to create a layer over all the otehr databases.