2

How to create a database in Databricks hive metastore with location adls and abfss (without mounting) ?

Something like this

create database if not exists adb_raw
location "abfss://container@stgaccount.dfs.core.windows.net/01_RAW/flat_files/"

will return error:

Error in SQL statement: 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)
Pirvu Georgian
  • 657
  • 1
  • 12
  • 37

1 Answers1

1

You need to provide configuration parameters for ADLS authentication in the SQL Admin console as it's described in the documentation.

enter image description here

enter image description here

enter image description here

Alex Ott
  • 80,552
  • 8
  • 87
  • 132