Synapse Workspace Deployment

Azure Synapse Analytics

Azure Synapse is an integrated analytics service that accelerates time to insight across data warehouses and big data systems. Azure Synapse brings together the best of SQL technologies used in enterprise data warehousing, Spark technologies used for big data, Pipelines for data integration and ETL/ELT, and deep integration with other Azure services such as Power BI, CosmosDB, and AzureML.

Synapse Workspace Deployment

Designed for synapse workspace artifacts deployment. You can use this extension to continuous delivery your synapse artifacts from one workspace to another.

Getting started

Step1: Search and get the extension from Azure DevOps marketplace if you have installed the extension before, uninstall it first.

Step 2: Make sure Azure DevOps pipeline’s service principal has been granted the permission of subscription and also assigned as workspace admin for target workspace.

Step 3. Create a new task in the release pipeline stage. Search for Synapse workspace deployment, and then select Add.

Step 4: In the task, select next to the Template box to choose the template file.

Step 5: Select next to the Template parameters box to choose the parameters file.

Step 6: Select the connection, resource group, and name of the target workspace.

Step 7: Select next to the Override template parameters box, and enter the desired parameter values for the target workspace.

Documentation and Help

Full documentation available on synapse workspace continuous deployment.
To learn more about how to use extension, you can view the [15-minute tutorial video].

Release notes/ roadmap

• 0.1.0 - 11/25/2020 :
  • Initial release
• 0.1.1 - 12/11/2020 :
  • Integration with artifacts pipeline
• 1.2.0 - 2/25/2021 :
  • Support for the artifacts dependency
  • Support for parallel deployment
• 1.3.0 - 3/23/2021
  • Arm overrides now also support yml style overrides
  • Bug fixes
• 1.4.0 - 5/11/2021
  • Delete artifacts not in the template
  • Concat multiple strings in variables
  • Minor improvements and bug fixes
• 1.5.0 - 5/14/2021
  • Added license for the extension
• 1.6.0 -
  • Bug fix for supporting JSON in parameters
  • Security fix to reduce the overall permissions needed by the extension

Feature requests

We love to hear from you. Is there a feature you’ve been waiting for?

Send us a Feature Request in synapse feedback forums, please do start your idea with [CD-Task] for help us filtering your requests.
Join and be a member of Synapse workspace deployment community to help us shape the product : Join the community
Raise an issue by sending an email to: Synapse-CICD@service.microsoft.com

What is (not) supported

• Resources, like pools management and workspace itself, the deployment is out of the scope, you can use Azure Resource Manager (ARM) to deploy pools and workspace.
• Incremental deployment