Use the below command to modify the column width in Redshift.
ALTER TABLE table_name ALTER COLUMN column_name TYPE new_data_type;
Example, below command resizes column1 to varchar(100).
ALTER TABLE table_name ALTER COLUMN column1 TYPE varchar(100);