From my last post:
"we would like to avoid any extra processing/scripting to change the format for each column that would need to be done every time we open SAS EG to achieve the result, or a new library with views of the actual library, that would need to be maintained whenever something changes in the original library."
This is not the solution we are looking for, as to my understanding it requires the library of the views to be maintained and updated whenever the original Snowflake library changes. Even if it can be somewhat scripted and automated it is still not optimal.
Open to other suggestions or feedback on my idea about custom ODBC driver or middleware proxy.