Enum StandardSQLTypeName (2.35.0)

public enum StandardSQLTypeName extends Enum<StandardSQLTypeName>

A type used in standard SQL contexts. For example, these types are used in queries with query parameters, which requires usage of standard SQL. See Also: https://cloud.google.com/bigquery/docs/reference/standard-sql/data-types

Static Fields

NameDescription
ARRAY

Ordered list of zero or more elements of any non-array type.

BIGNUMERIC

A decimal value with 76+ digits of precision (the 77th digit is partial) and 38 digits of scale

BOOL

A Boolean value (true or false).

BYTES

Variable-length binary data.

DATE

Represents a logical calendar date. Values range between the years 1 and 9999, inclusive.

DATETIME

Represents a year, month, day, hour, minute, second, and subsecond (microsecond precision).

FLOAT64

A 64-bit IEEE binary floating-point value.

GEOGRAPHY

Represents a set of geographic points, represented as a Well Known Text (WKT) string.

INT64

A 64-bit signed integer value.

INTERVAL

Represents duration or amount of time.

JSON

Represents JSON data.

NUMERIC

A decimal value with 38 digits of precision and 9 digits of scale.

STRING

Variable-length character (Unicode) data.

STRUCT

Container of ordered fields each with a type (required) and field name (optional).

TIME

Represents a time, independent of a specific date, to microsecond precision.

TIMESTAMP

Represents an absolute point in time, with microsecond precision. Values range between the years 1 and 9999, inclusive.

Static Methods

NameDescription
valueOf(String name)
values()