Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,916 questions
Data Disposal/Retirement in Azure Synapse
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 61%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAV%3C/text%3E%3C/svg%3E)
Akash Verma
26
Reputation points
Can someone please let me know how to achieve data disposal/retirement in Azure Synapse Analytics (SQL DW) and how to ensure it is happening safely in Azure.
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 9%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
KranthiPakala-MSFT 46,487 Reputation points Microsoft Employee2020-09-23T19:50:30.293+00:00 Hi @Akash Verma ,
Thanks for your query. Could you please elaborate a bit on "data disposal/retirement"? Do you mean TRUNCATE TABLE, archiving data to another data store, deleting databases, or maybe all of the above? Few additional clarification about your business requirement would help us to assist better.
Looking forward to your confirmation.
Thank you -
KranthiPakala-MSFT 46,487 Reputation points Microsoft Employee
2020-09-25T00:31:03.757+00:00 Hi @Akash Verma ,
Just checking to see if you have got a chance to see my previous comment? If so, could you please provide few additional details as requested in my previous comment?
Thank you
Sign in to comment
Sign in to answer