Synapse Serverless pool database objects deployment

Question

Synapse Serverless pool database objects deployment

Madugundu Somashekara, Roopa 46

Hi Team,

I have a requirement to deploy Synapse serverless pool objects (Synapse external tables & views) to DTAP environments using Classic release pipeline integrated with Azure DevOps
How can this be achieved without using any SSDT tools like Visual Studio
Your help is appreciated!

Anonymous

2025-09-22T07:17:57.6766667+00:00

Hi @Madugundu Somashekara, Roopa

Thanks for reaching out to QA, we will review your question and get back to you solution.

Thanks,
Vrishabh
Smaran Thoomu 35,375 Reputation points Microsoft External Staff Moderator

2025-09-25T05:50:38.53+00:00

Madugundu Somashekara, Roopa Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

1 answer

Your answer

Anonymous

2025-09-22T07:17:57.6766667+00:00

Hi @Madugundu Somashekara, Roopa

Thanks for reaching out to QA, we will review your question and get back to you solution.

Thanks,
Vrishabh
Smaran Thoomu 35,375 Reputation points Microsoft External Staff Moderator

2025-09-25T05:50:38.53+00:00

Madugundu Somashekara, Roopa Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Answer 1

Smaran Thoomu 35,375 Microsoft External Staff Moderator

Hi Madugundu Somashekara, Roopa

You don’t need SSDT/Visual Studio for deploying Synapse Serverless objects (external tables, views) across DTAP environments. A common approach is to treat your SQL scripts as artifacts and use automation in Azure DevOps to deploy them.

Here are some options you can consider:

Option 1: Azure DevOps Pipelines with SQL Scripts

Store your CREATE/ALTER scripts for external tables and views in source control (Git).
Use a classic release pipeline task such as:
- Azure CLI (with az synapse sql commands)
- Invoke-Sqlcmd (PowerShell)
- Azure SQL Database Deployment Task (can run scripts against Synapse serverless pools).

Option 2: ARM/Bicep Templates (Infrastructure as Code)

Define external data sources, file formats, schemas, and views in ARM/Bicep templates.
Deploy them across environments using Azure DevOps release pipeline.

Option 3: Synapse Workspace Deployment via DevOps Integration

If you link Synapse Studio with a Git repo, you can create a publish branch that generates ARM templates.
These templates can then be deployed to your target environments from Azure DevOps pipelines.

This way, you can achieve repeatable deployments across DTAP without relying on SSDT.

Hope this helps. Do let us know if you any further queries.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Madugundu Somashekara, Roopa 46 Reputation points

2025-09-24T05:33:38.7766667+00:00

Thankyou!
Could you please elaborate more on each of the approaches?
Smaran Thoomu 35,375 Reputation points Microsoft External Staff Moderator

2025-09-24T10:26:49.2633333+00:00
Hi Madugundu Somashekara, Roopa
Thanks for your follow-up. Let me elaborate a bit more on the three approaches I mentioned:

Option 1: Azure DevOps Pipelines with SQL Scripts

Keep your CREATE/ALTER scripts for external tables and views in a Git repo.

In your release pipeline, add a task to execute these scripts against the serverless pool. Some common ways:

Azure CLI task → az synapse sql commands to run scripts.

PowerShell task → use Invoke-Sqlcmd to execute SQL files.

Azure SQL Database Deployment task → run .sql scripts directly against the Synapse serverless endpoint.

This is the most straightforward option if you already manage SQL scripts manually.

Option 2: ARM/Bicep Templates (Infrastructure as Code)

Model your external data sources, file formats, schemas, and views as ARM or Bicep resources.

Store these templates in source control.

Use the Azure Resource Group Deployment task in DevOps to deploy templates across environments.

This ensures your infra + objects are versioned, repeatable, and environment-agnostic.

Option 3: Synapse Workspace Deployment via Git Integration

Link your Synapse workspace to a Git repo.

All your definitions (SQL scripts, views, external tables) get committed automatically.

From Synapse Studio, when you publish, ARM templates are generated in a publish branch.

These templates can then be picked up by DevOps pipelines and deployed across DTAP environments.

This is a good option if you want Synapse Studio to be the “source of truth” and have CI/CD automation built in.

Hope this helps. Do let us know if you any further queries.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Share via

Synapse Serverless pool database objects deployment

1 answer

Your answer