Azure Synapse Serverless pool activity

Jakeer Shaik 106 Reputation points
2022-10-26T11:43:59.283+00:00

Hi,

Due to some inactivity, built-in serverless pool goes inactive and comes to active when next activity happens. However, this gives us sql warming up error. MS documentation says, we need to apply the retry mechanism. Where should we use this retry policy?

we have a copy activity which takes data from serverless and moves it to onpremises. Should I set the retry policy at linked service connection string or copy activity retry policy?
I feel setting at copy activity won't work as it will retry irrespective of the error. And also, we tried setting at linked service, which also didn't work.

Is there a way to check the status of serverless pool status (like active, inactive) from synapse pipeline before the linked service connection establishment.

Thansk,
Jakeer. Shaik

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.
5,049 questions
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.