How to implement Retention Policies in Azure Synapse Analytics (Azure SQL Data Warehouse) ?

Question

Trying to understand how to implement Retention Policies in Azure Synapse Analytics (Azure SQL Data Warehouse).

There isn't enough supporting material on the steps to implement retention policies in Azure Synapse Analytics/ SQL Data Warehouse.

Does it even exist? OR restore-points and their retention period (Automatic- user defined), (7-35 days) is actually the only retention policy available for Azure SQL Data Warehouse ?

Please advise!

Answer 1

Hi @Neil Pereira ,

Welcome to Microsoft Q&A Platform.

Yes, Automatic restore points are available for seven days. This retention period cannot be changed. User-defined restore points are available for seven days and are automatically deleted on your behalf. You cannot change the retention period of user-defined restore points. More details can be found from this link.

There is an open item on the same, I would suggest you to vote up an idea submitted by another Azure customer from below link.

35114410-user-defined-retention-periods-for-restore-points

All of the feedback you share in these forums will be monitored and reviewed by the Microsoft engineering teams responsible for building Azure.

Hope this helps. Do let us know if you any further queries.

Do click on "Accept Answer" and Upvote on the post that helps you, this can be beneficial to other community members.