cancel
Showing results for 
Search instead for 
Did you mean: 
Data Governance
cancel
Showing results for 
Search instead for 
Did you mean: 

Unity catalog set up - unable to create table

AnthonyDang
New Contributor II

Hi all, I've gone through the deployment guide to set up Unity catalog as outlined in https://learn.microsoft.com/en-us/azure/databricks/data-governance/unity-catalog/get-started.

I tried creating a table once I had it set up with the below command.

CREATE TABLE main.default.department
(
  deptcode   INT,
  deptname  STRING,
  location  STRING
);
 
INSERT INTO main.default.department VALUES
  (10, 'FINANCE', 'EDINBURGH');

and the following error msg is returned

Operation failed: "Server failed to authenticate the request. Make sure the value of Authorization header is formed correctly including the signature.", 403, GET, https://storageaccount.dfs.core.windows.net/unitycatalog?upn=false&resource=filesystem&maxResults=50... AuthenticationFailed, "Server failed to authenticate the request. Make sure the value of Authorization header is formed correctly including the signature. RequestId:

Things I have tried:

  1. Cluster settings
    1. single and shared cluster access modes
  2. granted permissions/privileges on account admin, metastore, catalog, schema, storage credential, azure storage account

Please advise any ideas why or if there's anything I can try further. Thank you.

1 ACCEPTED SOLUTION

Accepted Solutions

Avnish_Jain
Moderator
Moderator

Check to see if you have enabled the Hierarchical Namespace setting for the ADLS Gen 2.0 configuration.

View solution in original post

2 REPLIES 2

Avnish_Jain
Moderator
Moderator

Check to see if you have enabled the Hierarchical Namespace setting for the ADLS Gen 2.0 configuration.

AnthonyDang
New Contributor II

Legend! This solved it for me. I kept checking permissioning issues but I missed a key step in setting up the storage account in the following guide: https://learn.microsoft.com/en-us/azure/storage/blobs/create-data-lake-storage-account.

Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.