synapse_sql_pool - support for cross-subscription Synapse SQL DB restoration

[sitengyu-hc]

Is there an existing issue for this?

• I have searched the existing issues

Community Note

• Please vote on this issue by adding a 👍 reaction to the original issue to help the community and maintainers prioritize this request
• Please do not leave comments along the lines of "+1", "me too" or "any updates", they generate extra noise for issue followers and do not help prioritize the request
• If you are interested in working on this issue or have submitted a pull request, please leave a comment and review the contribution guide to help.

Description

I want to restore a Synapse SQL DB using Terraform AzureRM provider synapse_sql_pool resource in a cross-subscription: https://registry.terraform.io/providers/hashicorp/azurerm/latest/docs/resources/synapse_sql_pool

The functionality is available from Microsoft's side here: https://techcommunity.microsoft.com/t5/azure-synapse-analytics-blog/announcing-general-availability-of-cross-subscription-restore/ba-p/3280185

This is the official documentation from Microsoft on how to restore the DB using the UI/Powershell: https://learn.microsoft.com/en-us/azure/synapse-analytics/backuprestore/restore-sql-pool#restore-an-existing-dedicated-sql-pool-through-the-azure-portal

New or Affected Resource(s)/Data Source(s)

synapse_sql_pool

Potential Terraform Configuration

No response

References

No response