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
Jun 25
2024
2024
Access Amazon Redshift data from Salesforce Data Cloud with Zero Copy Data Federation
Nov 18
2025
2025
Amazon Redshift announces support for the SUPER data type in Databases with Case-Insensitive Collation
Jun 18
2024
2024
Amazon Redshift announces support for VARBYTE 16MB data type
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.