When you use the Snowflake connector, you can access data of most data types from Snowflake.
The following are known exceptions:
Semi-structured data types are not supported, such as VARIANT, OBJECT, ARRAY.
Time and date types with time zone information are not supported, such as TIMESTAMP_LTZ, TIMESTAMP_TZ.
Interval type data is not supported.
See also: