CICD Synapse SqlPoolStoredProcedure Activity sqlPool Reference

Arthur Steijn 51 Reputation points
2022-10-03T10:37:35.437+00:00

Hi,

Any help on how to CICD a SqlPoolStoredProcedure Activity? In the pipeline definition there is an object:

"sqlPool": {  
		"referenceName": "sqlPool",  
		"type": "SqlPoolReference"  
}  

But in the TemplateForWorkspace.json that get's created this object is not there anymore. See below comparison, left side is the created template, right side the pipeline definition:

246977-2022-10-03-12-34-47.png

This means that after deployment, manually the reference to the sqlPool has to be set!?

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.
4,497 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Siddharth Joshi 206 Reputation points
    2023-02-17T12:34:02.01+00:00

    Hi @Arthur Steijn

    I was facing same problem so to resolve this problem I did workaround by using file transform task first before synapse deployment task and transform "TemplateForWorkspace.Json" by overriding variables key like this "resources.4.properties.sqlPool.referenceName" so this will change sqlPool reference name and then we used synapse deployment task with deploy operation.

    0 comments No comments