Share via

synapse workspace workspace objects

arkiboys 9,706 Reputation points
2021-08-13T07:56:29.553+00:00

Hello,
I have created a number of synapse pipelines, blob storage, sql pools, etc. in my synapse workspace.
I am using Devops repository...
Is there a possibility that if say one of the objects (i.e. blob storage folder) is changed, then can I run a saved script to restore to the original state?
Thank you

Azure Synapse Analytics
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.
Answer accepted by question author
  1. MartinJaffer-MSFT 26,161 Reputation points
    2021-08-17T23:30:08.937+00:00

    Do you mean files like this view (picture)

    124009-image.png

    Those are not managed by Synapse. you will have to go to the storage account and enable soft-delete or versioning.

    However what is managed by Synapse is the Linked Service telling Synapse how to connect to that storage account.

    To enable safety for your storage, go to the account and see "Data Protection"

    124085-data-protection.jpg

    Does this answer your question @arkiboys ?

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.