'Azure Synapse SQL managed endpoint terraform error

I'm trying to deploy a synapse workspace with a dedicated SQL pool. It creates the resources, but errors when trying to created a managed endpoint stating the resource id is not in the right format. I have the data lake managed endpoint deployed successfully.

resource "azurerm_synapse_managed_private_endpoint "sql_mpe" {
    name = "dedicated-sql-mpe"
    synapse_workspace_id = azurerm_synapse_workspace.synapse.id
    target_resource_id = azurerm_synapse_sql_pool.sql_pool.id
    subresource_name = "sql"
}

Solution 1:^[1]

When creating a dedicated SQL pool the Managed Private Endpoint and Link Service are automatically created now and a standard private endpoint is not supported.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	Micah Castorina

'Azure Synapse SQL managed endpoint terraform error

Solution 1:[1]

Sources

Related Questions

Solution 1:^[1]