Skip to main content

Community

Destination Improvement: Ability to delete data from Managed Data Lake Destinations

Planned

Please sign in to leave a comment.

Comments

2 comments

  • Official comment

    Hi Anthony, 
    This is a feature we are currently working through. 
    For clarity, are you looking for the ability to delete individual records and tables? 
    What would be the ideal way for you to execute these commands against the Polaris Catalog?

    -Casey

    Thanks a lot Casey!

    In fact, there are potentially two different use cases :

    - Historical data deletion, for example everyday remove data older than 5 years ago for table X

    - Individual row deletion or anonymization from "Right to be forgotten" request UPDATE user_email  as XXX FROM users.

    To be honest I have not deeply thought about the best way to achieve this so I'm totally opened but I would say the best is to let our query engine (Snowflake, Athena or whatever else) execute such command because it needs to be automated in some way!