How/where can I set credentials for DataBricks SQL to create a external table.

Harry_L
New Contributor II

I've triend this code in Databricks SQL

create table people_db.GLAccount
   USING PARQUET
   LOCATION "abfss://datamesh@dlseu2dtaedwetldtlak9.dfs.core.windows.net/PricingAnalysis/rdv_60_134.vGLAccount.parquet"

But I'm getting a "Invalid configuration value detected for fs.azure.account.key", what could be normal as the system doesn't know what credentials to use, but I can't find an example on the WITH CREDENTIAL and have no idea how to code it.

 

I know this will be a service-account and later we can specify on Databricks users if they can access this table.

-werners-
Esteemed Contributor III

you can define 'data access configuration' in the admin panel.

go to SQL warehouse settings -> Data Access configuration

https://learn.microsoft.com/en-us/azure/databricks/sql/admin/data-access-configuration

View solution in original post

Harry_L
New Contributor II

Ok, I was searching this in the SQL Datawarehouse itself, but it is a Workspace Setting, Great !!!