Syntax to add computed column in snowflake table:
ALTER TABLE "TABLE NAME" AS "COLUMN Name" "Datatype" AS "EXPRESSION"