admin管理员组

文章数量:1335430

Is there a way to pause and resume Azure Synapse Link via automation using Windows PowerShell or other technology?

I am trying to reduce the cost of running Synapse 24/7. Presently I have Aruze Synapse Link importing new and changed records from multiple Azure databases into a dedicated SQL database. I have figured out how to pause and resume the dedicated SQL database using Windows PowerShell. The Aruze Synapse Link continues to run even when the dedicated SQL database is paused. I need to figure out away to pause and resume Azure Synapse Link via automation using Windows PowerShell or some other technology or method.

I can only pause and resume the Synapses Link manually.

Is there a way to pause and resume Azure Synapse Link via automation using Windows PowerShell or other technology?

I am trying to reduce the cost of running Synapse 24/7. Presently I have Aruze Synapse Link importing new and changed records from multiple Azure databases into a dedicated SQL database. I have figured out how to pause and resume the dedicated SQL database using Windows PowerShell. The Aruze Synapse Link continues to run even when the dedicated SQL database is paused. I need to figure out away to pause and resume Azure Synapse Link via automation using Windows PowerShell or some other technology or method.

I can only pause and resume the Synapses Link manually.

  • powershell
  • azure-synapse
Share Improve this question asked Nov 20, 2024 at 17:20 user28399164user28399164 1
Add a comment  | 

1 Answer 1

Reset to default 0

You can use Start-AzSynapseLinkConnection PowerShell command to start the Synapse connection link.

After creating the synapse link connection, I have followed the same code from the documentation and here is a sample demo.

Start-AzSynapseLinkConnection -WorkspaceName "rakeshsynapse2" -Name "linkconnection1"

You can get start and get the status of the link connection using the below command.

Get-AzSynapseLinkConnectionDetailedStatus -WorkspaceName "rakeshsynapse2" -Name "linkconnection1"

You can see that the linkconnection was started.

Result:

Linkconnection in Synapse:

Similarly, you can use Stop-AzSynapseLinkConnection PowerShell command to pause the link connection in the synapse.

本文标签： powershellHow to pause and resume Azure Synapse Link via automationStack Overflow

版权声明：本文标题：powershell - How to pause and resume Azure Synapse Link via automation? - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1742341616a2456716.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。