Hi all,

So I've created a Fabric SQL database in my workpsace and using it to store some configuration for data pipelines

I'm using lookups in Data Pipelines to fetch information from the Fabric SQL database in the same workpsace

That works well

However I just realized that Fabric automatically creates a connection in the "Manage Connections and Gateways" and that this connection relies on my personal tokens for authentication

Also I'm not able to create the same kind of connection directly from the "Manage Connections and Gateways" page.

So is there a way to use a SPN authentication instead. It does not look like it at the moment but is it in the roadmp ?

The reason I'm asking is that I can't rely on the current authentication method for higher environments (TST and PROD).

Also I had quite some issues after updating my password, I had to resave all my pipelines in DEV env so credentials would be synced in pipelines somehow 😕

Thanks