Drop synapse artifacts before deployment from Azure DevOps

Raj D 616 Reputation points
2023-05-08T23:13:43.0133333+00:00

Greetings!!!

We have published few synapse artifacts long back to one of our workspaces and since the business requirements have changed and those artifacts are now obsolete. We have now developed new pipelines, triggers, linked services, datasets, notebooks per the latest requirement. Now, we would like to repurpose this synapse workspace for this project and we do not want to manually go in and delete each artifact instead have it automated. The publish of artifacts happens in the yaml file using the Azure DevOps CICD pipeline, and prior to the publish we would like to add the step to drop existing artifacts.

yaml:

            - task: Synapse workspace deployment@2
              inputs:
                azureSubscription: '$(Subscription)'
                ResourceGroupName: '$(ResourceGroupName)'
                TargetWorkspaceName: '$(WorkspaceName)'
				ArtifactsFolder: '$(ArtifactsFolder)'

Could you please guide me on how best to accomplish this?

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.
5,373 questions
{count} votes

Accepted answer
  1. KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator
    2023-05-09T22:22:16.11+00:00

    Hi @Raj D ,

    Thanks for using Microsoft Q&A forum and posting your query.

    When configuring the Synapse Workspace Deployment task, make sure you select the Delete Artifacts not in template option, and any artifact in the target workspace that does not belong to the ARM template generate from the source, will be automatically deleted.

    User's image

    Hope this helps.


    Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful

Your answer

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