An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
Hello @Rushil Shetty
If you’re referring to a Managed Private Endpoint created from an Azure Synapse workspace that has Managed VNet enabled, the expected lifecycle is:
Synapse Managed VNet > Managed Private Endpoint created > Provisioning State = Succeeded > Approval State = Pending > Target resource owner approves > Approval State = Approved
The connection is created in Pending state, and the owner of the target Private Link resource must approve or reject it. Only an Approved managed private endpoint can carry traffic.
So if Synapse Studio shows the managed private endpoint as created successfully but you don’t see a corresponding approval request on the target resource, check the following:
- Confirm the workspace actually has a Managed workspace Virtual Network. Managed private endpoints are only supported when Managed VNet is enabled.
- Confirm the Private Link Resource ID and groupId are correct for the target service.
- On the target resource, open Networking / Private endpoint connections and look for the pending connection.
- If the target is in another subscription or tenant, verify you have the required permissions on that target resource and that cross-tenant configuration is allowed.
- If approval fails or the Approve button is missing, verify the approver has the target service’s privateEndpointConnectionsApproval/action permission. Microsoft’s current Private Link troubleshooting guidance specifically calls out missing approval permissions as a common reason managed-service private endpoints remain stuck or can’t be approved.
Also note that managed-service private endpoints such as those created by Synapse do not auto-approve simply because the source and target are in the same subscription. Microsoft specifically calls managed Azure services such as Azure Synapse out as requiring approval.
You can also verify the Synapse-side object from CLI:
az synapse managed-private-endpoints list \
--workspace-name <workspace-name>
or inspect a specific endpoint:
az synapse managed-private-endpoints show \
--workspace-name <workspace-name> \
--pe-name <endpoint-name>
These commands are the supported CLI operations for Synapse managed private endpoints.
If the Synapse endpoint shows provisioningState: Succeeded but the target resource has no pending private endpoint connection, that would be the interesting failure condition. In that case, capture the managed private endpoint JSON, target resource ID, groupId, exact UTC creation time, and Activity Log entries from both source and target subscriptions, then raise it with Azure Support because the Synapse control plane appears to have created the consumer-side object without successfully creating the corresponding target-side connection request.
References:
Managed private endpoints in Azure Synapse Analytics
Create a managed private endpoint in Synapse
Managed virtual network in Azure Synapse
Azure CLI - Synapse managed private endpoints
Help make this community better for everyone: If this answer helped or resolved your issue, please accept it or upvote it. If not, share more details in a comment so we can continue the discussion and find the right solution. Thank you.