Home icon

Automate replication of row-level security from AWS Lake Formation to Amazon QuickSight

Big Data Blog



This article provides a comprehensive guide to automating row-level security (RLS) replication from AWS Lake Formation to Amazon QuickSight. The solution enables organizations to maintain consistent data access controls across their data ecosystem.

  • Developed a Lambda function to extract and transform data filters from AWS Lake Formation
  • Creates a rules dataset in Amazon QuickSight that mirrors Lake Formation permissions
  • Supports both direct query and SPICE datasets in QuickSight
  • Works with group-level and user-level row-level security
  • Allows dynamic updating of data access rules across different user groups

Key technical components include using AWS Lake Formation APIs to list data cell filters and permissions, transforming these into a QuickSight-compatible format, and storing the transformed rules in Amazon S3 for further processing.



Go to article

The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.

Related articles

Jun 16
2025
Implement row-level security in Amazon Aurora MySQL and Amazon RDS for MySQL
Sep 16
2024
Create security observability using generative AI with Security Lake and Amazon Q in QuickSight
May 16
2024
Centrally manage permissions for tables and views accessed from Amazon QuickSight with trusted identity propagation
Sep 26
2024
Apply enterprise data governance and management using AWS Lake Formation and AWS IAM Identity Center

The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.