SSC-FDM-OR0008

Set Quantifier Not Supported

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.

This FDM is deprecated, please refer to SSC-EWI-OR0071 documentation

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 behave unexpectedly.

Example Code

Input Code:

SELECT location_id  FROM locations 
MINUS ALL 
SELECT location_id  FROM departments;

Output Code:

SELECT location_id  FROM
locations
--** SSC-FDM-OR0008 - QUANTIFIER 'ALL' NOT SUPPORTED FOR THIS SET OPERATOR, RESULTS MAY DIFFER **
MINUS
SELECT location_id  FROM
departments;

In Snowflake, the INTERSECT and MINUS/EXCEPT operators will always remove duplicate values.

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]

Last updated