How to pause or resume Azure Synapse SQL with Azure Data Factory and Logic App

Today's video we will discuss how to use Azure Logic App (with ADF) to pause or resume Synapse SQL pool compute.

0:00 Introduction
1:50 Pre-requisites for the demo
4:15 Demo
17:23 Closing

ADF webhook body value:
@json(concat('{"Action":"', pipeline().parameters.Action, '"}'))

Useful links:

[PhongTran-ufvb]

Thank you Riz Ang for such a very informative video. It worked like a charm. Keep up the good work !
I made a small change with the logical app, when the Synapse is Paused and the Action is Pause again, the pipeline will fail, I put another Get DW State and a Condition there to get it sorted

[pavithrabadam]

Thanks a lot Riz for this beautiful Approach.

Can someone still query the data in Dev to at least look at results from the ADF jobs. If Synapse is not running is the table available. How would someone review what their ADF job just did if they could not query the data.

Can you please help me with the above query.