"Invalid UTF8 detected while decoding" error when using BASE64_DECODE_STRING() function
CAUSE: Snowflake is unable to decode the non - UTF8 data which is by design. SOLUTION: This error can be resolved by creating a UDF as mentioned below to detect the illegal characters causing the issue and to modify them.
Knowledge Base