topic Re: Error while mounting ADLS in python using AccountKey in Data Engineering

Error while mounting ADLS in python using AccountKey

Krish1 — Fri, 28 Apr 2023 01:21:01 GMT

I'm using the below code using Account key to mount ADLS in python but running into error:shaded.databricks.org.apache.hadoop.fs.azure.AzureException: java.lang.IllegalArgumentException: The String is not a valid Base64-encoded string. Can you please help?

AccountKey = dbutils.secrets.get(scope="ADB_KV_Secret_Scope", key="dev-storage-account-clientid")

url = "wasbs://dev@storage.blob.core.windows.net"

mnt = "/mnt/findatamart"

configs = "fs.azure.account.key.storage.blob.core.windows.net"

dbutils.fs.mount(

source = url,

mount_point = mnt,

extra_configs ={configs:AccountKey}

)

Re: Error while mounting ADLS in python using AccountKey

Prabakar — Fri, 28 Apr 2023 09:34:30 GMT

@Krish Lam you need to provide more details for the config. Please refer to the below doc.

Mounting cloud object storage on Azure Databricks - Azure Databricks | Microsoft Learn

Re: Error while mounting ADLS in python using AccountKey

Prabakar — Fri, 28 Apr 2023 09:35:09 GMT

configs = {"fs.azure.account.auth.type": "OAuth",

"fs.azure.account.oauth.provider.type": "org.apache.hadoop.fs.azurebfs.oauth2.ClientCredsTokenProvider",

"fs.azure.account.oauth2.client.id": "<application-id>",

"fs.azure.account.oauth2.client.secret": dbutils.secrets.get(scope="<scope-name>",key="<service-credential-key-name>"),

"fs.azure.account.oauth2.client.endpoint": "https://login.microsoftonline.com/<directory-id>/oauth2/token"}

# Optionally, you can add <directory-name> to the source URI of your mount point.

dbutils.fs.mount(

source = "abfss://<container-name>@<storage-account-name>.dfs.core.windows.net/",

mount_point = "/mnt/<mount-name>",

extra_configs = configs)

Replace

<application-id> with the Application (client) ID for the Azure Active Directory application.
<scope-name> with the Databricks secret scope name.
<service-credential-key-name> with the name of the key containing the client secret.
<directory-id> with the Directory (tenant) ID for the Azure Active Directory application.
<container-name> with the name of a container in the ADLS Gen2 storage account.
<storage-account-name> with the ADLS Gen2 storage account name.
<mount-name> with the name of the intended mount point in DBFS.

Re: Error while mounting ADLS in python using AccountKey

Krish1 — Fri, 28 Apr 2023 16:19:03 GMT

Thank you. That worked.

Re: Error while mounting ADLS in python using AccountKey

Anonymous — Sat, 29 Apr 2023 06:26:46 GMT

Hi @Krish Lam

Thank you for posting your question in our community! We are happy to assist you.

To help us provide you with the most accurate information, could you please take a moment to review the responses and select the one that best answers your question?

This will also help other community members who may have similar questions in the future. Thank you for your participation and let us know if you need any further assistance!