I do not understand your description.
Did you define the Snowflake table using Snowflake commands? Show an example of creating a table in Snowflake.
What do mean by " the SAS data type is read as VARCHAR" ? SAS datasets only have two types of variables. Fixed length character strings and floating point numbers. All of various character types you are talking about that exist in other databases will have to be mapped into one of those two types to have the data appear as if it was a SAS dataset.
... View more