Delete Artifacts Not In template

Question

Delete Artifacts Not In template

Roopa-2237 0

Hi Team,

I have a requirement where there are some obsolete objects (unwanted pipeline in Azure Synapse Analytics Workspace). We do not need them on higher environments anymore, so, they have been deleted on DEV environment and are not shown in the ARM templates generated.
We are using classic release pipelines to do the Synapse deployment. We have checked in the option "Delete artifacts not in template" present for the classic release pipeline in Synapse Deployment task. Even then somehow those objects are still up on higher environments (ACC, PRD).
As a workaround, we are manually deleting them.

Is there any alternative solution for this to completely avoid the manual intervention?

Any help is appreciated.
Thanks in advance!

Vinodh247 34,661 Reputation points MVP Volunteer Moderator

2024-03-26T06:52:40.3333333+00:00

Hi Roopa

Please 'Upvote'(Thumbs-up) and 'Accept' as an answer if the reply was helpful. This will benefit other community members who face the same issue.

1 answer

Your answer

Vinodh247 34,661 Reputation points MVP Volunteer Moderator

2024-03-26T06:52:40.3333333+00:00

Hi Roopa

Please 'Upvote'(Thumbs-up) and 'Accept' as an answer if the reply was helpful. This will benefit other community members who face the same issue.

Answer 1

Vinodh247 34,661 MVP Volunteer Moderator

Hi Roopa,

Thanks for reaching out to Microsoft Q&A.

did you try from 'Synapse workspace deployment' from marketplace?

https://marketplace.visualstudio.com/items?itemName=AzureSynapseWorkspace.synapsecicd-deploy

User's image

Would suggest you to go through this as well...

https://learn.microsoft.com/en-us/azure/synapse-analytics/cicd/continuous-integration-delivery

Please 'Upvote'(Thumbs-up) and 'Accept' as an answer if the reply was helpful. This will benefit other community members who face the same issue.

Roopa-2237 0 Reputation points

2024-03-21T09:59:31.49+00:00

Hi,

Yes, we used 'Synapse workspace deployment' from the marketplace and configured our release pipeline as per the instructions given in the Microsoft link (the second link that you shared).
Vinodh247 34,661 Reputation points MVP Volunteer Moderator

2024-03-21T14:20:50.7933333+00:00
did you ensure you have proper permissions to the login that is being used for the deployment?

it is worth checking the following points to narrow down the issue.

Check if there are any differences between the artifacts defined in your template and those present in your Synapse environment. Even a small difference, such as a change in casing or a missing object, can cause the deletion process to fail.

If there are dependencies between artifacts that need to be resolved before deletion (e.g., if an object is referenced by another object), the deletion process might fail. Make sure all dependencies are properly managed.

Review the logs and error messages generated during the release deployment process. This can provide valuable insights into why the deletion process failed and help identify any specific issues that need to be addressed.

Ensure that no manual changes are being made to the artifacts in the Synapse workspace after deployment. Manually modified objects may not be recognized by the deletion process and could remain in the environment.
Vinodh247 34,661 Reputation points MVP Volunteer Moderator

2024-03-23T10:30:37.93+00:00

Roopa: Just checking if you had a chance to look at this. if so, can you please update it?
Roopa-2237 0 Reputation points

2024-03-26T06:57:15.4966667+00:00

Thanks for the suggestion! We shall try to check the same.
Vinodh247 34,661 Reputation points MVP Volunteer Moderator

2024-04-01T06:35:11.3166667+00:00

Just checking if you had a chance to look at this. if so, can you please update it? Please accept as answer and upvote if this answers your query.

Share via

Delete Artifacts Not In template

1 answer

Your answer