Stored Proc Activity/Connectivity

[asifsyed]

From data pipeline, we are calling stored procedure via stored procedure activity.

In Settings of Stored Procedure, we have Connection which points to the warehouse name in a specific workspace.

Now the workspace name changes for each env.

i.e. say

Warehouse_SP (WorspaceA) -> dev

Warehouse_SP (WorspaceB) -> uat

The deployment pipeline does not have rules for pipeline. How do we handle this change while deploying to other workspace/env.

[v-nmadadi-msft · Accepted solution]

Hi @asifsyed  ,
Thanks for reaching out to the Microsoft fabric community forum.

It is not possible to set the data pipelines parameters with the deployment pipelines yet. As a workaround, you could set a variable in the data pipeline passing workspace name as the parameter, where you look at the workspace id/name and set the value of the variable based on the value of the workspace id/name.

If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS.
Thanks and Regards

[v-nmadadi-msft]

Hi @asifsyed,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-nmadadi-msft]

Hi @asifsyed 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If our response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-nmadadi-msft]

Hi @asifsyed ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the community members for the issue worked. If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Thanks and regards