Forum Discussion

MarkBurgess's avatar
MarkBurgess
Icon for Advocate I rankAdvocate I
1 year ago

Dataflow Gen2 lakehouse connection token expired

Hi, I have a Dataflow Gen2 that updates a Lakehouse table from an on-prem SQL database. There is a shared connection set up to the destination Lakehouse, but the only option for authentication is OAu...
Need Help
v-csrikanth's avatar
v-csrikanth
Icon for Community Support rankCommunity Support
1 year ago

Hi MarkBurgess 

Thank you Akash_Varuna for your valuable insights and helpful suggestions! Your contribution is greatly appreciated.

Among the proposed solutions, using a Service Principal is the best approach for ensuring seamless and secure long-term authentication. It eliminates dependency on user-based authentication and allows automated token renewal, making it an efficient and scalable solution.

Thanks and regards,
Cheri Srikanth.