Hi there, my company is considering Metabase Enterprise edition, but not sure if row-level sandboxing will fit our needs.
As far as I know, typically you compare an user attribute against a column to filter rows out. But we have a more complex set of permissions. I can write an SQL to return the primary keys of the rows a given user has access to. Or write an SQL to return the user ids that can access a given row.
But I am not sure how this can help with row checking, if the check only sees if a certain column is EQUAL to certain attributes - it seems a bit simplistic.
Any tips or ideas here?