fix import a connected synapse workspace

[ms-henglu]

A synapse workspace can be created from a dedicated SQL pool(formly SQL DW). And it can not perform GET aad admin/ sql aad admin operations.

To address: #9845

Fixes #9845

[katbyte]

There are a number of failing tests, could we please fix them up?

[ms-henglu]

Hi @katbyte , I've fixed the failed tests in synapse workspace, and I saw there're more in synapse rp, I think I'll raise another PR to fix them, because they're not related with this one.

[katbyte]

@ms-henglu - we can remove all and eny 3.0 flag blocks now. it seems you've made the tests

[](https://ci-oss.hashicorp.engineering/viewLog.html?buildId=270799&buildTypeId=TerraformOpenSource_TerraformProviders_AzureRMPublic_AZURERM_SERVICE_PUBLIC_SYNAPSE#)------- Stdout: -------
=== RUN   TestAccSynapseWorkspaceSecurityAlertPolicy_update
=== PAUSE TestAccSynapseWorkspaceSecurityAlertPolicy_update
=== CONT  TestAccSynapseWorkspaceSecurityAlertPolicy_update
    testcase.go:110: Step 1/4 error: Error running pre-apply refresh: exit status 1
        
        Error: Insufficient identity blocks
        
          on terraform_plugin_test.tf line 26, in resource "azurerm_synapse_workspace" "test":
          26: resource "azurerm_synapse_workspace" "test" {
        
        At least 1 "identity" blocks are required.
--- FAIL: TestAccSynapseWorkspaceSecurityAlertPolicy_update (17.23s)
FAIL

[ms-henglu]

Hi @katbyte , the failed tests are not introduced by this PR, so I opened another PR to fix the failed synapse testcases.
#15899

[tombuildsstuff]

hi @ms-henglu

Thanks for pushing those changes, I've left a couple of suggestions inline which I hope you don't mind but I'm going to push a commit to fix - but this otherwise LGTM 👍

Thanks!

dismissing since changes have been pushed

[github-actions]

This functionality has been released in v3.0.0 of the Terraform Provider. Please see the Terraform documentation on provider versioning or reach out if you need any assistance upgrading.

For further feature requests or bug reports with this functionality, please create a new GitHub issue following the template. Thank you!

[github-actions]

I'm going to lock this pull request because it has been closed for 30 days ⏳. This helps our maintainers find and focus on the active contributions.
If you have found a problem that seems related to this change, please open a new issue and complete the issue template so we can capture all the details necessary to investigate further.