Created this message here after having a call with microsoft support. The behaviour inside a fabric pipeline has recently updated when defining a lakehouse connection. This new approach does not...
ToddChitt
Super User
Super UserTo be honest, I never really understood why you need BOTH a generic 'Warehouse' (or 'lakehouse') connection under Connections and Gateways that is workspace independent, AND then specify a specific warehouse (or lakehouse) in the pipeline. But that's what Microsoft has given us.
Worse, these connections under Connections and Gateways ONLY support OAuth, NOT Service Principals :(, meaning that the account listed under Authentication needs to log in every 30 days to refresh the Access Token.
