{"id":1100,"date":"2021-02-10T20:59:10","date_gmt":"2021-02-10T20:59:10","guid":{"rendered":"http:\/\/jackofalltradesmasterofsome.com\/blog\/?p=1100"},"modified":"2021-02-16T14:54:32","modified_gmt":"2021-02-16T14:54:32","slug":"automatically-pausing-and-resuming-azure-workspace-synapse-pool-using-azure-data-factory","status":"publish","type":"post","link":"https:\/\/jackofalltradesmasterofsome.com\/blog\/2021\/02\/10\/automatically-pausing-and-resuming-azure-workspace-synapse-pool-using-azure-data-factory\/","title":{"rendered":"Automatically pausing and resuming Azure Workspace Synapse Pool Using Azure Data Factory"},"content":{"rendered":"\n<p>Automatically pausing and resuming Azure Workspace Synapse Pool Using Azure Data Factory.<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Create a new Azure Data Factory Pipeline <\/li><li>Add the Web Task and name it \u201cPauseDW\u201d<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"432\" height=\"178\" src=\"http:\/\/jackofalltradesmasterofsome.com\/blog\/wp-content\/uploads\/2021\/02\/image-11.png\" alt=\"\" class=\"wp-image-1122\" srcset=\"https:\/\/jackofalltradesmasterofsome.com\/blog\/wp-content\/uploads\/2021\/02\/image-11.png 432w, https:\/\/jackofalltradesmasterofsome.com\/blog\/wp-content\/uploads\/2021\/02\/image-11-300x124.png 300w\" sizes=\"auto, (max-width: 432px) 100vw, 432px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>In the settings, follow the following steps.<ul><li>copy the following command.  MOre on this command can be found <a href=\"https:\/\/docs.microsoft.com\/en-us\/rest\/api\/synapse\/sqlpools\/resume\">here<\/a>.<ul><li><a href=\"https:\/\/management.azure.com\/subscriptions\/%7bsubscriptionId%7d\/resourceGroups\/%7bresourceGroupName%7d\/providers\/Microsoft.Synapse\/workspaces\/%7bworkspaceName%7d\/sqlPools\/%7bsqlPoolName%7d\/resume?api-version=2019-06-01-preview\">https:\/\/management.azure.com\/subscriptions\/{subscriptionId}\/resourceGroups\/{resourceGroupName}\/providers\/Microsoft.Synapse\/workspaces\/{workspaceName}\/sqlPools\/{sqlPoolName}\/resume?api-version=2019-06-01-preview<\/a><\/li><\/ul><ul><li>Most of this information can be found in your Synapse main workspace page<\/li><\/ul><\/li><\/ul><\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"623\" height=\"149\" src=\"http:\/\/jackofalltradesmasterofsome.com\/blog\/wp-content\/uploads\/2021\/02\/image-12.png\" alt=\"\" class=\"wp-image-1123\" srcset=\"https:\/\/jackofalltradesmasterofsome.com\/blog\/wp-content\/uploads\/2021\/02\/image-12.png 623w, https:\/\/jackofalltradesmasterofsome.com\/blog\/wp-content\/uploads\/2021\/02\/image-12-300x72.png 300w\" sizes=\"auto, (max-width: 623px) 100vw, 623px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Set the setting to \u201cPOST\u201d<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"388\" height=\"243\" src=\"http:\/\/jackofalltradesmasterofsome.com\/blog\/wp-content\/uploads\/2021\/02\/image-13.png\" alt=\"\" class=\"wp-image-1124\" srcset=\"https:\/\/jackofalltradesmasterofsome.com\/blog\/wp-content\/uploads\/2021\/02\/image-13.png 388w, https:\/\/jackofalltradesmasterofsome.com\/blog\/wp-content\/uploads\/2021\/02\/image-13-300x188.png 300w\" sizes=\"auto, (max-width: 388px) 100vw, 388px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>In the advanced section, set the method to \u201cMSI\u201d and the resource to \u201chttps:\/\/management.core.windows.net\u201d<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"520\" height=\"94\" src=\"http:\/\/jackofalltradesmasterofsome.com\/blog\/wp-content\/uploads\/2021\/02\/image-14.png\" alt=\"\" class=\"wp-image-1125\" srcset=\"https:\/\/jackofalltradesmasterofsome.com\/blog\/wp-content\/uploads\/2021\/02\/image-14.png 520w, https:\/\/jackofalltradesmasterofsome.com\/blog\/wp-content\/uploads\/2021\/02\/image-14-300x54.png 300w\" sizes=\"auto, (max-width: 520px) 100vw, 520px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>In your IAM Security for your workspace add the contributor role for your data factory.<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"623\" height=\"234\" src=\"http:\/\/jackofalltradesmasterofsome.com\/blog\/wp-content\/uploads\/2021\/02\/image-15.png\" alt=\"\" class=\"wp-image-1126\" srcset=\"https:\/\/jackofalltradesmasterofsome.com\/blog\/wp-content\/uploads\/2021\/02\/image-15.png 623w, https:\/\/jackofalltradesmasterofsome.com\/blog\/wp-content\/uploads\/2021\/02\/image-15-300x113.png 300w\" sizes=\"auto, (max-width: 623px) 100vw, 623px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Debug your pipeline and your service should now pause. Update the API call to the replace the word \u201cpause\u201d with \u201cresume\u201d to have it work the other way around. <\/li><li>Add these steps to triggers at specific times a day to run to turn your resources on and off.<\/li><\/ul>\n\n\n\n<p>Automatically pausing and resuming Azure Workspace Synapse Pool Using Azure Data Factory.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Automatically pausing and resuming Azure Workspace Synapse Pool Using Azure Data Factory. Create a new Azure Data Factory Pipeline Add the Web Task and name it \u201cPauseDW\u201d In the settings, follow the following steps. copy the following command. MOre on this command can be found here. https:\/\/management.azure.com\/subscriptions\/{subscriptionId}\/resourceGroups\/{resourceGroupName}\/providers\/Microsoft.Synapse\/workspaces\/{workspaceName}\/sqlPools\/{sqlPoolName}\/resume?api-version=2019-06-01-preview Most of this information can be found in [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1148,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,28,27,11,1],"tags":[],"class_list":["post-1100","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-analytics","category-azure","category-big-data","category-data-warehouse","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/jackofalltradesmasterofsome.com\/blog\/wp-json\/wp\/v2\/posts\/1100","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jackofalltradesmasterofsome.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jackofalltradesmasterofsome.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jackofalltradesmasterofsome.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jackofalltradesmasterofsome.com\/blog\/wp-json\/wp\/v2\/comments?post=1100"}],"version-history":[{"count":1,"href":"https:\/\/jackofalltradesmasterofsome.com\/blog\/wp-json\/wp\/v2\/posts\/1100\/revisions"}],"predecessor-version":[{"id":1127,"href":"https:\/\/jackofalltradesmasterofsome.com\/blog\/wp-json\/wp\/v2\/posts\/1100\/revisions\/1127"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/jackofalltradesmasterofsome.com\/blog\/wp-json\/wp\/v2\/media\/1148"}],"wp:attachment":[{"href":"https:\/\/jackofalltradesmasterofsome.com\/blog\/wp-json\/wp\/v2\/media?parent=1100"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jackofalltradesmasterofsome.com\/blog\/wp-json\/wp\/v2\/categories?post=1100"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jackofalltradesmasterofsome.com\/blog\/wp-json\/wp\/v2\/tags?post=1100"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}