Learning Google BigQuery

Supported data types

Here is a table that shows the various supported data types:

Type	Size in bytes	Name (standard SQL)	Description
Integer	8	INT64	Numeric value with no fraction
Floating point	8	FLOAT64	Double-precision decimal value
Boolean	Unset	BOOL	True or false value
String	Unset	STRING	Character data of variable length
Bytes	Unset	BYTES	Variable-length binary
Date	Unset	DATE	Logical calendar date
Datetime	Unset	DATETIME	Year, month, day, hour, minute, second, and subsecond
Time	Unset	TIME	A time, independent of a specific date
Timestamp	Unset	TIMESTAMP	Time with a microsecond precision
Array	Unset	ARRAY	An ordered list of ...