Share via

CI/CD deployment options for azure synpase pipelines

Raj D 591 Reputation points
2023-01-09T18:05:43.723+00:00

Greetings...

I'm pretty new to Azure Synapse and exploring different options for automated deployment of Synapse pipelines, linked services, datasets, triggers to different environments seamlessly using Azure DevOps.

Should I be using ARM templates or Azure Bicep to achieve this? Could you also please point me on how to get started on 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,150 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. AnnuKumari-MSFT 33,986 Reputation points Microsoft Employee
    2023-01-10T09:36:21.537+00:00

    Hi @Raj D ,

    Thankyou for using Microsoft Q&A platform and thanks for posting your question here.

    As I understand your issue, you want to know the steps to be followed to perform the deployment in Synapse .

    • You can use either Azure Resource Manager (ARM) templates or Azure Bicep to automate the deployment of Synapse pipelines, linked services, datasets, and triggers to different environments using Azure DevOps. Both options offer a way to declaratively define your resources and deploy them to Azure.
    • ARM templates are JSON files that define the resources that you want to create or update in Azure. They have been around for a while, and have a lot of resources available such as documentation and examples.
    • Azure Bicep is a newer language, it is a simpler and more streamlined option for authoring ARM templates. It is designed to be more user-friendly, more readable, and more concise than ARM templates.

    Kindly check the below blogposts that can guide you through end to end steps on how to perform the deployment from one Synapse environment to another.

    CI CD in Azure Synapse Analytics Part 1 CI CD in Azure Synapse Analytics Part 2 CI CD in Azure Synapse Analytics Part 3 CI CD in Azure Synapse Analytics Part 4 - The Release Pipeline

    Hope this will help. Please let us know if any further queries.

    • Please don't forget to click on 130616-image.png or 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

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.