Synapse private endpoint for parameterized linked service

Question

Synapse private endpoint for parameterized linked service

spencer 31

Hi there,

We're working to adopt private endpoints with Synapse Analytics. We currently use parameters in our linked services and this doesn't support the selection of a Managed Private Endpoint:

It doesn't look like you can hardcode the private endpoint in JSON for the linked service or otherwise parameterize the managed private endpoint. Is it at all possible to used parameterized linked services with managed private endpoints?

Thanks for your help,
Spencer

PRADEEPCHEEKATLA 91,831 Reputation points

2021-10-06T09:53:04.463+00:00

Hello @spencer ,

Thanks for the question and using MS Q&A platform.

Currently, it doesn't support the selection of a Managed Private Endpoint.

Thank you for sharing the feedback [Synapse private endpoint for parameterized linked service]. We appreciate it. We will share and elevate your feedback with the Azure Synapse product team. I will be update you once I hear back from the team.
spencer 31 Reputation points

2021-10-06T14:55:23.147+00:00

Thank you, @PRADEEPCHEEKATLA for your response. Just to clarify:

Parameterized linked services in Synapse do not support selection of a Managed Private Endpoint (via the Synapse Studio GUI or code)

Please let me know if my understanding of this limitation is correct.
spencer 31 Reputation points

2021-10-06T15:58:32.563+00:00

Sorry, after some more testing, it appears that the limitation is just within the Synapse Studio "GUI".

If the selected integration runtime is on a managed VNet and a managed private endpoint was created on that same VNet, its DNS record directs the integration runtime to use the private endpoint regardless of what's in the GUI.

This understanding gives me confidence to move forward. If I'm missing something or if you can provide greater clarification, I would appreciate it nevertheless.
PRADEEPCHEEKATLA 91,831 Reputation points

2021-10-13T08:56:24.783+00:00
Hello @spencer ,

Following up to see if the below suggestion was helpful. And, if you have any further query do let us know.

------------------------------

Please don't forget to click on or upvote button whenever the information provided helps you.

Answer accepted by question author

0 additional answers

Your answer

PRADEEPCHEEKATLA 91,831 Reputation points

2021-10-06T09:53:04.463+00:00

Hello @spencer ,

Thanks for the question and using MS Q&A platform.

Currently, it doesn't support the selection of a Managed Private Endpoint.

Thank you for sharing the feedback [Synapse private endpoint for parameterized linked service]. We appreciate it. We will share and elevate your feedback with the Azure Synapse product team. I will be update you once I hear back from the team.
spencer 31 Reputation points

2021-10-06T14:55:23.147+00:00

Thank you, @PRADEEPCHEEKATLA for your response. Just to clarify:

Parameterized linked services in Synapse do not support selection of a Managed Private Endpoint (via the Synapse Studio GUI or code)

Please let me know if my understanding of this limitation is correct.
spencer 31 Reputation points

2021-10-06T15:58:32.563+00:00

Sorry, after some more testing, it appears that the limitation is just within the Synapse Studio "GUI".

If the selected integration runtime is on a managed VNet and a managed private endpoint was created on that same VNet, its DNS record directs the integration runtime to use the private endpoint regardless of what's in the GUI.

This understanding gives me confidence to move forward. If I'm missing something or if you can provide greater clarification, I would appreciate it nevertheless.
PRADEEPCHEEKATLA 91,831 Reputation points

2021-10-13T08:56:24.783+00:00

Hello @spencer ,

Following up to see if the below suggestion was helpful. And, if you have any further query do let us know.

------------------------------

Please don't forget to click on or upvote button whenever the information provided helps you.

Answer 1

Hello @spencer ,

Your understanding is correct - Parameterized linked services in Synapse do not support selection of a Managed Private Endpoint (via the Synapse Studio GUI or code).

In order to select Managed private endpoint - it requires the server name.

Note: If you pass server name as parameterized linked service - server name then the managed private endpoint shows as blank.

Hope this will help. Please let us know if any further queries.

------------------------------

Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
Want a reminder to come back and check responses? Here is how to subscribe to a notification
If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

PRADEEPCHEEKATLA 91,831 Reputation points

2021-10-11T09:03:47.717+00:00

Hello @spencer ,

Just checking in to see if the above answer helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

Share via

Synapse private endpoint for parameterized linked service

0 additional answers

Your answer