Hi,

How can I use Azure managed Identity to connect to postgres pg vector when doing the embedding ? I have the following chunk of code:

 PostgresConfig postgresConfig = new()
 {
 ConnectionString = configuration.GetConnectionString("DefaultConnection")
 };
 
 var memory = new KernelMemoryBuilder()
 .WithAzureOpenAITextGeneration(chatConfig)
 .WithAzureOpenAITextEmbeddingGeneration(embeddingConfig)
 .WithAzureBlobsDocumentStorage(azureBlobsConfig)
 .WithAzureAIDocIntel(azureAIDocIntelConfig)
 .WithPostgresMemoryDb(postgresConfig)
 .Build<MemoryServerless>();

I was able to use managed identity ith ef core but it seems semantic kernel postgres configuration does not support managed identity out of the box, or am I wrong there ? Please let me know if there is any better way of enabling managed identity without rolling my own IMemoryStore implementation.

Thanks