I am trying to create database with external location abfss but facing the below error.

AnalysisException: org.apache.hadoop.hive.ql.metadata.HiveException: MetaException(message:Got exception: shaded.databricks.azurebfs.org.apache.hadoop.fs.azurebfs.contracts.exceptions.KeyProviderException Failure to initialize configuration)

the command that I am using :

spark.sql("CREATE DATABASE IF NOT EXISTS test LOCATION 'abfss://<your-storage-account-name>@<your-storage-account-name>.dfs.core.windows.net/your/path'")

FYI, I am able to read data successfully though datalake in daatbricks