Resume Azure Data Base from Azure Factory pipeline

Question

Resume Azure Data Base from Azure Factory pipeline

Manish Jain 31

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

PRADEEPCHEEKATLA-MSFT 56,301 Microsoft Employee

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.

Manish Jain 31 Reputation points

2020-12-21T06:55:06.537+00:00

Hello @PRADEEPCHEEKATLA-MSFT

Is this not a good idea to do a REST API call to resume azure database using Web activity instead of retry option?
PRADEEPCHEEKATLA-MSFT 56,301 Reputation points Microsoft Employee

2020-12-22T08:18:51.217+00:00

Hello @Manish Jain ,

Unfortunately, you cannot resume/pause Azure SQL Database using Web Activity.

If you try to repro it, you will receive this {"error":{"code":"FeatureDisabledOnSelectedEdition","message":"This feature is not available for the selected database's edition (chepra)."}}

.

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

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

Do click on "Accept Answer" and Upvote on the post that helps you, this can be beneficial to other community members.

Resume Azure Data Base from Azure Factory pipeline

0 additional answers

Activity