To perform a comparison to NULL in your query, use the
SELECT * FROM table WHERE column IS NULL -- or -- SELECT * FROM table WHERE column IS NOT NULL
Note that using the usual equality operators
!=will return no results. This is because any equality operators involving a
NULL value will return
NULLthemselves, and thus be excluded from the result set.
For more information on how to handle
NULLvalues, consult Snowflake's documentation here.