We can easily rename columns in Snowflake using the alter table ... raname column
command. For example:
alter table "DB_NAME"."SCHEMA_NAME"."TABLE_NAME" rename column old_column_name to new_column_name
Bear in mind that we can rename a single column per command. Thus, if we want to rename three columns, we have to run:
alter table my_table rename column col_old_1 to col_new_1 ;
alter table my_table rename column col_old_2 to col_new_2 ;
alter table my_table rename column col_old_3 to col_new_3 ;