Unsupported Data Types

Snowflake does not support the following data types:

Category

Type

Notes

LOB (Large Object)

BLOB

BINARY can be used instead; maximum of 8,388,608 bytes. For more information, see String & Binary Data Types.

CLOB

VARCHAR can be used instead; maximum of 16,777,216 bytes (for singlebyte). For more information, see String & Binary Data Types.

Other

ENUM

User-defined data types