FunctionsType Conversion

castas

Casts each input value to a target type provided by argument. Supported targets include text/string, int, float, bool, bytes, time, timestamp, uuid/timeuuid, varint, tinyint, and counter.

castas(…) → Dynamic

Kind · scalar

Casts each input value to a target type provided by argument. Supported targets include text/string, int, float, bool, bytes, time, timestamp, uuid/timeuuid, varint, tinyint, and counter.

Part of the Type Conversion family.

cast_as_varint

Casts values to arbitrary-precision integer text. Numeric inputs are stringified as integers, and textual inputs must contain only an optional sign and digits.

coalesce

Returns the first argument that is not NULL, scanning left to right. If all arguments are NULL, returns NULL. Commonly used to provide defaults or to normalize NULLs across multiple sources.