The bulkload SAS data execution (DATA Step or the SQL procedure) for a SAS/ACCESS Interface to Spark library to Azure Databricks can fail with the following error message:
ERROR: Execute error: Error running query: Failure to initialize configuration for storage account
accstoragedb2.dfs.core.windows.net: Invalid configuration value detected for fs.azure.account.key
Invalid configuration value detected for fs.azure.account.key
This error can occur when using a Serverless Compute service with the following Runtime versions:
There is an unresolved issue accessing the Azure storage account (ADLS Gen 2) from SAS in certain Databricks Runtime versions. This issue affects BULKLOAD and BULKUNLOAD operations of SAS/ACCESS Interface to Spark.
To work around this issue, do either of the following: