I am having issues with a series of pipelines that build our data platform Spark databases hosted in Azure Synapse. The pipelines host dataflows which have 'recreate table' enabled. The dataflows extract data and are supposed to recreate the tables…
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…