Apply fine-grained access and transformation on the SUPER data type in Amazon Redshift
Big Data Blog
This article discusses applying fine-grained access and transformation on the SUPER data type in Amazon Redshift, which stores semi-structured data like JSON documents.
Specifically, the article covers:
- Using dynamic data masking (DDM) policies to mask sensitive data in SUPER columns, like credit card numbers or PII, at a granular level
- Creating and attaching DDM policies to roles with different access levels to control data access based on privileges
- Using the OBJECT_TRANSFORM function to reshape and transform semi-structured data in SUPER columns
- A solution overview demonstrating these capabilities for a retail use case with different user roles
- Considerations and best practices for using DDM policies with SUPER data types
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
Aug 1
2024
2024
Unlock scalability, cost-efficiency, and faster insights with large-scale data migration to Amazon Redshift
Nov 18
2025
2025
Amazon Redshift announces support for the SUPER data type in Databases with Case-Insensitive Collation
Jan 27
2026
2026
Analyze JSON data efficiently with Amazon Redshift SUPER
May 16
2025
2025
Simplify enterprise data access using the Amazon Redshift integration with Amazon S3 Access Grants
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.