not able to create private link service for snowflake in synapse

Narender Kumar 70 Reputation points
2023-12-18T08:33:04.2+00:00

I need to connect Synapse to a snowflake using private link service.

I am following the below steps to create private link in Azure Synapse:

https://community.snowflake.com/s/article/How-to-set-up-a-managed-private-endpoint-from-Azure-Data-Factory-or-Synapse-to-Snowflake

When I put snowflake resource id and other details in the "Private Link service" option in Synpase, I get the below error:

"Unauthorized tenant: Target subscription id<123> tenant <123> is not in allowed list.

How can I add the snowflake resource subscription and tenant in the allowed list so that i can create this private link service?

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.
5,378 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator
    2023-12-19T01:27:22.4933333+00:00

    @Narender Kumar Welcome to Microsoft Q&A forum and thanks for reaching out here.

    As per the error message ""Unauthorized tenant: Target subscription id<123> tenant <123> is not in allowed list." It seems like your snowflake is different subscription and different tenant than that of Synapse Workspace tenant and subscription. Could you please validate this?

    1. If they are in different tenant, then please ensure that the provider subscription or tenant has registered Microsoft.Network .

    User's image

    1. In case if both the resources are in different subscriptuons and have different vNets, then you will have to peer the vnets as described in this SO post - Cross-subscription Private Endpoint in Azure

    Kindly validate these steps and let us know how it goes.

    Hope this info helps.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.