not able to create private link service for snowflake in synapse

Question

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?

Answer 1

@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 .

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.