topic Re: How to mount Azure Blob Storage with OAuth2? in Data Engineering

How to mount Azure Blob Storage with OAuth2?

jwilliam — Tue, 05 Jul 2022 14:22:57 GMT

We already know that we can mount Azure Data Lake Gen2 with OAuth2 using this:

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": "",
          "fs.azure.account.oauth2.client.secret": dbutils.secrets.get(scope="",key=""),
          "fs.azure.account.oauth2.client.endpoint": "https://login.microsoftonline.com//oauth2/token"}
 
# Optionally, you can add  to the source URI of your mount point.
dbutils.fs.mount(
  source = "abfss://@.dfs.core.windows.net/",
  mount_point = "/mnt/",
  extra_configs = configs)

However, when I used wasbs instead of abfss, it gives this error:

AzureException: shaded.databricks.org.apache.hadoop.fs.azure.AzureException: Unable to access container *** in account YYY.dfs.core.windows.net using anonymous credentials, and no credentials found for them  in the configuration.
Caused by: AzureException: Unable to access container *** in account YYY.dfs.core.windows.net using anonymous credentials, and no credentials found for them  in the configuration.

Is it possible to mount Azure Blob Storage (not ADLS2) by OAuth2?

Re: How to mount Azure Blob Storage with OAuth2?

Prabakar — Tue, 05 Jul 2022 15:03:14 GMT

OAuth is not supported on blob. We have a feature request DB-I-3479 for the same.

Re: How to mount Azure Blob Storage with OAuth2?

mathijs-fish — Wed, 14 Feb 2024 15:16:45 GMT

Is there any update on this feature request? OAuth still seems not to be working with Azure Blob Storage... Configuration works fine for ADLS gen 2, but for Azure Blob Storage still only SAS and Account key seems to be working.

Re: How to mount Azure Blob Storage with OAuth2?

dssatpute — Thu, 04 Jul 2024 06:36:10 GMT

Try replacing wasbs with abfss and dfs with blob in the URI, should work!