Bigquery Functions
Documentation Index
Fetch the complete documentation index at: /llms.txt
Use this file to discover all available pages before exploring further.
SDF is now a part of dbt Labs. Get live CTA previews, inline errors, and mesh support natively in the dbt platform. Learn more · Migrate to Fusion
asciifunction ascii(string) returns int64
byte_lengthfunction byte_length $1($1) returns int64
where $1 in (string, bytes)
char_lengthfunction char_length(string) returns int64
character_lengthfunction character_length(string) returns int64
chrfunction chr(int64) returns string
code_points_to_bytesfunction code_points_to_bytes(array<int64>) returns bytes
code_points_to_stringfunction code_points_to_string(array<int64>) returns string
collatefunction collate(string, string) returns string
concatfunction concat(bytes, ...) returns bytes
function concat(...) returns string
contains_substrfunction contains_substr $1($1, string) returns bool
where $1 in (string, bigint, bool, timestamp, time, date, datetime)
function contains_substr $1(array<$1>, string) returns bool
where $1 in (string, bigint, bool, timestamp, time, date, datetime)
ends_withfunction ends_with $1($1, string) returns bool
where $1 in (string, bytes)
formatfunction format(string) returns string
function format(string, $1) returns string
function format(string, $1, $2) returns string
function format(string, $1, $2, $3) returns string
function format(string, $1, $2, $3, $4) returns string
function format(string, $1, $2, $3, $4, $5) returns string
from_base32function from_base32(string) returns bytes
from_base64function from_base64(string) returns bytes
from_hexfunction from_hex(string) returns bytes
initcapfunction initcap(string) returns string
function initcap(string, string) returns string
instrfunction instr(string, string) returns int64
function instr(string, string, int64) returns int64
function instr(string, string, int64, int64) returns int64
leftfunction left $1($1, int64) returns $1
where $1 in (string, bytes)
lengthfunction length $1($1) returns int64
where $1 in (string, bytes)
lowerfunction lower(string) returns string
lpadfunction lpad(string, int64, string) returns string
function lpad(string, int64) returns string
ltrimfunction ltrim(string) returns string
function ltrim(string, string) returns string
normalize_and_casefoldfunction normalize_and_casefold(string) returns string
function normalize_and_casefold(string, normalization_mode string) returns string
where normalization_mode in (nfc, nfd, nfkc, nfkd)
octet_lengthfunction octet_length $1($1) returns int64
where $1 in (string, bytes)
regexp_containsfunction regexp_contains $1($1, string) returns bool
where $1 in (string, bytes)
regexp_extractfunction regexp_extract $1($1, string) returns $1
where $1 in (string, bytes)
function regexp_extract $1($1, string, int64) returns $1
where $1 in (string, bytes)
function regexp_extract $1($1, string, int64, int64) returns $1
where $1 in (string, bytes)
regexp_extract_allfunction regexp_extract_all $1($1, string) returns array<$1>
where $1 in (string, bytes)
regexp_instrfunction regexp_instr $1($1, $1) returns int64
where $1 in (string, bytes)
function regexp_instr $1($1, $1, int64) returns int64
where $1 in (string, bytes)
function regexp_instr $1($1, $1, int64, int64) returns int64
where $1 in (string, bytes)
function regexp_instr $1($1, $1, int64, int64, int64) returns int64
where $1 in (string, bytes)
regexp_replacefunction regexp_replace $1($1, string, string) returns $1
where $1 in (string, bytes)
regexp_substrfunction regexp_substr $1($1, string) returns $1
where $1 in (string, bytes)
function regexp_substr $1($1, string, int64) returns $1
where $1 in (string, bytes)
function regexp_substr $1($1, string, int64, int64) returns $1
where $1 in (string, bytes)
repeatfunction repeat $1($1, int64) returns $1
where $1 in (string, bytes)
replacefunction replace $1($1, string, string) returns $1
where $1 in (string, bytes)
reversefunction reverse $1($1) returns $1
where $1 in (string, bytes)
rightfunction right $1($1, int64) returns $1
where $1 in (string, bytes)
rpadfunction rpad(string, int64, string) returns string
function rpad(string, int64) returns string
rtrimfunction rtrim(string) returns string
function rtrim(string, string) returns string
safe_convert_bytes_to_stringfunction safe_convert_bytes_to_string(bytes) returns string
soundexfunction soundex(string) returns string
splitfunction split $1($1) returns array<$1>
where $1 in (string, bytes)
function split $1($1, $1) returns array<$1>
where $1 in (string, bytes)
starts_withfunction starts_with(string, string) returns bool
substrfunction substr(string, int64) returns string
function substr(string, int64, int64) returns string
substringfunction substring $1($1, int64) returns $1
where $1 in (string, bytes)
function substring $1($1, int64, int64) returns $1
where $1 in (string, bytes)
to_base32function to_base32(bytes) returns string
to_base64function to_base64(bytes) returns string
to_code_pointsfunction to_code_points $1($1) returns array<int64>
where $1 in (string, bytes)
to_hexfunction to_hex(bytes) returns string
translatefunction translate $1($1, $1, $1) returns $1
where $1 in (string, bytes)
trimfunction trim(string) returns string
function trim(string, string) returns string
unicodefunction unicode(string) returns int64
upperfunction upper(string) returns string