MSCEWI3071

Set Quantifier Not Supported

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

Severity

Low

Description

Quantifier 'all' is not supported in Snowflake. The modifier is removed from the source code and a warning is added, the resulting code may behaves unexpectedly.

Example Code

Input Code:

SELECT location_id  FROM locations 
MINUS ALL 
SELECT location_id  FROM departments;

Output Code:

SELECT location_id  FROM PUBLIC.locations
/*** MSC-WARNING - MSCEWI3071 - QUANTIFIER 'ALL' REMOVED FROM THE SOURCE CODE, IT MAY BEHAVES UNEXPECTEDLY ***/
MINUS
SELECT location_id  FROM PUBLIC.departments;

Recommendations

• Check alternatives in Snowflake to emulate the functionality of the "all" quantifier.

• If you need more support, you can email us at [email protected]