Ryan_Chynoweth
Databricks Employee
Databricks Employee

Is the table you are working with in the Delta format? The table commands (i.e. Alter) do not work for all storage formats.

For example if I run the following commands then I can alter a table. Note - there is no data in the table but the table exists and I can alter the table.

create table if not exists add_col_test  (
col_one integer, 
col_two integer
)
USING DELTA 
; 
 
describe add_col_test; 
 
alter table add_col_test ADD columns (col_three boolean);
 
describe add_col_test;