keyvault – Programming & Mustangs!

Synapse: Get KeyVault Properties Using Token Library

This post is how to get the key vault properties using the token library.

Ensure you have a spark session created. Refer to PySpark: Create a Spark Session

import sys
from pyspark.sql import SparkSession

linked_service_name = '<KEYVAULT_LINKED_SERVICE_NAME>'
spark = <GET_SPARK_SESSION>
token_library = spark._jvm.com.microsoft.azure.synapse.tokenlibrary.TokenLibrary
key_vault_url = token_library.getFullConnectionStringAsMap(linked_service_name).get('url')

print(key_vault_url)
print(token_library.getFullConnectionStringAsMap(linked_service_name))

Synapse: Key Vault Linked Service

This post is how to get the key vault linked service properties.

from notebookutils import mssparkutils
import json

linked_service_name = '<SYNAPSE_KEYVAULT_LINKED_SERVICE_NAME>'
json.loads(mssparkutils.credentials.getPropertiesAll(linked_service_name))