I have a setup as following: Data factory starts a Stored Procedure in Synapse to read data from a delta table like this:
With allowing all networks on the storage account, this works without any problem. But when we only allow selected networks (our VNET + the Synapse and ADF workspace). This fails to work.
The weird thing is:
When I start the stored procedure from within Synapse it works. (I had to setup a private endpoint).
When I want to read data from the storage account immediatly with Data Factory, it works. (I had to setup a private endpoint).
Combining both together do not work.
Is there anywone that can help us with securing our data lake?