cancel
Showing results for 
Search instead for 
Did you mean: 
Data Governance
Join discussions on data governance practices, compliance, and security within the Databricks Community. Exchange strategies and insights to ensure data integrity and regulatory compliance.
cancel
Showing results for 
Search instead for 
Did you mean: 

How this is possible? access error in storage, after selecting data from an delta IN THE STORAGE

Guilherme
New Contributor

Hi people, i`m using databricks Runtime 11.2 - Clusters Standard_F4 with Unity Catalog enabled and the service principals working,

I literally perform an select in two delta tables that is in the storage X,

the display() works, if i try to write an new delta table it works,

but when i perform an union() in these dataframes, the result dataframe generated give`s the error "Failure to initialize configurationInvalid configuration value detected for fs.azure.account.key" when i try an simple display, so, how the **** this is possible?

traceback

Py4JJavaError: An error occurred while calling o847.showString.
: Failure to initialize configurationInvalid configuration value detected for fs.azure.account.key
	at shaded.databricks.azurebfs.org.apache.hadoop.fs.azurebfs.services.SimpleKeyProvider.getStorageAccountKey(SimpleKeyProvider.java:51)
	at shaded.databricks.azurebfs.org.apache.hadoop.fs.azurebfs.AbfsConfiguration.getStorageAccountKey(AbfsConfiguration.java:593)
	at shaded.databricks.azurebfs.org.apache.hadoop.fs.azurebfs.AzureBlobFileSystemStore.initializeClient(AzureBlobFileSystemStore.java:1847)
	at shaded.databricks.azurebfs.org.apache.hadoop.fs.azurebfs.AzureBlobFileSystemStore.(AzureBlobFileSystemStore.java:227)
	at shaded.databricks.azurebfs.org.apache.hadoop.fs.azurebfs.AzureBlobFileSystem.initialize(AzureBlobFileSystem.java:142)
	at org.apache.hadoop.fs.FileSystem.createFileSystem(FileSystem.java:3469)
	at org.apache.hadoop.fs.FileSystem.get(FileSystem.java:537)
	at org.apache.hadoop.fs.Path.getFileSystem(Path.java:365)
	at com.databricks.unity.SAM.createDelegate(SAM.scala:126)
	at com.databricks.unity.SAM.createDelegate$(SAM.scala:119)
	at com.databricks.unity.ClusterDefaultSAM$.createDelegate(SAM.scala:136)
	at com.databricks.sql.acl.fs.CredentialScopeFileSystem.createDelegate(CredentialScopeFileSystem.scala:80)
	at com.databricks.sql.acl.fs.CredentialScopeFileSystem.$anonfun$setDelegates$1(CredentialScopeFileSystem.scala:133)
	at com.databricks.sql.acl.fs.Lazy.apply(DelegatingFileSystem.scala:286)
	at com.databricks.sql.acl.fs.CredentialScopeFileSystem.getReadDelegate(CredentialScopeFileSystem.scala:108)
	at com.databricks.backend.daemon.driver.DatabricksFileSystemHelper$.unwrapFileSystem(DatabricksFileSystemHelper.scala:52)
	at com.databricks.tahoe.store.DelegatingLogStore.getDelegate(DelegatingLogStore.scala:179)
	at com.databricks.tahoe.store.DelegatingLogStore.$anonfun$listFromUnsafe$1(DelegatingLogStore.scala:278)
	at com.databricks.spark.util.FrameProfiler$.record(FrameProfiler.scala:80)

2 REPLIES 2

jose_gonzalez
Moderator
Moderator

Hi,

The following article will help you to resolve this error message https://medium.com/@kyle.hale/troubleshooting-invalid-configuration-value-detected-for-fs-azure-acco...

Anonymous
Not applicable

Hi @Guilherme Cesar​ 

Hope everything is going great.

Just wanted to check in if you were able to resolve your issue. If yes, would you be happy to mark an answer as best so that other members can find the solution more quickly? If not, please tell us so we can help you. 

Cheers!

Join 100K+ Data Experts: Register Now & Grow with Us!

Excited to expand your horizons with us? Click here to Register and begin your journey to success!

Already a member? Login and join your local regional user group! If there isn’t one near you, fill out this form and we’ll create one for you to join!