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"
}