Row Level Permissions

Creating a Virtual Dataset with Row Level Permissions

Using query_user() or is_member(), a virtual dataset can be setup to allow for selective filtering of rows for different users or groups without having to create multiple datasets.

Here is sample SQL for a virtual dataset with row-level filtering:

SELECT * 
FROM mongo.yelp.business 
WHERE 
    (state = 'NV' AND query_user() IN ('dave','mike')) 
    OR 
    (state = 'CA' AND is_member('Marketing'))

is_member() is case-insensitive. Alternatively, is_member(groupname, <case-sensitivity boolean>) can be used with the case-sensitivity flag set to true.