rename table snowflake

ALTER TABLE EMP_HIST RENAME TO EMPLOYEE_HISTORY;

-- syntax
alter table table_name rename column old_name to new_name;

-- rename product_category column in products table
alter table products rename column products_category to products;