Need help understanding Connections
Trying to put together a super simple metadata driven pipeline, for which I've already created a Fabric SQL Database with a metadata table and a few rows of data. If I click on OneLake in left hand nav I am able to see this DB along with the other connections I've made through our on-prem gateway.
However, when I create a script task in a pipeline I can see the on-prem connections (under OneLake) but not the Fabric SQL DB.
When I use a Lookup task I DO see the Fabric SQL DB under OneLake.
Trying to understand why the Fabric SQL DB is unavailable in Script task under OneLake "single, unified, logical data lake for your whole organization"