Cara ganti data type di Redshift

alter table <schema-name>.<table-name> add column <column-name>_new <new-data-type>;

update <schema-name>.<table-name> set <column-name>_new=<column-name>;

alter table <schema-name>.<table-name> drop column <column-name>;

alter table <schema-name>.<table-name> rename column <column-name>_new to <column-name>;