Announcing our $3.4M seed round 🚀 Read more →

How to Add a NOT NULL Constraint in Snowflake in Snowflake

Not null constraints add another layer of validation to your data.

While you could perform this validation in your application layer, be aware that inconsistencies will happen: someone will forget to add the validation, or remove it by accident, or bypass validations in a console and insert nulls, etc. The only sure way is to enforce it in your column definition. If you're validating nulls on the database layer as well, you're protected.

To enforce NOT NULL for a column in Snowflake, use the ALTER TABLE <table_name> ALTER <column_name> command and restate the column definition, adding the NOT NULL attribute.

alter table products
alter category not null;

Ready for a modern SQL editor?