how to modify data type of a column explicitly via DBSQL

xwen — Tue, 10 Sep 2024 10:01:42 GMT

is there a SQL equivalent of overwriteSchema ?https://docs.databricks.com/en/delta/update-schema.html#explicitly-update-schema-to-change-column-type-or-name

Re: how to modify data type of a column explicitly via DBSQL

xwen — Tue, 10 Sep 2024 14:41:08 GMT

In place schema adjustment =>
Then ALTER TABLE XXX ADD/DROP COLUMN XXX INT
Example

create table test (id int, first_name string, last_name string ); insert into test values (1, 'john', 'smith'); alter table test add column age int; select * from test

Create a new table with an adjusted Schema =>
Then CTAS should do the trickCREATE OR REPLACE TABLE [new_table] AS ( SELECT * FROM OLD_TABLE ... )

topic Re: how to modify data type of a column explicitly via DBSQL in Warehousing & Analytics

how to modify data type of a column explicitly via DBSQL

Re: how to modify data type of a column explicitly via DBSQL