Block the access of several tables or columns with using native querying

Hello,

I have connected my postgre database on Metabase. I want to give the access to a friend (simple user) to my dashboards & collections.

I have sensitive data in several columns. I want to hide this data by column. Is it possible ?

And another question, can he edit my SQL queries on the dashboards ?

If not, can I make this example possible with another pricing ?

To summarise, I want to give him the access to almost everything but not to the sensitive columns in the tables.

Thanks

Hi @Zikki
That's possible with Sandboxing: https://www.metabase.com/docs/latest/enterprise-guide/data-sandboxes.html
Otherwise you would need to create a Postgres user which had restricted privileges (and possible also need to create some Views) and then you would add that database connection to Metabase.

But no, Metabase cannot parse SQL currently:
https://github.com/metabase/metabase/issues/10525 - upvote by clicking :+1: on the first post

1 Like