We are currently considering shortlisting Metabase as one of our dashboard platforms. We are delighted to know that this platform support many of our desired functionalities. Kudos to the developers
One of our concerns in selecting dashboard is the user access control. Let's go straight to an example;
A table in our database contains a column named
region , it stores the region name information related to each row. We want our field team in each region to have an access to the dashboard, but they are supposed to have access only to the data related to their region. Thus, we need to restrict the dashboard display for each field users (e.g. something like adding
WHERE region = <region_name> in SQL query).
We also want our field user to explore the dashboard (e.g. they can filter the date, sort columns, do pivot table, display only records with specific criteria) but still with the data for their region.
We explored Metabase and found out that we can create users groups, restrict user access to table level, and we can also restrict the access to questions collection. But we can't find out how to configure Metabase as our description above.
It would be great if Metabase able to fulfill the requirements. Can we do that in the current version?
Any suggestions are welcome