Assuming that BULKUPLOAD in the subject is a typo for BULKUNLOAD.
I am a little confused, and probably due to ignorance.
SAS doc ties these options to LIBNAME statement.
I guess they could work wit an PROC SQL CONNECT TO as well.
But code within an excute block is usually executed only in the target DBMS, so I would assume that your SAS specific options shouldn't affect the execution.
It would help to see more of the code inside the EXECUTE block, but perhaps not all column names...
Why are you using CONNECT TO? What happens if you try to use a libref instead? Then you could use these option to track Snowflake behaviour:
options msglevel=i sastrace=',,,d' sastraceloc=saslog nostsuffix;
If there's any unclarity in the doc or connection behaviour, you might want to try contacting SAS tech support.
... View more