How could I build a simple CI/CD for a pipeline

Question

Hallo all,

I have an existing CI/CD pipelines and release in my Azure DevOps, and I create a new pipeline in the azure synapse workspace, and i want to do the CI/CD for this new pipeline in Azure DevOps. Could anyone tell me how to do it? Here is my thoughts:

1. set up a yml file for stages and jobs and steps for the new pipeline in DevOps.
2. write a azure powershell script for lauching the pipeline in azure synapse workspace.
3. create a new release

I am confused about the first and the second steps.

Many thanks in advance,

Joan

Answer 1

Hello ,

I have found this link for you : https://purple.telstra.com/blog/how-to-setup-ci-cd-for-synapse-analytics-on-azure-devops

If the reply is helpful, please click Accept Answer and kindly upvote it. If you have additional questions about this answer, please click Comment.

Answer 2

Hi Joan,

Not sure, what you need to include in the Azure DevOps Pipeline. But following getting started guide will help you to get started with Azure DevOps YAML pipeline.

Simple YAML CI/CD

For the second point, Yes you can create a PowerShell script, and from CI/CD pipeline, you can run the script. This can be done via a PowerShell task in the YAML pipeline

PowerShell@2 - PowerShell v2 task

For the last point you can use Azure DevOps environment to designate different stages of your CI/CD such as Dev, Staging, Production.

Azure DevOps Environments

Hope this will help for you. If this helpful and answer the question mark them as answered

Answer 3

Follow https://techcommunity.microsoft.com/t5/data-architecture-blog/ci-cd-in-azure-synapse-analytics-part-4-the-release-pipeline/ba-p/2034434

---

If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

hth

Marcin