NULL

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

CREATE TABLE NullTest (
    id INTEGER,
    name VARCHAR(30),
    lastname VARCHAR(30)
)
COMMENT = '{ "origin": "sf_sc", "name": "snowconvert", "version": {  "major": 0,  "minor": 0,  "patch": "0" }, "attributes": {  "component": "redshift",  "convertedOn": "01/08/2025",  "domain": "test" }}';

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

Input Code:

Redshift

IN -> Redshift_01.sql

SELECT * FROM nulltest
WHERE lastname IS NULL;

Results

ID	NAME	LASTNAME
2	name2	NULL
4	name4	NULL

Output Code:

Snowflake

OUT -> Redshift_01.sql

SELECT * FROM
    nulltest
WHERE lastname IS NULL;

Results

ID	NAME	LASTNAME
2	name2	NULL
4	name4	NULL

Known Issues

No issues were found.

Related EWIs

No related EWIs.