I have created a stored procedure when I run it manually: EXEC createSQLServerlessView_gold_SalesOrderDetail; inside develop-> SQL script it works fine. But When I do integration-> pipeline -> stored procedure and choose the same procedure and then run it, it gives…
I have a Azure Synapse pipeline which we migrated from DEV environment to our Pre Prod environment. When I execute it via the debug option, the pipeline executes fine. However if I trigger it via 'Trigger Now' or via setting…
In Azure Synapse Analytics, I would like to use the pipeline function to set a variable of type array for the date from 12 months ago to current date. The date in the variable is the first day of each…