private endpoints moving from UAT to production

Salomon Henriquez 106 Reputation points Microsoft Employee
2022-11-02T17:14:45.51+00:00

I have a few private endpoints created in our UAT environment which talk to UAT SQL DB (under the UAT resource group).

Question: When we deploy Synapse using DevOps CICD to production, do I need to create these private endpoints manually? Because they are supposed to be in the production resource group and supposed to talk to production DB.

Thanks in advance for any ideas or insights.

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,369 questions
0 comments No comments
{count} votes

Accepted answer
  1. BhargavaGunnam-MSFT 26,136 Reputation points Microsoft Employee
    2022-11-03T21:38:54.037+00:00

    Hello @Salomon Henriquez ,

    Welcome to the MS Q&A platform.

    You can create private endpoints using the release pipeline(synapse deployment task). The deployment of managed private endpoint is only supported in version 2.x. Please make sure you select the right version and check the Deploy managed private endpoints in the template.

    Please note:
    If a private endpoint already exists in synapse and you try to deploy an ARM template that contains a private endpoint with the same name but with modified properties, the deployment will fail. In other words, you can successfully deploy a private endpoint as long as it has the same properties as the one that already exists in the Synapse. If any property is different between environments, you can override it by parameterizing that property and providing the respective value during deployment.

    257013-image.png

    Reference document:
    https://learn.microsoft.com/en-us/azure/synapse-analytics/cicd/continuous-integration-delivery

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

    • Please don't forget to click on 130616-image.png and upvote 130671-image.png 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
    0 comments No comments

0 additional answers

Sort by: Most helpful