Snowflake now supports Inline and Out-of-Line Constraints

• From: Saqib | Date: Fri, 10 Apr 2026 12:45:54 +0000 #
  Subject: Snowflake now supports Inline and Out-of-Line Constraints

  Snowflake now supports Inline and Out-of-Line Constraints: CREATE or replace TABLE customers ( customer_id INTEGER NOT NULL, customer_name string NOT NULL, customeremail string check (REGEXPLIKE(customeremail, '^[A-Za-z0-9.%+-]+@[A-Za-z0-9.-]+\\.[A-Za-z]{2,}$') ), CONSTRAINT emailcheck check (JAROWINKLERSIMILARITY(customername, split(customeremail, '@')[0]) > 50) ENFORCED ); insert into customers values (999, 'Saqib Ali', 'saqib@domain.tld'); -- this will work insert into customers values (999, 'Saqib Ali', 'ali@domain.tld'); -- this will work insert into customers values (999, 'Saqib Ali', 'uroosa@domain.tld'); -- this will NOT work insert into customers values (999, 'Saqib Ali', 'saqib/domain.tld'); -- this will NOT work

  [ Reply ]