Row Level Security with multiple value in Quicksight

Question & Answer
,
1

Is it possible to implement the Row level security for the below mentioned case in quicksight ?

Example

Suppose you have the following data:

Main dataset

Divisions Sales
1234,1245 100
1234 200
1245 300

User dataset

Username Division
abc 1234
def 1245
ghi 1234

When the user “abc” logs in, the filter will be applied, and only rows that contain the division ID “1234” will be displayed, including the row with multiple division IDs (“1234,1245”). The resulting data will be:

Divisions Sales
1234,1245 100
1234
2

Hi @achourey,
Logistically, yes this type of setup should work for your RLS. I’ve included some additional documentation below on RLS for you to further explore as well as a couple videos that can assist in the setup process.

Let us know if you have any additional questions.