While using the Search tool to create a search filter, use the
is null or
is not null operators.
To perform a comparison to NULL in a query (via Data Explorer or a Scheduled 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.