Reading Azure Key Vault secrets in Azure Synapse notebook using Python SDK

Question

I have created python package which read azure key vault secrets. The wheel package is created and imported into synapse spark pool. when I tried to add package in synapse notebook from wheel package it throws an error :

ModuleNotFoundError: No module named 'azure.keyvault'

here is the python module that reads secrets from Azure key vault and wheel package is imported into apache spark pool

from azure.identity import DefaultAzureCredential
from azure.keyvault.secrets import SecretClient

KEYVAULT_NAME = "lll-kv-scus"

KEYVAULT_URI = f"https://{KEYVAULT_NAME}.vault.azure.net"

credential = DefaultAzureCredential(exclude_shared_token_cache_credential=True)

client = SecretClient(vault_url=KEYVAULT_URI, credential=credential)

Server = client.get_secret("erverURL").value
User = client.get_secret("sql-user").value
Password = client.get_secret("sql-password").value
Database = client.get_secret("sql-databasename").value

A method is defined which returns key vault secrets. In synapse notebook tried to import above package to get secrets but it is unable to import SecretClient package.

Answer 1

Hello @Anonymous ,

Thanks for the question and using MS Q&A platform.

As per the error message: ModuleNotFoundError: No module named 'azure.keyvault' - which clearly says Azure Key Vault Secrets modules has not installed on the Apache Spark pool.

Before installing the Azure Key Vault Module:

Here is the requirements.txt file contains:

azure-keyvault==4.2.0  
azure-keyvault-secrets==4.6.0  

To resolve this issue you need to install Azure Key Vault module on the Apache Spark pool as shown below:

After installing the Azure Key Vault Module:

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is jhow you can be part of Q&A Volunteer Moderators