Analytics Synapse Analytics field-manual-complete field-manual-complete field-manual-complete

Synapse managed private endpoint

A Synapse managed private endpoint is a private connection that Synapse manages for you. Instead of letting a workspace reach a storage account, database, or Cosmos DB account over public networking, you create an endpoint from the Synapse managed virtual network to one approved resource. The resource owner must approve the private endpoint connection before it works. For learners, the important point is scope: this is not general internet access or a VPN. It is a controlled, named path from one Synapse workspace to one Private Link target.

Aliases
Azure Synapse managed private endpoint, Synapse MPE, managed private endpoint in Synapse, Synapse Private Link endpoint
Difficulty
intermediate
CLI mappings
5
Last verified
2026-05-27T06:46:29Z

Microsoft Learn

A Synapse managed private endpoint is a private endpoint that Azure Synapse creates inside a workspace managed virtual network to reach a specific Azure resource over Private Link. It supports approved, resource-scoped connectivity for storage, databases, Cosmos DB, and other targets without opening public network paths.

Microsoft Learn: Azure Synapse Analytics managed private endpoints2026-05-27T06:46:29Z

Technical context

Technically, a Synapse managed private endpoint exists only in a Synapse workspace that has a managed virtual network. The endpoint definition includes a private link resource ID and a group ID, such as blob, dfs, sqlServer, or another supported target group. Creation starts an approval workflow on the target resource. Until approval, the endpoint remains unusable for traffic. Pipelines, Spark jobs, and linked services can then use the private route, depending on connector and integration runtime behavior. It is a networking artifact tied to workspace isolation, not a separate data-processing service.

Why it matters

This term matters because private data platforms usually fail at the connection boundary, not inside the transformation code. A storage account can be locked down correctly and still break every pipeline if the managed private endpoint is pending, pointed at the wrong subresource, or deleted during cleanup. It also matters for data-exfiltration control: instead of letting a workspace reach any public endpoint, teams approve specific resource paths. Architects use managed private endpoints to make restricted Synapse workspaces useful, while operators use them to prove why a connection is approved, rejected, pending, or blocked. Verify approval evidence before production data movement is approved.

Where you see it

Signals, screens, and Azure surfaces where this term usually becomes operational.

Signal 01

In Synapse Studio Manage, managed private endpoints show target resource ID, group ID, provisioning state, private-link approval status, and reviewer evidence during release gates and approvals.

Signal 02

In Azure CLI output, endpoint list and show commands reveal whether a workspace connection is pending, approved, rejected, or mis-targeted during access incidents and reviews.

Signal 03

In deployment failures, storage, Cosmos DB, or SQL access errors often trace back to missing approval or the wrong private endpoint group ID during validation.

When this becomes relevant

Specific situations where this term helps solve real Azure design, operations, migration, security, reliability, cost, or governance problems.

  • Connect a locked-down Synapse workspace to ADLS Gen2 without enabling public network access on the storage account.
  • Approve private access to one database or Cosmos DB account while blocking broad outbound access from the workspace.
  • Migrate pipelines from public endpoints to Private Link without rewriting every dataset or transformation.
  • Prove to auditors which specific resources a Synapse workspace can reach through approved private connections.
  • Troubleshoot private connectivity failures by checking endpoint definition, approval state, group ID, DNS, and linked service together.

Real-world case studies

Different enterprise-style examples that show the term being used to hit measurable objectives.

Case study 01

Insurance claims lake closes its public storage exception

Scenario, objectives, solution, measured impact, and takeaway.

Scenario

An insurer stored claim images and adjuster notes in ADLS Gen2. Its Synapse workspace still used a temporary public firewall exception created during the original migration.

Business/Technical Objectives
  • Remove public network access for claim storage without stopping analytics pipelines.
  • Route Synapse data integration and Spark access through approved private connectivity.
  • Document exactly which storage account and subresources were reachable from the workspace.
  • Reduce failed claim-load retries caused by rotating firewall exceptions.
Solution Using Synapse managed private endpoint

The platform team created Synapse managed private endpoints for the storage account dfs and blob subresources using reviewed JSON files. The storage owner approved the target-side private endpoint connections after verifying the workspace and resource IDs. Linked services were updated to use the private path from the managed virtual network workspace. Operators used Azure CLI to list endpoints, show connection status, capture target resource IDs, and validate one claim-load pipeline before opening the full nightly schedule.

Results & Business Impact
  • The public storage firewall exception was removed with no missed claim analytics load.
  • Pipeline retry count for claim image ingestion dropped by 76% in the first month.
  • Security reviewers received endpoint names, resource IDs, group IDs, and approval timestamps in one evidence package.
  • Mean time to diagnose storage connectivity failures fell from 80 minutes to 21 minutes.
Key Takeaway for Glossary Readers

Managed private endpoints give Synapse teams a precise, auditable way to reach sensitive resources without leaving public access open.

Case study 02

Pharmaceutical lab protects compound research database access

Scenario, objectives, solution, measured impact, and takeaway.

Scenario

A pharmaceutical research group queried compound-screening results from Synapse Spark. The Azure SQL Database team would not allow public network access from analytics workspaces.

Business/Technical Objectives
  • Enable approved Synapse access to one research database only.
  • Keep private connectivity separate from broad virtual network peering requests.
  • Provide database owners with clear approval control.
  • Cut failed notebook runs caused by inconsistent manual firewall changes.
Solution Using Synapse managed private endpoint

Network engineers confirmed that the Synapse workspace used a managed virtual network, then created a managed private endpoint targeting the Azure SQL server private link resource and sqlServer group. The database owner approved the private endpoint connection after validating the request description and resource ID. A dedicated linked service used the approved route, while workspace roles limited who could run research notebooks. The operations checklist showed endpoint state, target-side approval, linked-service JSON, and a sample Spark read test before researchers resumed jobs.

Results & Business Impact
  • Notebook connectivity success rose from 88% to 99.4% across the next quarter.
  • No public firewall rules were added for the research database after implementation.
  • Approval evidence satisfied a preclinical data-access review in one working day instead of two weeks.
  • Researchers saved roughly 30 minutes per failed run previously spent waiting for firewall exceptions.
Key Takeaway for Glossary Readers

A managed private endpoint is a narrow approval path, which is exactly what sensitive research systems need from analytics workspaces.

Case study 03

Renewable-energy operator standardizes private access to telemetry stores

Scenario, objectives, solution, measured impact, and takeaway.

Scenario

A wind-farm operator used separate storage accounts for turbine telemetry in five regions. Synapse jobs failed unpredictably because each region had different firewall and approval practices.

Business/Technical Objectives
  • Create a repeatable private connectivity pattern for regional telemetry accounts.
  • Avoid granting the analytics workspace broad outbound access to unrelated energy systems.
  • Reduce manual coordination between field operations and data engineering teams.
  • Make endpoint cleanup safe during storage account consolidation.
Solution Using Synapse managed private endpoint

The architecture team defined a standard managed private endpoint JSON template with parameters for storage account resource ID, group ID, and endpoint name. Azure CLI created endpoints in the Synapse workspace for each regional telemetry account, and regional storage owners approved the pending connections from their side. Linked services were tagged with endpoint dependencies. During consolidation, operators listed endpoints, matched resource IDs to active storage accounts, and deleted only the paths whose linked services had already been retired.

Results & Business Impact
  • Regional endpoint creation time dropped from 3 hours of coordination to 25 minutes of scripted work.
  • Telemetry pipeline failures tied to firewall drift fell from 18 per month to 3 per month.
  • Storage consolidation removed 11 unused endpoints without breaking active turbine reporting jobs.
  • Private connectivity evidence was reusable across five regional operations reviews.
Key Takeaway for Glossary Readers

Standard endpoint definitions make private Synapse connectivity repeatable without turning every regional exception into a custom networking project.

Why use Azure CLI for this?

As an Azure engineer with ten years of private networking scars, I use Azure CLI for managed private endpoints because approval state and resource IDs need exact evidence. The portal is fine for one endpoint, but scripted list and show commands scale across workspaces and subscriptions. CLI lets me create endpoints from reviewed JSON, verify the privateLinkResourceId and groupId, detect pending approvals, and export inventories for security review. I also pair Synapse commands with target-resource private endpoint connection commands when the storage, database, or service owner must approve or reject the request. Use those exports when troubleshooting secure analytics under pressure and during audits.

CLI use cases

  • List managed private endpoints in a Synapse workspace before a security review or migration.
  • Show one endpoint to verify private link resource ID, group ID, provisioning state, and connection status.
  • Create a managed private endpoint from reviewed JSON for a storage, database, or service target.
  • Delete a retired endpoint after confirming no linked services, pipelines, notebooks, or runbooks still depend on it.
  • List or approve the target-side private endpoint connection when the resource owner controls approval.

Before you run CLI

  • Confirm the active tenant, subscription, workspace, target resource ID, resource group, and whether the endpoint supports the desired group ID.
  • Make sure the Synapse workspace was created with a managed virtual network, because managed private endpoints require that boundary.
  • Review the JSON file carefully; a wrong privateLinkResourceId can request access to the wrong production resource.
  • Coordinate with the target resource owner so the pending private endpoint connection is approved after creation.
  • Treat delete commands as production-impacting unless dependency checks prove the endpoint is unused.

What output tells you

  • The endpoint name and workspace identify which Synapse environment owns the requested private connectivity path.
  • The privateLinkResourceId shows the exact Azure resource being targeted, which is critical for approval and audits.
  • The groupId shows the subresource, such as blob, dfs, sqlServer, or another service-specific Private Link group.
  • Provisioning and connection states explain whether the endpoint exists, is pending approval, approved, rejected, or failed.
  • Target-side private endpoint connection output identifies who must approve the request and what description was recorded.

Mapped Azure CLI commands

Command bundle

az synapse managed-private-endpoints list --workspace-name <workspace-name>
az synapse managed-private-endpointsdiscoverAnalytics
az synapse managed-private-endpoints show --workspace-name <workspace-name> --pe-name <endpoint-name>
az synapse managed-private-endpointsdiscoverAnalytics
az synapse managed-private-endpoints create --workspace-name <workspace-name> --pe-name <endpoint-name> --file @managed-private-endpoint.json
az synapse managed-private-endpointsprovisionAnalytics
az synapse managed-private-endpoints delete --workspace-name <workspace-name> --pe-name <endpoint-name>
az synapse managed-private-endpointsremoveAnalytics
az network private-endpoint-connection approve --id <private-endpoint-connection-id> --description "Approved for Synapse workspace <workspace-name>"
az network private-endpoint-connectionsecureAnalytics

Architecture context

Architecturally, a Synapse managed private endpoint is the join point between workspace isolation and a specific platform dependency. I treat it like a firewall rule with identity, approval, and lifecycle attached. In a managed virtual network workspace, Spark and data integration workloads can be forced toward approved targets, but each target still needs the right subresource, DNS behavior, permissions, and linked-service configuration. Dedicated and serverless SQL pool endpoints may be created automatically for workspace internals, while external sources need deliberate design. Good architectures document endpoint purpose, owner, target resource ID, group ID, approval owner, and dependent artifacts. Confirm this design before any sensitive pipeline runs.

Security

Security impact is direct. A managed private endpoint narrows Synapse connectivity to an approved resource instead of relying on broad public network access. The control is only strong when paired with managed virtual network design, data exfiltration protection where required, least-privilege workspace roles, target resource firewall rules, and careful approval ownership. A pending or rejected endpoint is safer than an unreviewed public exception, but a wrongly approved endpoint can still expose sensitive data. Operators should verify the target resource ID, tenant, group ID, and requester before approval, then keep evidence for compliance reviews. Approval records should be reviewed with data owners during every access change. Verify these details before approval is granted.

Cost

Managed private endpoints are not usually the largest line item, but they affect cost through private networking, duplicated environments, failed runs, and operational effort. A missing approval can cause repeated pipeline retries, Spark session starts, and analyst downtime. Over-creating endpoints to every possible resource increases review overhead and may create unnecessary private connectivity charges depending on the service and region. FinOps ownership should be tied to the workspace and target resource, not lost between teams. Clean inventories help remove unused endpoints after migrations while avoiding accidental deletion of paths still used by production workloads. Include this inventory in platform reviews, offboarding activities, and quarterly private endpoint cleanup cycles.

Reliability

Reliability depends on endpoint lifecycle and approval state. A pending endpoint can make a linked service look correctly configured while every activity still fails. A deleted or rejected endpoint can break multiple pipelines, Spark jobs, or notebooks at once. Resource moves, storage account replacements, subresource mistakes, DNS behavior, and firewall policy changes can also create hard-to-read failures. Reliable teams create managed private endpoints through change-controlled artifacts, validate approval before scheduling production runs, and maintain dependency maps. They also avoid deleting endpoints until related linked services, datasets, scripts, and run histories have been checked. Include endpoint checks in every critical pipeline preflight. Repeat that check during every private connectivity change window.

Performance

Performance impact is mostly about routing predictability and access reliability, not magic speed. Private Link traffic stays on the Microsoft backbone, which can reduce exposure and avoid some public network variability, but target service throughput, Spark startup, file layout, SQL capacity, and connector behavior still dominate runtime. A wrong group ID or pending approval produces failures rather than slower queries. Operators should measure end-to-end pipeline duration before assuming private networking is the bottleneck. In many incidents, performance improves because teams stop retrying blocked public paths and use a stable, approved private route. Measure actual copy throughput after each endpoint approval change. Repeat throughput checks during production release rehearsals.

Operations

Operators inspect managed private endpoints when pipelines cannot reach private storage, when a security review asks why a workspace can access a resource, or when a migration changes account names. They list endpoints, show definitions, check provisioning and connection state, confirm target resource IDs, and coordinate approvals with the owning team. Runbooks should include who approves the connection, which linked services depend on it, and what to test after approval. During incidents, operators should separate network reachability, private endpoint approval, authentication, DNS, firewall rules, and connector configuration before restarting jobs repeatedly. They should confirm the same endpoint definitions exist in recovery and lower environments. Record expired endpoint requests so release blockers are visible early too.

Common mistakes

  • Creating the endpoint in a workspace that was not built with a managed virtual network and then expecting private routing.
  • Approving a request without checking the exact target resource ID, tenant, group ID, and requester context.
  • Forgetting that pending endpoints cannot carry traffic, even when linked services and datasets look valid.
  • Deleting a managed private endpoint during cleanup without checking production pipelines, notebooks, and linked services.
  • Confusing Synapse managed private endpoints with customer-managed private endpoints in a hub-spoke virtual network.