Data types

Preview BigQuery data types and their support in BigQuery compatibility mode. A supported BigQuery type name maps to the Firebolt type that holds the same values, so you can write BigQuery type names in casts and column definitions.

BigQuery type	Support	Notes
`INT64`	Supported	Maps to Firebolt `BIGINT`.
`NUMERIC`	Supported	Maps to `DECIMAL(38, 9)`, which covers the full BigQuery `NUMERIC` range and scale. See NUMERIC.
`BIGNUMERIC`	Not supported	`BIGNUMERIC` needs up to 76 digits of precision. Firebolt `DECIMAL` is limited to 38 digits, so `BIGNUMERIC` values are not representable.
`FLOAT64`	Supported	Maps to `DOUBLE PRECISION`.
`BOOL`	Supported	Maps to `BOOLEAN`.
`STRING`	Supported	Maps to `TEXT`. UTF-8.
`BYTES`	Supported	Maps to `BYTEA`. See BYTEA.
`DATE`	Supported	See DATE.
`DATETIME`	Supported	Timezone-naive timestamp. Maps to Firebolt `TIMESTAMP`. See TIMESTAMP.
`TIMESTAMP`	Supported	Absolute instant. Maps to `TIMESTAMPTZ`. See TIMESTAMPTZ.
`TIME`	With limitations	No native `TIME` type. Emulated as a timezone-naive timestamp on a placeholder date, so values format and compare correctly but carry a placeholder date component.
`INTERVAL`	With limitations	Usable only as a constant or expression operand, for example `date + INTERVAL 5 DAY`. You cannot declare an `INTERVAL` column or store `INTERVAL` values in a table.
`GEOGRAPHY`	Supported	See GEOGRAPHY. A subset of geography functions is available; see Geography functions.
`JSON`	Supported	See JSON and JSON functions.
`ARRAY`	Supported	Element type is mapped recursively. Firebolt allows `NULL` elements, which BigQuery does not.
`STRUCT`	Supported	See STRUCT.
`RANGE`	Not supported	Firebolt has no `RANGE` type.

Literals

Literal	Example	Notes
Triple-quoted string	`"""line one\nline two"""`	`'''...'''` is also accepted.
Raw string	`r"C:\path"`	Backslashes are literal.
Byte string	`b"abc"`, `rb"\x00"`	Maps to a `BYTEA` value.
Typed array	`ARRAY<INT64>[1, 2, 3]`	Element type is carried through.
Struct	`STRUCT(1 AS a, 'x' AS b)`	Field names come from `AS` aliases or declared field names.
Interval	`INTERVAL 5 DAY`	A unit is required. Constant only.

A positional struct cast rebuilds field names from the target type, so CAST(STRUCT(1, 2) AS STRUCT<a INT64, b INT64>) names the fields a and b by position.

Overview

Performance and Observability

Security

Self-Managed

Managed service

Guides

SQL reference

Compatibility modes

Release notes

API reference

Legal

Literals

​Literals

Literals