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.

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 - 6/23/2021
  • Bug fix for supporting JSON in parameters
  • Security fix to reduce the overall permissions needed by the extension
• 1.7.0 - 7/15/2021
  • Bug fix for supporting workspacename in overrides
• 1.8.0 - 8/24/2021
  • Bug fix for json parsing issue.
  • Further reduced the permissions needed by the extension
  • Removed deploy of Workspace System Identity object.
• 1.9.0 - 11/09/2021
  • Added support for managed identity to authenticate.
  • Supports managed private endpoint artifact deployment.
  • Supports Synapse lake database artifacts.
  • Minor Bug fixes and better error logging.
• 1.9.1 - 11/10/2021
  • Fix bug where SQL database deletion was failing.
• 1.9.2 - 11/10/2021
  • Bug fix: Skip managed private endpoints.
• 1.9.3 - 11/18/2021
  • Minor bug fixed for MSI authentication.
• 2.0.0-Preview - 01/11/2022
  • Toggle triggers support.
  • Supports managed private endpoint artifact deployment.
• 2.0.2 - 01/28/2022
  • Minor bug fixes and improvements.
• 2.0.3 - 3/30/2022
  • Support updating of lake databases.
  • Bug fixes and improvements in lake database deployments.
• 2.1 - 6/23/2022
  • Added support for deployment from any branch.
  • For deleteArtifactsNotInTemplate, the task will first deploy and then delete artifacts.
• 2.2 - 8/10/2022
  • Added support for spark configurations.
• 2.3 - 9/2/2022
  • 2.* task version is now GA.

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

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