I want to set up a metabase instance for client servicing team in my organization. The structure of the team is such, each member of CS team handles 3-4 clients. I want to set up filtered / parametrized query on the dashboard view which I have set up for the client services team. Eg. if Person A log’s in to to metabase then he just get’s to view the dashboard for clients <X,Y,Z> associated with A.
Also I want to restrict functionality of Metabase to these users so that they cannot query adhoc on Metabase either through UI or SQL. They should only be able to view questions and dashboard.