Integration of Workload Identity with OpenFGA for Azure PostgreSQL Flexible Server

[yashdeep-shah]

Hi team,
We are planning to integrate workload identity to connect our pods to the Azure PostgreSQL Flexible Server. Currently, our OpenFGA application uses environment variables to connect to PostgreSQL via a connection string.

Questions:

• Can we configure OpenFGA to use workload identity for connecting to Azure PostgreSQL Flexible Server instead of using traditional connection strings via environment variables?
• If supported, what are the steps or configurations required to achieve this integration?
• Are there any specific environment variables or settings that need to be configured in OpenFGA to use workload identity?
• Are there any examples or documentation that provide guidance on setting this up?
  cc- @chahat-agarwal