snowflake add column code example

Example: snowflake add column to table

alter table products
add brand_id smallint;