Dynamic Data Masking on S3 data with Redshift Spectrum


Is it currently possible to perform dynamic data masking on data stored in Amazon S3 buckets when querying using Redshift Spectrum?

I understand, based on the documentation- https://docs.aws.amazon.com/redshift/latest/dg/t_ddm.html, that masking policies cannot be created on views, external tables, and materialized views at this time. However, I am interested in achieving dynamic data masking on s3 data at query time using policies defined within Redshift with Redshift Spectrum.

Are there any alternative approaches to achieve a similar level of data protection for S3 data accessed through Redshift Spectrum?

Also, In Redshift, dynamic data masking policies are typically associated with users and roles created within the Redshift editor. Can we leverage real-world users and roles (e.g., users authenticated via AWS IAM) and attach/create masking policies accordingly? If yes, how to do it?

1 Answer
profile picture
answered a month ago
  • Right, but my question is can we perform dynamic data masking on s3 data with Redshift Spectrum??

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions