Forum Discussion
Data Warehouse with Private Link enabled + Lookup activity - Cannot connect to SQL Database
It appears the Data Warehouse endpoint is currently inaccessible for any pipeline activity (including a Lookup activity) when Private Link is enabled. The documentation explicitly mentions that copying data from or into a Data Warehouse isn’t possible, and even though it doesn’t call out Lookup activity by name, the underlying limitation means the Data Warehouse SQL endpoint can’t be reached from the pipeline runtime once Private Link is enabled. In practice, this blocks queries or stored procedures in Lookup, copy activities, or other attempts to connect to the warehouse.
Many users see the same behavior—a connection failure—because the Data Warehouse endpoints don’t support these operations over the private network yet. Disabling Private Link or using other endpoints (such as a Lakehouse) is often the only current workaround. If you must work with the Warehouse, you may need to revert to public access or use an alternative path until the platform’s roadmap includes support for private-link-enabled Data Warehouse pipeline operations.If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.
Super Userprobably with " copying data from " they means "read data from".
that seems a major block to me.
it states you are able to write into a lakehouse, you are able to read I suppose.
if yes, you could try to shortcut the warehouse table into a lakehouse and to perform the lookup activity on the shortcut.
just guessing... not tested...