Create an empty delta lake table in databricks with schema available

Asked Jun 16 '23 at 09:11

Active Jun 16 '23 at 10:00

Viewed 126 times

I have the schema defined. How can i crate an empty delta lake table in databricks azure. I see this command with no schema defined but I get error as though I have the all necessary permission.I just created the schema. Can someone get me the command if lets say I have schema defined in a schema variable like this:

schema = "authenticationMechanism STRING,authenticationMechanismId STRING"

Error for below code:

Operation failed: "Server failed to authenticate the request. Make sure the value of Authorization header is formed correctly including the signature.", 403,

CREATE TABLE IF NOT EXISTS
main.deltalake_db.test_delta

edited Jun 16 '23 at 10:00

Alex Ott

80,552
8
87
132

asked Jun 16 '23 at 09:11

ZZZSharePoint

1,163
1
19
54

What are you using to execute this command? – Alex Ott Jun 16 '23 at 09:59
%sql .. if thats what you meant? – ZZZSharePoint Jun 16 '23 at 10:28
just to be clear the error message you see is for "Create Table...." command – ZZZSharePoint Jun 16 '23 at 10:29
If you are creating empty delta lake table in SQL notebook it won't give authentication error which you have provided. Could you please give brief explanation about what you have done before creating table? – Bhavani Jun 16 '23 at 11:02
I enabled the Unity Catalog, created a metastore, ran command to create a schema and now I am trying to create a table insdie the scema created – ZZZSharePoint Jun 16 '23 at 12:48
ran this command before that" %sql CREATE SCHEMA IF NOT EXISTS main.deltalake_db" – ZZZSharePoint Jun 16 '23 at 12:50

Create an empty delta lake table in databricks with schema available

0 Answers0