Error Message when querying Snowflake

[yp2609]

There is a weird issue: I pull some dataset from Snowflake (a type of online Data Source), which has a variable that has string values that are "too long and would be truncated". Initially, error message exists in Base SAS. After the technician did some fixes on Snowflake by masking the variable, this error message disappears from Base SAS, so the program runs smoothly on Base SAS, but this error message appears in SAS Enterprise Guide again when I try to run in EG. 

The reason that I want to run the programs on my Virtual Machine on EG is because I ran out of memory space on my laptop when running from Base SAS.

[SASKiwi]

Looks like you are reading all columns from your Snowflake table CLD95_TRANSACTION_MM. How many columns are there? If suggest you try just extracting one column from the table as a test. Do you get the same error? If not try adding columns one at a time until you identify the column giving the error.

[LinusH]

Could this be caused by VARIANT data types?

Check for lengths in all columns, do any of them exceed 32K?

Also, try implicit pass-through (your query should work with the same performance, explicit pass through shouldn't be necessary here).