How to Remove a NOT NULL Constraint in Snowflake in Snowflake

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

alter table products
alter category drop not null;

From Snowflake query to chart to Slack in seconds

Get to answers faster, together, with PopSQL and Snowflake