Row-Level Security in QuickSight analysis

Posted on by By admin, in Business Intelligence, Data Processing, Data Visualization, Helical Insight | 0

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

Make data easy with Helical Insight.
Helical Insight is the world’s best open source business intelligence tool.

Claim Your 30 Days Free Trail

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

logo

Best Open Source Business Intelligence Software Helical Insight is Here

logo

A Business Intelligence Framework

0 0 votes
Article Rating
Subscribe
Notify of
0 Comments
Inline Feedbacks
View all comments