how to add column to snowflake tables code example

Example: snowflake add column to table

alter table products
add brand_id smallint;