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.
Synapse Execute Pipeline Dynamic parameter Issue during Trigger Mode , but works in Debug mode
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 33%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
satish krishnamurthy
1
Reputation point
Following fails in Trigger mode but same works in Debug mode
Execute pipeline parameters default value is not evaluating/expanding during execution in trigger mode
Azure Synapse Analytics
{count} votes
-
satish krishnamurthy 1 Reputation point
2022-10-15T20:34:33.183+00:00 Following works in Trigger mode provided we copy the default values again in actual parameter value , but why Debug mode can evaluate the dynamic parameter expression of default value but not the trigger mode dont understand
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 12%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
Subashri Vasudevan 11,306 Reputation points Volunteer Moderator2022-10-16T12:20:44.753+00:00 Hi
Did you publish the pipeline after you have added the parameters and try?
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 9%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
KranthiPakala-MSFT 46,737 Reputation points Microsoft Employee Moderator2022-10-31T20:55:55.773+00:00 Hello @satish krishnamurthy ,
Thanks for the question and using MS Q&A platform.
I was able to reproduce the behavior you have reported, and it has been escalated to respective product team to get more information/clarification regarding the same. Will keep you posted as soon as we hear back from the team.Thank you.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(185.6, 57.00000000000001%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBB%3C/text%3E%3C/svg%3E)
Bagley, Brian 0 Reputation points2023-11-29T15:04:11.74+00:00 We have run into this same issue. Was there a fix issued for this? If so, should we put in a ticket to get this reviewed again>
Sign in to comment
Sign in to answer