Hi, I am Devesh Arora, working as a data analyst intern in a startup company.
I am using metabase to create reports of specific data using sql queries for large data, and question for smaller data. Please help me understand, how can I customize the access provided to the different users, after creating and uploading the reports on metabase.
In this scenario, there are more than 300 different users at various locations and I want to modify the access in such a way that a specific user can only and only access the respective amount of data included in the report. The database is quite large, and hence it is difficult to make different collections and provide the access manually.
I think you're after row level permissions which can be done with sandboxing:
This is a paid feature though and the option you mentioned about different collections would be the only other option I can think of
Thank you so much for your suggestion, appreciate it.