Reading from dedicated SQL pool from different workspace

Brass Contributor

I'm hoping I'm overthinking this, however it's stumped me.

 

We have 3 synapse workspaces (dev/test/prod), utilizing pipelines and dedicated SQL pool.  We have been successfully connecting the pipelines and DB within the workspace environment successfully.

 

We have recently had a need to set up a process where a pipeline in our Test environment needs to connect to the dedicated SQL pool in our Dev environment to pull data over.

 

Additional info, we have a firewall on our workspaces that only allow connectivity from our VPN IP, we have a self hosted integrated runtime running on premise which would be utilizing that VPN IP.

 

We are also using Managed Networks and endpoints.

 

I have an endpoint created from the Test workspace to the Dev SQL Pool

I am using our self hosted integration runtime to do the communication testing

I have granted the Test Managed Identity pretty much full permissions to the Dev workspace and the SQL Dedicated pool.

 

0 Replies