When you bulk load with the BL_USE_ESCAPE=YES option in SAS/ACCESS Interface to Snowflake on SAS Viya 3.5, the load might fail with the following error:

ERROR: Function failed.
ERROR: The action stopped due to errors.

This error occurs due to faulty syntax that is generated for the underlying COPY INTO command. The faulty syntax is caused by a misinterpreted character in the default UTF-8 session encoding that is used by SAS Viya.

 

Workaround
If the data that is loaded requires the use of escape characters, no workaround is available. If the data does not require the use of escape characters, set the BL_USE_ESCAPE=NO option to prevent the error.

A hot fix is planned for this issue.