How can we give SQL query access to separate groups on a limited number of datasets?
I don’t know what “datasets” refers to, but data permissions for SQL are given per data source, since Metabase currently is not parsing the SQL to enforce schema/table/column level restrictions.
In simple terms, is there a way we can get SQL query access on a table level…Normally when we create groups and restrict them to a limited number of tables to access ,so can we provide them SQL query access to be doen only on those limited set of tables?
@abhi1986 Metabase currently is not parsing the SQL to enforce schema/table/column level restrictions.
You would have to setup a separate database with restricted credentials and then give people access to that database - it would come with it’s own problems like it’s a different database, so you cannot join across databases.
We are working on adding SQL permissions to the Enterprise Edition, which is one of the most requested functionalities, but there’s currently no timeline on that, since it’s not a simple thing to do.
DO we have any update on it? Is this feature available now to Provide SQL Query access with partial data access?
@debasish.nayak It is something that is very, very difficult to do. There's no timeline on it. If it every comes, then it will be a Pro/Enterprise feature.
https://github.com/metabase/metabase/issues/10525 - upvote by clicking on the first post