Share via

mssparkutils.credentials.getSecret not working

Ramachandraiah, Putta 5 Reputation points
2023-10-19T11:56:01.22+00:00

when trying to fetch secrets from azure key-vault using mssparkutils in azure synapse getting below exception

Py4JJavaError: An error occurred while calling z:mssparkutils.credentials.getSecret. : com.twitter.finagle.NoBrokersAvailableException: No hosts are available for idr-vault-demo-6bc2d247.vault.azure.net:443, Dtab.base=[], Dtab.local=[]. Remote Info: Not Available

It's working in other environments, but failing in UAT

here is the sample code I am using, in the linked service when I click on test connection it is showing successful (:, but not working with getSecret method.

ADLS_ACCOUNT_NAME = mssparkutils.credentials.getSecret(KEY_VAULT_NAME, 'IDR-ADLS-NAME', KV_LINKED_SERVICE_NAME)
Azure Key Vault
Azure Key Vault
An Azure service that is used to manage and protect cryptographic keys and other secrets used by cloud apps and services.
1,412 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,307 questions

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.