Databricks SQL CREATE TABLE ParseException

[Sid0610]

I am trying to use the following code to create a deltatable

%sql

CREATE TABLE rectangles(a INT, b INT, area INT GENERATED ALWAYS AS IDENTITY (START WITH 1, STEP BY 1))

I don't know why but I am always getting the ParseException error.

I tried all other combinations as well such as - CREATE TABLE rectangles(a INT, b INT, area INT GENERATED ALWAYS AS IDENTITY (1, 1)), etc

Error:

ParseException:

extraneous input 'IDENTITY' expecting '('(line 1, pos 67)

[fabio2352 · Accepted solution]

HI, you can see this post. I belive can help you.

https://www.databricks.com/blog/2022/08/08/identity-columns-to-generate-surrogate-keys-are-now-avail...

[Priyag1]

What is parse exception?

[emiratesevisaon]

How can we use SQL for my website emiratesevisaonline.com backend date?