Decodable data types

BINARY(n)

Fixed length binary string.

VARBINARY(n)

Variable length binary string with a max length of n.

BYTES

Synonym for VARBINARY(2147483647).

ARRAY<T>

An array of a type T, and a maximum size of 2^31-1.

T ARRAY

Synonym for ARRAY<T>.

MAP<K,V>

An associative array with keys of type K and values of type V. Both K and V support any type. Each unique key can only have one value.

ROW<name type ['description'], …​>

A structure of named fields. name is the field name, type is its type, and description is an optional text description of the field. Field definitions can be repeated as many times as necessary.

DATE

A date containing the year, month, and day.

TIME(p)

A time without a timezone. If specified, p indicates the precision of fractional seconds up to nanosecond-level precision. Doesn’t support leap second adjustments. Values must be within the range of 00:00:00 to 23:59:59.

TIMESTAMP(p) [WITHOUT TIME ZONE]

A date and time without a timezone. As with TIME, p specifies the fractional second precision, if it’s provided. Values must be within the range of 0000-01-01 00:00:00 to 9999-12-31 23:59:59.999999999.

TIMESTAMP(p) with LOCAL TIME ZONE

A date and time in UTC. As with TIME, p specifies the fractional second precision. If no precision is specified, p is equal to 6. Values must be in the range of 0000-01-01 00:00:00.000000000 +14:59 to 9999-12-31 23:59:59.999999999 -14:59.

A synonym for TIMESTAMP_LTZ.

DECIMAL(p,s)

Exact numeric type with a fixed precision (number of digits) of p and a scale (number of digits to the right of the decimal) of s.

p must be in the range of 1 to 31, inclusive. If omitted, it defaults to 10.

s must be in the range of 0 to p, inclusive. If s is specified, p must also be specified. When omitted, it defaults to 0.

DEC(p,s)

Synonym for DECIMAL(p,s).

NUMERIC(p,s)

Synonym for DECIMAL(p,s).

TINYINT

A 1 byte signed integer.

SMALLINT

A 2 byte signed integer.

INT

A 4 byte signed integer.

BIGINT

An 8 byte signed integer.

FLOAT

An approximate floating point integer.

DOUBLE parameters

Synonym for FLOAT.

BOOLEAN

A true / false value.

INTERVAL

A data type for a group of year to month or day to month interval types.

MULTISET

CHAR(n)

Fixed length character string.

VARCHAR(n)

Variable length character string with a max length of n.

STRING

Synonym for VARCHAR(2147483647).