Write to Key Vault from Fabric Notebook

Hello there Fabricators!

I am accessing an API with OAuth2 authentication. I am using the refresh token to get a new access token and a new refresh token. Using Azure Key Vault, I need to save these tokens manually every time I refresh them (the access token is valid for 1 hour).

I am looking for a way to write the new access and refresh token into the Key Vault via the Notebook.

Is there any reasonable way to write secrets into an Azure Key Vault from a Fabric Notebook?

I am aware of this article: https://iterationinsights.com/article/microsoft-fabric-notebooks-and-azure-key-vault/

Is this really the only way right now?

Does this solution work if I call the Notebook from a Pipeline?

Did anyone try the instructions from the article?

Is there a way to use the Workspace identity instead?

Does anyone have an alternative solution for dealing with OAuth2 authentication, access and refresh tokens in a secure manner?

Lots of questions...it is simply baffling that Fabric has so limited functionality when it comes to handling secrets of interacting with another Azure resource such as Key Vault. 😮‍💨

Thank you in advance

0 comments