Resume Azure Data Base from Azure Factory pipeline

Manish Jain 31 Reputation points
2020-12-18T13:13:26.623+00:00

Hi,

I have an Azure data base which gets paused automatically after 1 hour. I am using this database as a dataset in my Azure data factory pipeline. I have a source inside a data flow which gets failed because my database is in paused state.
I do not want my pipeline to get failed due to this reason. Because, my database resume after first hit to this database.
Is there a way to perform this functionality in azure data factory or is there a way to get this error code information and i can resume my pipeline once database become running?

Thanks!

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,933 questions
0 comments No comments
{count} votes

Accepted answer
  1. PRADEEPCHEEKATLA-MSFT 83,301 Reputation points Microsoft Employee
    2020-12-21T06:50:10.757+00:00

    Hello @Manish Jain ,

    Welcome to the Microsoft Q&A platform.

    If you use Azure SQL Database serverless tier, note when the server is paused, activity run fails instead of waiting for the auto-resume to be ready. You can add activity retry or chain additional activities like wait to make sure the server is live upon the actual execution.

    49892-image.png

    For more information, see Azure Data Factory - Activity policy.

    Hope this helps. Do let us know if you any further queries.

    ------------

    • Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification.

0 additional answers

Sort by: Most helpful