Synapse workspace deployment - V2.0*

Nagesh CL 621 Reputation points
2022-12-20T06:14:16.96+00:00

Hi Team,

As per the recent updates (V2.0*) for the "Synapse workspace deployment" task, synapse pipelines can be deployed from any branch (Instead of only the workspace_publish branch).

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

272342-image.png

Other branches won't have any parameter file, so not sure how the linked services parameterisation works. Can somebody help here with any POC of the synapse devops deployment with the latest V2.0* updates (Especially deploying pipelines from any ADO-GIT branch)?

Thanks

Regards,
Nagesh CL

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.
4,448 questions
0 comments No comments
{count} votes

Accepted answer
  1. BhargavaGunnam-MSFT 27,081 Reputation points Microsoft Employee
    2022-12-20T17:54:27.733+00:00

    Hello @Nagesh CL ,

    Welcome to the MS Q&A platform.

    Please correct me if my understanding is wrong. You want to know how the linked services parameterization works using the non-published branches(user branches).

    Validate and deploy can be used to directly deploy the workspace from non-publish branch with the artifact root folder.

    https://learn.microsoft.com/en-us/azure/synapse-analytics/cicd/continuous-integration-delivery#configure-the-deployment-task

    Here you need to select the artifacts root folder which has the ARM templates.

    Validate and Deploy Operation

    The goal of the Validate and Deploy operation is to deploy the artifacts to a target from any user branch (a non-publish branch). It does the job of the Validate operation (generating the ARM templates based on the specified branch) and adds this extra deploy step to deploy only the artifacts from that branch.

    This is a useful operation when you want to cherry pick the code that you want to deploy from your lower environment to your target environment, bypassing the manual Publish operation. Before V2, the deploy operation would only consider the ARM code published from the collaboration branch. In V2 the task can consider the code from any non-publish branch!

    For your question: how the linked services parameterization works

    You can override the template parameters in the overrideparameters section of the synapse deployment task. This is same as the V1 deployment.

    Please follow the below document explained about this validate and deploy option.

    https://techcommunity.microsoft.com/t5/azure-synapse-analytics-blog/automating-the-publishing-of-workspace-artifacts-in-synapse-cicd/ba-p/3603042

    272565-image.png

    272603-image.png

    I hope this helps. Please let me know if you have any further questions.

    ------------------------------

    • Please don't forget to click on 130616-image.png and upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

0 additional answers

Sort by: Most helpful