String functions

Preview BigQuery string functions in BigQuery compatibility mode. Support is one of: Supported, With limitations, or Not supported. Supported means the function is available in BigQuery mode; where Firebolt’s behavior differs from BigQuery, it is noted.

Function	Support	Notes
`ASCII`	Supported
`BYTE_LENGTH`	Supported
`CHAR_LENGTH`	Supported
`CHARACTER_LENGTH`	Supported
`CONCAT`	Supported
`CONTAINS_SUBSTR`	Supported
`FORMAT`	With limitations	Available, but format-specifier behavior may differ from BigQuery.
`FROM_HEX`	Supported
`INSTR`	With limitations	Two-argument form only. Position and occurrence arguments are not supported.
`LEFT`	Supported
`LENGTH`	Supported
`LOWER`	Supported
`LPAD`	Supported
`LTRIM`	Supported
`OCTET_LENGTH`	Supported
`REGEXP_CONTAINS`	Supported	RE2 syntax.
`REGEXP_EXTRACT`	With limitations	Whole-match and single-capture-group forms. Position and occurrence arguments are not supported.
`REGEXP_EXTRACT_ALL`	Supported
`REGEXP_REPLACE`	Supported
`REPEAT`	Supported
`REPLACE`	Supported
`REVERSE`	Supported
`RIGHT`	Supported
`RPAD`	Supported
`RTRIM`	Supported
`SOUNDEX`	Supported
`SPLIT`	Supported	Delimiter defaults to a comma.
`STARTS_WITH`	Supported
`STRPOS`	Supported
`SUBSTR`	Supported
`SUBSTRING`	Supported
`TO_HEX`	Supported
`TRIM`	Supported
`UPPER`	Supported
`CHR`, `CODE_POINTS_TO_BYTES`, `CODE_POINTS_TO_STRING`, `COLLATE`, `EDIT_DISTANCE`, `ENDS_WITH`, `FROM_BASE32`, `FROM_BASE64`, `INITCAP`, `NORMALIZE`, `NORMALIZE_AND_CASEFOLD`, `REGEXP_INSTR`, `REGEXP_SUBSTR`, `SAFE_CONVERT_BYTES_TO_STRING`, `TO_BASE32`, `TO_BASE64`, `TO_CODE_POINTS`, `TRANSLATE`, `UNICODE`	Not supported

⌘I

Overview

Performance and Observability

Security

Self-Managed

Managed service

Guides

SQL reference

Compatibility modes

Release notes

API reference

Legal