Normally, we could use a syntax such as age Integer CHECK (age > 0) but Snowflake gives an Error.
What is the alternate for the “CHECK” constraint on a column value in Snowflake if possible?
CREATE OR REPLACE TABLE persons (person email VARCHAR(50) PRIMARY KEY,age INTEGER CHECK (age>0)