cancel
Showing results for 
Search instead for 
Did you mean: 
Warehousing & Analytics
Engage in discussions on data warehousing, analytics, and BI solutions within the Databricks Community. Share insights, tips, and best practices for leveraging data for informed decision-making.
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

1 ACCEPTED SOLUTION

Accepted Solutions

-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

2 REPLIES 2

-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

Harry_L
New Contributor II

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

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you won’t want to miss the chance to attend and share knowledge.

If there isn’t a group near you, start one and help create a community that brings people together.

Request a New Group