Snowflake’s information schema uses ‘YES’/‘NO’ strings (like is_iceberg). Surprisingly, these cast directly to booleans:

CAST('YES' AS BOOLEAN)  -- true
CAST('NO' AS BOOLEAN)   -- false

But string comparison fails: 'YES' = true returns false. Always cast first.