Row-Level Security in QuickSight analysis

In the QuickSight analysis we can restrict the data access by applying row level security on the dataset. Based on the configuration we applied on the dataset, data can be filtered for the user.

We can do this row-level security only in the Enterprise edition of the QuickSight.

UseCase: We have store wise details in multiple countries to show in the analysis and country managers are there, so any manager logged in to QuickSight to see the data then analysis should not show data of another country

Follow the below steps to implement the row level security

1. We have store information in Store file and created dataset in QuickSight using this file. Below is the sample data
   
2. Create new analysis by using the dataset, analysis will show all countries data
3. To implement the row level security we should have another dataset, it should contain list of UserNames and a mapping column which will have relation with the above Store dataset
4. As we are going to apply row level security based on the country managers, so we are using country column in the data
5. Create new dataset in QuickSight by using the new UserDetails data file. Below is the sample data
   
6. Now we have both the datasets created in QuickSight
7. Go to the datasets, click on Store dataset
8. Click on Row level security button
   
9. Select the User-based rules option
10. Here we can see the list of datasets available in the QuickSight
11. Select the UserDetails dataset
12. Click on Apply dataset and activate the Row level security
13. Now we can see the small lock icon on the dataset which means we applied row level security
14. Go to analysis and check the data
15. We can see the data getting filtered out based on the logged In User country
16. Log in with different users and check the data in the analysis
17. To remove row level security, go to Row level security option and click on Remove dataset, Row level security will be removed

Reference: https://docs.aws.amazon.com/quicksight/latest/user/restrict-access-to-a-data-set-using-row-level-security.html

Thank You,
Ramu
Helical IT Solutions

Best Open Source Business Intelligence Software Helical Insight is Here

A Business Intelligence Framework

Free
Download