Pattern matching in quicksight dataset

Hi All!!..I am trying to use pattern matching in quicksight dataset using row level security . For example,i have a country dataset. I want my user to have access to those countries which starts with the letter “L”. Is that type of pattern matching possible in quicksight rls?

Hi @rhijit - I do not think QuickSight support pattern matching, however you can put all countries in the same column with comma separated. See the below documentation for details.

Hi @Max @David_Wong - Any feedback from you on this.

Regards - Sanjeeb

1 Like

I think you’ll have to create a calculated field in your dataset to get the first letter from the country name and put that same field in your RLS rules.

2 Likes