Use metabase meta-data to filters

Get Help
1

Hi,

I found in Metabase documentation, that I can use logged user identifiers in SQL filters ex. user_id parameter. So, is really possible to filter my data by currently logged user email or surname information?

2

Hi @pkasperek
Yes, it's available via Sandboxing:
https://www.metabase.com/docs/latest/enterprise-guide/data-sandboxes.html

3

Thank you @flamber. But, my problem is a little different. I use CitusDB (compatible with PostgreSQL). The database supports Row Level Security (https://docs.citusdata.com/en/v11.0-beta/admin_guide/cluster_management.html#row-level-security). I can be given access by value in a row. How I can use it to filter data (access)? Maybe the Metabase supports parameterized connection by a logged user?

4

@pkasperek That is currently not supported. You would have to create separate databases per user.
https://github.com/metabase/metabase/issues/5147 - upvote by clicking :+1: on the first post

5

Thank you @flamber