Resume Azure Data Base from Azure Factory pipeline

Question

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!

Answer 1

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.

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.