topic How/where can I set credentials for DataBricks SQL to create a external table. in Warehousing & Analytics

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

Harry_L — Thu, 20 Mar 2025 17:24:59 GMT

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.

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

-werners- — Thu, 25 May 2023 06:58:49 GMT

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

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

Harry_L — Thu, 25 May 2023 07:02:28 GMT

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