Unsupported data types

Snowflake doesn’t support the following data types:

Category

Type

Notes

LOB (Large Object)

BLOB

BINARY can be used instead; maximum of 67108864 bytes. For more information, see String & binary data types.

CLOB

VARCHAR can be used instead; maximum of 134217728 bytes (for singlebyte). For more information, see String & binary data types.

Other

ENUM

User-defined data types