Enum

This data type isn't supported at ingest. It is only supported at query time and to create Copy Data Sources or Materialized View Data Sources.

Enumerated type consisting of named values.

Named values can be declared as 'string' = integer pairs or 'string' names . Only numbers are stored, but supports operations with the values through their names.

Supported:

  • 8-bit Enum. It can contain up to 256 values enumerated in the [-128, 127] range.
  • 16-bit Enum. It can contain up to 65536 values enumerated in the [-32768, 32767] range.

The type of Enum is chosen automatically when data is inserted. You can also use Enum8 or Enum16 types to be sure in the size of storage.

Updated