Conditional and conversion functions

Preview BigQuery conditional expressions, conversion, hash, and bit functions in BigQuery compatibility mode.

Conditional expressions

BigQuery reference: Conversion functions.

Function	Support	Notes
`CAST`	Supported	Includes the `CAST(x AS type FORMAT '...')` form.
`PARSE_NUMERIC`	Supported
`PARSE_BIGNUMERIC`	With limitations	Parses to a 38-digit `DECIMAL`, which cannot hold the full `BIGNUMERIC` precision. See Data types.
`SAFE_CAST`	With limitations	Parsed, but the null-on-error behavior is not reproduced. A value that would make BigQuery return `NULL` raises an error instead.

The single-argument type functions cast their argument to the matching type.

SAFE.function(...) is accepted and calls the underlying function. Like SAFE_CAST, the null-on-error behavior is not reproduced.

BigQuery reference: Hash functions.

Function	Support
`MD5`	Supported
`FARM_FINGERPRINT`, `SHA1`, `SHA256`, `SHA512`	Not supported

BigQuery reference: Bit functions.

Function	Support
`BIT_COUNT`	Not supported

⌘I