NULL

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentation

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected].

Thank you for your understanding.

Description

The null condition tests for nulls, when a value is missing or unknown. (Redshift SQL Language Reference NULL condition)

Grammar Syntax

expression IS [ NOT ] NULL

This function is fully supported by Snowflake.

Sample Source Patterns

Setup Table

Redshift

CREATE TABLE NullTest (
    id INTEGER,
    name VARCHAR(30),
    lastname VARCHAR(30)
);

INSERT INTO NullTest (id, name, lastname) VALUES 
 (1, 'name1', 'lastname1'),
 (2, 'name2', NULL),
 (3, 'name3', 'lastname3'),
 (4, 'name4', NULL);

Snowflake

Input Code:

Redshift

IN -> Redshift_01.sql

SELECT * FROM nulltest
WHERE lastname IS NULL;

Results

Output Code:

Snowflake

OUT -> Redshift_01.sql

SELECT * FROM
    nulltest
WHERE lastname IS NULL;

Results

Known Issues

No issues were found.

Related EWIs

No related EWIs.