i am trying to insert into a table with an identity column using a select query.

However, if i include the identity column or ignore the identity column in my insert it throws errors. Is thee a way to insert into select * from a table if the insert table has an identity column?

%sql

CREATE OR REPLACE TABLE demo (

 id BIGINT GENERATED ALWAYS AS IDENTITY,

 product_type STRING,

 sales BIGINT

);

%sql

insert into demo_test

SELECT id,product_type, sales from demo

AnalysisException: Providing values for GENERATED ALWAYS AS IDENTITY column id is not supported.

%sql

insert into demo_test

SELECT product_type, sales from demo

nalysisException: Cannot write to 'spark_catalog.default.demo_test', not enough data columns; target table has 3 column(s) but the inserted data has 2 column(s)