This is a deprecated version of the SnowConvert documentation, please visit the official site .
A binary operation is not currently supported, a user defined function is added.
-- Unsupported operation: EXCEPT DISTINCT
SELECT someValue MULTISET EXCEPT DISTINCT multiset_except FROM customers_demo;
-- Unsupported operation: EXCEPT DISTINCT
/*** MSC-ERROR - MSCEWI3070 - BINARY OPERATION MULTISET EXCEPT IS NOT SUPPORTED ***/
PUBLIC.MULTISET_EXCEPT_UDF('someValue MULTISET EXCEPT DISTINCT multiset_except')
FROM PUBLIC.customers_demo;