- 11007 Views
- 3 replies
- 4 kudos
insert into a table with an identity column fails
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 t...
- 11007 Views
- 3 replies
- 4 kudos
Latest Reply
- 4 kudos
Hi, Specify insert columns as below %sqlINSERT INTO demo_test (product_type, sales)SELECT product_type, sales FROM demo
- 4 kudos
- 2088 Views
- 3 replies
- 2 kudos
I'm trying to create a table in databricks sql using widget values in table naming. The idea is that the users could select / enter table naming values as they create their tables. This can be done in notebooks but I can't get the syntax working in DBSQL.
Here's an example: CREATE OR REPLACE TABLE {{workspace}}.{{TableNameFirstPart}}_{{TableNameEndPart}} AS SELECT ...
- 2088 Views
- 3 replies
- 2 kudos
Latest Reply
- 2 kudos
Have you figured out what the problem was? Could the issue be permission related?
- 2 kudos