# Supported BigQuery functions in dbt Fusion

Fusion can validate that your BigQuery function arguments match expected types directly in dbt platform, the CLI, or using the dbt VS Code extension. To enable this, run `dbt login` and set [`static_analysis: strict`](../../docs/build/about-static-analysis.md?version=2.0) in your project configuration.

The following table lists *every* BigQuery built-in function and its typechecking support status. Use the table's search and filters to find specific functions.

Refreshed weekly

This table is updated weekly from the [BigQuery SQL function reference](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/functions-all) and cross-referenced with Fusion's support list. If you spot a discrepancy, we'd love for you to contribute and [open an issue](https://github.com/dbt-labs/dbt-core/issues) in the dbt Core repository!

| Function                                                                                                                                                     | Category | Fusion typechecking |
| ------------------------------------------------------------------------------------------------------------------------------------------------------------ | -------- | ------------------- |
| [ABS](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#abs)                                                         | Built-in | ✓                   |
| [ACOS](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#acos)                                                       | Built-in | ✓                   |
| [ACOSH](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#acosh)                                                     | Built-in | ✓                   |
| [AEAD.DECRYPT\_BYTES](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/aead_encryption_functions#aeaddecrypt_bytes)                        | Built-in | ✓                   |
| [AEAD.DECRYPT\_STRING](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/aead_encryption_functions#aeaddecrypt_string)                      | Built-in | ✓                   |
| [AEAD.ENCRYPT](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/aead_encryption_functions#aeadencrypt)                                     | Built-in | ✓                   |
| [AGG](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/aggregate_functions#agg)                                                            | Built-in | —                   |
| [ANY\_VALUE](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/aggregate_functions#any_value)                                               | Built-in | ✓                   |
| [APPENDS](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/time-series-functions#appends)                                                  | Built-in | —                   |
| [APPROX\_COUNT\_DISTINCT](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/approximate_aggregate_functions#approx_count_distinct)          | Built-in | ✓                   |
| [APPROX\_QUANTILES](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/approximate_aggregate_functions#approx_quantiles)                     | Built-in | ✓                   |
| [APPROX\_TOP\_COUNT](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/approximate_aggregate_functions#approx_top_count)                    | Built-in | ✓                   |
| [APPROX\_TOP\_SUM](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/approximate_aggregate_functions#approx_top_sum)                        | Built-in | ✓                   |
| [ARRAY](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/array_functions#array)                                                            | Built-in | —                   |
| [ARRAY\_AGG](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/aggregate_functions#array_agg)                                               | Built-in | ✓                   |
| [ARRAY\_CONCAT](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/array_functions#array_concat)                                             | Built-in | ✓                   |
| [ARRAY\_CONCAT\_AGG](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/aggregate_functions#array_concat_agg)                                | Built-in | ✓                   |
| [ARRAY\_FIRST](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/array_functions#array_first)                                               | Built-in | ✓                   |
| [ARRAY\_LAST](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/array_functions#array_last)                                                 | Built-in | ✓                   |
| [ARRAY\_LENGTH](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/array_functions#array_length)                                             | Built-in | ✓                   |
| [ARRAY\_REVERSE](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/array_functions#array_reverse)                                           | Built-in | ✓                   |
| [ARRAY\_SLICE](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/array_functions#array_slice)                                               | Built-in | ✓                   |
| [ARRAY\_TO\_STRING](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/array_functions#array_to_string)                                      | Built-in | ✓                   |
| [ASCII](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#ascii)                                                           | Built-in | ✓                   |
| [ASIN](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#asin)                                                       | Built-in | ✓                   |
| [ASINH](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#asinh)                                                     | Built-in | ✓                   |
| [ATAN](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#atan)                                                       | Built-in | ✓                   |
| [ATAN2](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#atan2)                                                     | Built-in | ✓                   |
| [ATANH](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#atanh)                                                     | Built-in | ✓                   |
| [AVG](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/aggregate_functions#avg)                                                            | Built-in | ✓                   |
| [AVG (Differential Privacy)](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/aggregate-dp-functions#dp_avg)                               | Built-in | ✓                   |
| [BAG\_OF\_WORDS](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/text-analysis-functions#bag_of_words)                                    | Built-in | —                   |
| [BIT\_AND](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/aggregate_functions#bit_and)                                                   | Built-in | ✓                   |
| [BIT\_COUNT](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/bit_functions#bit_count)                                                     | Built-in | ✓                   |
| [BIT\_OR](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/aggregate_functions#bit_or)                                                     | Built-in | ✓                   |
| [BIT\_XOR](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/aggregate_functions#bit_xor)                                                   | Built-in | ✓                   |
| [BOOL](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#bool_for_json)                                                      | Built-in | ✓                   |
| [BYTE\_LENGTH](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#byte_length)                                              | Built-in | ✓                   |
| [CAST](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/conversion_functions#cast)                                                         | Built-in | —                   |
| [CBRT](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#cbrt)                                                       | Built-in | ✓                   |
| [CEIL](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#ceil)                                                       | Built-in | ✓                   |
| [CEILING](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#ceiling)                                                 | Built-in | —                   |
| [CHANGES](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/time-series-functions#changes)                                                  | Built-in | —                   |
| [CHAR\_LENGTH](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#char_length)                                              | Built-in | ✓                   |
| [CHARACTER\_LENGTH](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#character_length)                                    | Built-in | ✓                   |
| [CHR](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#chr)                                                               | Built-in | ✓                   |
| [CODE\_POINTS\_TO\_BYTES](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#code_points_to_bytes)                          | Built-in | ✓                   |
| [CODE\_POINTS\_TO\_STRING](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#code_points_to_string)                        | Built-in | ✓                   |
| [COLLATE](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#collate)                                                       | Built-in | ✓                   |
| [CONCAT](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#concat)                                                         | Built-in | ✓                   |
| [CONTAINS\_SUBSTR](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#contains_substr)                                      | Built-in | ✓                   |
| [CORR](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/statistical_aggregate_functions#corr)                                              | Built-in | ✓                   |
| [COS](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#cos)                                                         | Built-in | ✓                   |
| [COSH](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#cosh)                                                       | Built-in | ✓                   |
| [COSINE\_DISTANCE](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#cosine_distance)                                | Built-in | —                   |
| [COT](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#cot)                                                         | Built-in | ✓                   |
| [COTH](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#coth)                                                       | Built-in | ✓                   |
| [COUNT](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/aggregate_functions#count)                                                        | Built-in | ✓                   |
| [COUNT (Differential Privacy)](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/aggregate-dp-functions#dp_count)                           | Built-in | ✓                   |
| [COUNTIF](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/aggregate_functions#countif)                                                    | Built-in | ✓                   |
| [COVAR\_POP](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/statistical_aggregate_functions#covar_pop)                                   | Built-in | ✓                   |
| [COVAR\_SAMP](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/statistical_aggregate_functions#covar_samp)                                 | Built-in | ✓                   |
| [CSC](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#csc)                                                         | Built-in | ✓                   |
| [CSCH](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#csch)                                                       | Built-in | ✓                   |
| [CUME\_DIST](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/numbering_functions#cume_dist)                                               | Built-in | ✓                   |
| [CURRENT\_DATE](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/date_functions#current_date)                                              | Built-in | ✓                   |
| [CURRENT\_DATETIME](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/datetime_functions#current_datetime)                                  | Built-in | ✓                   |
| [CURRENT\_TIME](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/time_functions#current_time)                                              | Built-in | ✓                   |
| [CURRENT\_TIMESTAMP](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/timestamp_functions#current_timestamp)                               | Built-in | ✓                   |
| [DATE](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/date_functions#date)                                                               | Built-in | ✓                   |
| [DATE\_ADD](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/date_functions#date_add)                                                      | Built-in | ✓                   |
| [DATE\_BUCKET](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/time-series-functions#date_bucket)                                         | Built-in | —                   |
| [DATE\_DIFF](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/date_functions#date_diff)                                                    | Built-in | ✓                   |
| [DATE\_FROM\_UNIX\_DATE](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/date_functions#date_from_unix_date)                              | Built-in | ✓                   |
| [DATE\_SUB](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/date_functions#date_sub)                                                      | Built-in | ✓                   |
| [DATE\_TRUNC](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/date_functions#date_trunc)                                                  | Built-in | ✓                   |
| [DATETIME](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/datetime_functions#datetime)                                                   | Built-in | ✓                   |
| [DATETIME\_ADD](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/datetime_functions#datetime_add)                                          | Built-in | ✓                   |
| [DATETIME\_BUCKET](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/time-series-functions#datetime_bucket)                                 | Built-in | —                   |
| [DATETIME\_DIFF](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/datetime_functions#datetime_diff)                                        | Built-in | ✓                   |
| [DATETIME\_SUB](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/datetime_functions#datetime_sub)                                          | Built-in | ✓                   |
| [DATETIME\_TRUNC](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/datetime_functions#datetime_trunc)                                      | Built-in | ✓                   |
| [DENSE\_RANK](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/numbering_functions#dense_rank)                                             | Built-in | ✓                   |
| [DESTINATION\_NODE\_ID](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/graph-sql-functions#destination_node_id)                          | Built-in | —                   |
| [DETERMINISTIC\_DECRYPT\_BYTES](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/aead_encryption_functions#deterministic_decrypt_bytes)    | Built-in | ✓                   |
| [DETERMINISTIC\_DECRYPT\_STRING](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/aead_encryption_functions#deterministic_decrypt_string)  | Built-in | ✓                   |
| [DETERMINISTIC\_ENCRYPT](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/aead_encryption_functions#deterministic_encrypt)                 | Built-in | ✓                   |
| [DIV](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#div)                                                         | Built-in | ✓                   |
| [DLP\_DETERMINISTIC\_DECRYPT](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/dlp_functions#dlp_deterministic_decrypt)                    | Built-in | —                   |
| [DLP\_DETERMINISTIC\_ENCRYPT](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/dlp_functions#dlp_deterministic_encrypt)                    | Built-in | —                   |
| [DLP\_KEY\_CHAIN](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/dlp_functions#dlp_key_chain)                                            | Built-in | —                   |
| [EDGES](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/graph-sql-functions#edges)                                                        | Built-in | —                   |
| [EDIT\_DISTANCE](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#edit_distance)                                          | Built-in | ✓                   |
| [ELEMENT\_ID](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/graph-sql-functions#element_id)                                             | Built-in | —                   |
| [ENDS\_WITH](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#ends_with)                                                  | Built-in | ✓                   |
| [ERROR](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/debugging_functions#error)                                                        | Built-in | ✓                   |
| [EUCLIDEAN\_DISTANCE](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#euclidean_distance)                          | Built-in | —                   |
| [EXP](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#exp)                                                         | Built-in | ✓                   |
| [EXTERNAL\_OBJECT\_TRANSFORM](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/table-functions-built-in#external_object_transform)         | Built-in | —                   |
| [EXTERNAL\_QUERY](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/federated_query_functions#external_query)                               | Built-in | ✓                   |
| [EXTRACT (Date)](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/date_functions#extract)                                                  | Built-in | —                   |
| [EXTRACT (Datetime)](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/datetime_functions#extract)                                          | Built-in | —                   |
| [EXTRACT (Interval)](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/interval_functions#extract)                                          | Built-in | —                   |
| [EXTRACT (Time)](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/time_functions#extract)                                                  | Built-in | —                   |
| [EXTRACT (Timestamp)](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/timestamp_functions#extract)                                        | Built-in | —                   |
| [FARM\_FINGERPRINT](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/hash_functions#farm_fingerprint)                                      | Built-in | ✓                   |
| [FIRST\_VALUE](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/navigation_functions#first_value)                                          | Built-in | ✓                   |
| [FLOAT64](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#double_for_json)                                                 | Built-in | ✓                   |
| [FLOOR](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#floor)                                                     | Built-in | ✓                   |
| [FORMAT](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#format_string)                                                  | Built-in | ✓                   |
| [FORMAT\_DATE](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/date_functions#format_date)                                                | Built-in | ✓                   |
| [FORMAT\_DATETIME](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/datetime_functions#format_datetime)                                    | Built-in | ✓                   |
| [FORMAT\_TIME](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/time_functions#format_time)                                                | Built-in | ✓                   |
| [FORMAT\_TIMESTAMP](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/timestamp_functions#format_timestamp)                                 | Built-in | ✓                   |
| [FROM\_BASE32](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#from_base32)                                              | Built-in | ✓                   |
| [FROM\_BASE64](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#from_base64)                                              | Built-in | ✓                   |
| [FROM\_HEX](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#from_hex)                                                    | Built-in | ✓                   |
| [GAP\_FILL](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/time-series-functions#gap_fill)                                               | Built-in | ✓                   |
| [GENERATE\_ARRAY](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/array_functions#generate_array)                                         | Built-in | ✓                   |
| [GENERATE\_DATE\_ARRAY](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/array_functions#generate_date_array)                              | Built-in | ✓                   |
| [GENERATE\_RANGE\_ARRAY](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/range-functions#generate_range_array)                            | Built-in | —                   |
| [GENERATE\_TIMESTAMP\_ARRAY](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/array_functions#generate_timestamp_array)                    | Built-in | ✓                   |
| [GENERATE\_UUID](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/utility-functions#generate_uuid)                                         | Built-in | ✓                   |
| [GREATEST](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#greatest)                                               | Built-in | ✓                   |
| [GROUPING](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/aggregate_functions#grouping)                                                  | Built-in | ✓                   |
| [HLL\_COUNT.EXTRACT](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/hll_functions#hll_countextract)                                      | Built-in | ✓                   |
| [HLL\_COUNT.INIT](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/hll_functions#hll_countinit)                                            | Built-in | ✓                   |
| [HLL\_COUNT.MERGE](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/hll_functions#hll_countmerge)                                          | Built-in | ✓                   |
| [HLL\_COUNT.MERGE\_PARTIAL](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/hll_functions#hll_countmerge_partial)                         | Built-in | ✓                   |
| [IEEE\_DIVIDE](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#ieee_divide)                                        | Built-in | ✓                   |
| [INITCAP](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#initcap)                                                       | Built-in | ✓                   |
| [INSTR](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#instr)                                                           | Built-in | ✓                   |
| [INT64](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#int64_for_json)                                                    | Built-in | ✓                   |
| [IS\_INF](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#is_inf)                                                  | Built-in | ✓                   |
| [IS\_NAN](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#is_nan)                                                  | Built-in | ✓                   |
| [JSON\_ARRAY](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#json_array)                                                  | Built-in | ✓                   |
| [JSON\_ARRAY\_APPEND](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#json_array_append)                                   | Built-in | ✓                   |
| [JSON\_ARRAY\_INSERT](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#json_array_insert)                                   | Built-in | ✓                   |
| [JSON\_EXTRACT](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#json_extract)                                              | Built-in | —                   |
| [JSON\_EXTRACT\_ARRAY](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#json_extract_array)                                 | Built-in | ✓                   |
| [JSON\_EXTRACT\_SCALAR](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#json_extract_scalar)                               | Built-in | ✓                   |
| [JSON\_EXTRACT\_STRING\_ARRAY](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#json_extract_string_array)                  | Built-in | ✓                   |
| [JSON\_FLATTEN](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#json_flatten)                                              | Built-in | ✓                   |
| [JSON\_KEYS](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#json_keys)                                                    | Built-in | ✓                   |
| [JSON\_OBJECT](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#json_object)                                                | Built-in | ✓                   |
| [JSON\_QUERY](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#json_query)                                                  | Built-in | ✓                   |
| [JSON\_QUERY\_ARRAY](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#json_query_array)                                     | Built-in | ✓                   |
| [JSON\_REMOVE](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#json_remove)                                                | Built-in | ✓                   |
| [JSON\_SET](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#json_set)                                                      | Built-in | ✓                   |
| [JSON\_STRIP\_NULLS](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#json_strip_nulls)                                     | Built-in | ✓                   |
| [JSON\_TYPE](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#json_type)                                                    | Built-in | ✓                   |
| [JSON\_VALUE](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#json_value)                                                  | Built-in | ✓                   |
| [JSON\_VALUE\_ARRAY](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#json_value_array)                                     | Built-in | ✓                   |
| [JUSTIFY\_DAYS](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/interval_functions#justify_days)                                          | Built-in | ✓                   |
| [JUSTIFY\_HOURS](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/interval_functions#justify_hours)                                        | Built-in | ✓                   |
| [JUSTIFY\_INTERVAL](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/interval_functions#justify_interval)                                  | Built-in | ✓                   |
| [KEYS.ADD\_KEY\_FROM\_RAW\_BYTES](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/aead_encryption_functions#keysadd_key_from_raw_bytes)   | Built-in | ✓                   |
| [KEYS.KEYSET\_CHAIN](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/aead_encryption_functions#keyskeyset_chain)                          | Built-in | ✓                   |
| [KEYS.KEYSET\_FROM\_JSON](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/aead_encryption_functions#keyskeyset_from_json)                 | Built-in | ✓                   |
| [KEYS.KEYSET\_LENGTH](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/aead_encryption_functions#keyskeyset_length)                        | Built-in | ✓                   |
| [KEYS.KEYSET\_TO\_JSON](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/aead_encryption_functions#keyskeyset_to_json)                     | Built-in | ✓                   |
| [KEYS.NEW\_KEYSET](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/aead_encryption_functions#keysnew_keyset)                              | Built-in | ✓                   |
| [KEYS.NEW\_WRAPPED\_KEYSET](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/aead_encryption_functions#keysnew_wrapped_keyset)             | Built-in | ✓                   |
| [KEYS.REWRAP\_KEYSET](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/aead_encryption_functions#keysrewrap_keyset)                        | Built-in | ✓                   |
| [KEYS.ROTATE\_KEYSET](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/aead_encryption_functions#keysrotate_keyset)                        | Built-in | ✓                   |
| [KEYS.ROTATE\_WRAPPED\_KEYSET](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/aead_encryption_functions#keysrotate_wrapped_keyset)       | Built-in | ✓                   |
| [KLL\_QUANTILES.EXTRACT\_FLOAT64](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/kll_functions#kll_quantilesextract_double)              | Built-in | —                   |
| [KLL\_QUANTILES.EXTRACT\_INT64](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/kll_functions#kll_quantilesextract_int64)                 | Built-in | —                   |
| [KLL\_QUANTILES.EXTRACT\_POINT\_FLOAT64](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/kll_functions#kll_quantilesextract_point_double) | Built-in | —                   |
| [KLL\_QUANTILES.EXTRACT\_POINT\_INT64](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/kll_functions#kll_quantilesextract_point_int64)    | Built-in | —                   |
| [KLL\_QUANTILES.INIT\_FLOAT64](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/kll_functions#kll_quantilesinit_double)                    | Built-in | —                   |
| [KLL\_QUANTILES.INIT\_INT64](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/kll_functions#kll_quantilesinit_int64)                       | Built-in | —                   |
| [KLL\_QUANTILES.MERGE\_FLOAT64](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/kll_functions#kll_quantilesmerge_double)                  | Built-in | —                   |
| [KLL\_QUANTILES.MERGE\_INT64](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/kll_functions#kll_quantilesmerge_int64)                     | Built-in | —                   |
| [KLL\_QUANTILES.MERGE\_PARTIAL](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/kll_functions#kll_quantilesmerge_partial)                 | Built-in | —                   |
| [KLL\_QUANTILES.MERGE\_POINT\_FLOAT64](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/kll_functions#kll_quantilesmerge_point_double)     | Built-in | —                   |
| [KLL\_QUANTILES.MERGE\_POINT\_INT64](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/kll_functions#kll_quantilesmerge_point_int64)        | Built-in | —                   |
| [LABELS](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/graph-sql-functions#labels)                                                      | Built-in | —                   |
| [LAG](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/navigation_functions#lag)                                                           | Built-in | ✓                   |
| [LAST\_DAY (Date)](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/date_functions#last_day)                                               | Built-in | ✓                   |
| [LAST\_DAY (Datetime)](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/datetime_functions#last_day)                                       | Built-in | ✓                   |
| [LAST\_VALUE](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/navigation_functions#last_value)                                            | Built-in | ✓                   |
| [LAX\_BOOL](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#lax_bool)                                                      | Built-in | ✓                   |
| [LAX\_FLOAT64](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#lax_double)                                                 | Built-in | ✓                   |
| [LAX\_INT64](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#lax_int64)                                                    | Built-in | ✓                   |
| [LAX\_STRING](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#lax_string)                                                  | Built-in | ✓                   |
| [LEAD](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/navigation_functions#lead)                                                         | Built-in | ✓                   |
| [LEAST](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#least)                                                     | Built-in | ✓                   |
| [LEFT](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#left)                                                             | Built-in | ✓                   |
| [LENGTH](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#length)                                                         | Built-in | ✓                   |
| [LN](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#ln)                                                           | Built-in | ✓                   |
| [LOG](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#log)                                                         | Built-in | ✓                   |
| [LOG10](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#log10)                                                     | Built-in | ✓                   |
| [LOGICAL\_AND](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/aggregate_functions#logical_and)                                           | Built-in | ✓                   |
| [LOGICAL\_OR](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/aggregate_functions#logical_or)                                             | Built-in | ✓                   |
| [LOWER](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#lower)                                                           | Built-in | ✓                   |
| [LPAD](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#lpad)                                                             | Built-in | ✓                   |
| [LTRIM](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#ltrim)                                                           | Built-in | ✓                   |
| [MAKE\_INTERVAL](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/interval_functions#make_interval)                                        | Built-in | ✓                   |
| [MAX](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/aggregate_functions#max)                                                            | Built-in | ✓                   |
| [MAX\_BY](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/aggregate_functions#max_by)                                                     | Built-in | ✓                   |
| [MD5](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/hash_functions#md5)                                                                 | Built-in | ✓                   |
| [MIN](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/aggregate_functions#min)                                                            | Built-in | ✓                   |
| [MIN\_BY](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/aggregate_functions#min_by)                                                     | Built-in | ✓                   |
| [MOD](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#mod)                                                         | Built-in | ✓                   |
| [NET.HOST](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/net_functions#nethost)                                                         | Built-in | ✓                   |
| [NET.IP\_FROM\_STRING](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/net_functions#netip_from_string)                                   | Built-in | ✓                   |
| [NET.IP\_NET\_MASK](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/net_functions#netip_net_mask)                                         | Built-in | ✓                   |
| [NET.IP\_TO\_STRING](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/net_functions#netip_to_string)                                       | Built-in | ✓                   |
| [NET.IP\_TRUNC](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/net_functions#netip_trunc)                                                | Built-in | ✓                   |
| [NET.IPV4\_FROM\_INT64](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/net_functions#netipv4_from_int64)                                 | Built-in | ✓                   |
| [NET.IPV4\_TO\_INT64](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/net_functions#netipv4_to_int64)                                     | Built-in | ✓                   |
| [NET.PUBLIC\_SUFFIX](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/net_functions#netpublic_suffix)                                      | Built-in | ✓                   |
| [NET.REG\_DOMAIN](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/net_functions#netreg_domain)                                            | Built-in | ✓                   |
| [NET.SAFE\_IP\_FROM\_STRING](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/net_functions#netsafe_ip_from_string)                        | Built-in | ✓                   |
| [NODES](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/graph-sql-functions#nodes)                                                        | Built-in | —                   |
| [NORMALIZE](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#normalize)                                                   | Built-in | —                   |
| [NORMALIZE\_AND\_CASEFOLD](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#normalize_and_casefold)                       | Built-in | ✓                   |
| [NTH\_VALUE](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/navigation_functions#nth_value)                                              | Built-in | ✓                   |
| [NTILE](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/numbering_functions#ntile)                                                        | Built-in | ✓                   |
| [OBJ.FETCH\_METADATA](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/objectref_functions#objfetch_metadata)                              | Built-in | —                   |
| [OBJ.GET\_ACCESS\_URL](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/objectref_functions#objget_access_url)                             | Built-in | —                   |
| [OBJ.GET\_READ\_URL](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/objectref_functions#objget_read_url)                                 | Built-in | —                   |
| [OBJ.MAKE\_REF](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/objectref_functions#objmake_ref)                                          | Built-in | —                   |
| [OCTET\_LENGTH](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#octet_length)                                            | Built-in | ✓                   |
| [PARSE\_BIGNUMERIC](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/conversion_functions#parse_bignumeric)                                | Built-in | ✓                   |
| [PARSE\_DATE](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/date_functions#parse_date)                                                  | Built-in | ✓                   |
| [PARSE\_DATETIME](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/datetime_functions#parse_datetime)                                      | Built-in | ✓                   |
| [PARSE\_JSON](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#parse_json)                                                  | Built-in | ✓                   |
| [PARSE\_NUMERIC](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/conversion_functions#parse_numeric)                                      | Built-in | ✓                   |
| [PARSE\_TIME](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/time_functions#parse_time)                                                  | Built-in | ✓                   |
| [PARSE\_TIMESTAMP](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/timestamp_functions#parse_timestamp)                                   | Built-in | ✓                   |
| [PATH\_FIRST](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/graph-sql-functions#path_first)                                             | Built-in | —                   |
| [PATH\_LAST](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/graph-sql-functions#path_last)                                               | Built-in | —                   |
| [PATH\_LENGTH](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/graph-sql-functions#path_length)                                           | Built-in | —                   |
| [PERCENT\_RANK](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/numbering_functions#percent_rank)                                         | Built-in | ✓                   |
| [PERCENTILE\_CONT (Differential Privacy)](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/aggregate-dp-functions#dp_percentile_cont)      | Built-in | ✓                   |
| [PERCENTILE\_CONT (Navigation)](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/navigation_functions#percentile_cont)                     | Built-in | ✓                   |
| [PERCENTILE\_DISC](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/navigation_functions#percentile_disc)                                  | Built-in | ✓                   |
| [POW](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#pow)                                                         | Built-in | ✓                   |
| [POWER](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#power)                                                     | Built-in | ✓                   |
| [RAND](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#rand)                                                       | Built-in | ✓                   |
| [RANGE](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/range-functions#range)                                                            | Built-in | —                   |
| [RANGE\_BUCKET](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#range_bucket)                                      | Built-in | ✓                   |
| [RANGE\_CONTAINS](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/range-functions#range_contains)                                         | Built-in | —                   |
| [RANGE\_END](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/range-functions#range_end)                                                   | Built-in | —                   |
| [RANGE\_INTERSECT](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/range-functions#range_intersect)                                       | Built-in | —                   |
| [RANGE\_OVERLAPS](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/range-functions#range_overlaps)                                         | Built-in | —                   |
| [RANGE\_SESSIONIZE](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/range-functions#range_sessionize)                                     | Built-in | —                   |
| [RANGE\_START](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/range-functions#range_start)                                               | Built-in | —                   |
| [RANK](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/numbering_functions#rank)                                                          | Built-in | ✓                   |
| [REGEXP\_CONTAINS](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#regexp_contains)                                      | Built-in | ✓                   |
| [REGEXP\_EXTRACT](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#regexp_extract)                                        | Built-in | ✓                   |
| [REGEXP\_EXTRACT\_ALL](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#regexp_extract_all)                               | Built-in | ✓                   |
| [REGEXP\_INSTR](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#regexp_instr)                                            | Built-in | ✓                   |
| [REGEXP\_REPLACE](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#regexp_replace)                                        | Built-in | ✓                   |
| [REGEXP\_SUBSTR](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#regexp_substr)                                          | Built-in | ✓                   |
| [REPEAT](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#repeat)                                                         | Built-in | ✓                   |
| [REPLACE](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#replace)                                                       | Built-in | ✓                   |
| [REVERSE](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#reverse)                                                       | Built-in | ✓                   |
| [RIGHT](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#right)                                                           | Built-in | ✓                   |
| [ROUND](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#round)                                                     | Built-in | ✓                   |
| [ROW\_NUMBER](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/numbering_functions#row_number)                                             | Built-in | ✓                   |
| [RPAD](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#rpad)                                                             | Built-in | ✓                   |
| [RTRIM](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#rtrim)                                                           | Built-in | ✓                   |
| [S2\_CELLIDFROMPOINT](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#s2_cellidfrompoint)                             | Built-in | ✓                   |
| [S2\_COVERINGCELLIDS](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#s2_coveringcellids)                             | Built-in | ✓                   |
| [SAFE\_ADD](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_add)                                              | Built-in | ✓                   |
| [SAFE\_CAST](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/conversion_functions#safe_casting)                                           | Built-in | —                   |
| [SAFE\_CONVERT\_BYTES\_TO\_STRING](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#safe_convert_bytes_to_string)         | Built-in | ✓                   |
| [SAFE\_DIVIDE](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_divide)                                        | Built-in | ✓                   |
| [SAFE\_MULTIPLY](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_multiply)                                    | Built-in | ✓                   |
| [SAFE\_NEGATE](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_negate)                                        | Built-in | ✓                   |
| [SAFE\_SUBTRACT](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_subtract)                                    | Built-in | ✓                   |
| [SEARCH](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/search_functions#search)                                                         | Built-in | ✓                   |
| [SEC](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#sec)                                                         | Built-in | ✓                   |
| [SECH](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#sech)                                                       | Built-in | ✓                   |
| [SESSION\_USER](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/security_functions#session_user)                                          | Built-in | ✓                   |
| [SHA1](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/hash_functions#sha1)                                                               | Built-in | ✓                   |
| [SHA256](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/hash_functions#sha256)                                                           | Built-in | ✓                   |
| [SHA512](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/hash_functions#sha512)                                                           | Built-in | ✓                   |
| [SIGN](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#sign)                                                       | Built-in | ✓                   |
| [SIN](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#sin)                                                         | Built-in | ✓                   |
| [SINH](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#sinh)                                                       | Built-in | ✓                   |
| [SOUNDEX](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#soundex)                                                       | Built-in | ✓                   |
| [SOURCE\_NODE\_ID](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/graph-sql-functions#source_node_id)                                    | Built-in | —                   |
| [SPLIT](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#split)                                                           | Built-in | ✓                   |
| [SQRT](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#sqrt)                                                       | Built-in | ✓                   |
| [ST\_ANGLE](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_angle)                                                 | Built-in | ✓                   |
| [ST\_AREA](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_area)                                                   | Built-in | ✓                   |
| [ST\_ASBINARY](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_asbinary)                                           | Built-in | ✓                   |
| [ST\_ASGEOJSON](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_asgeojson)                                         | Built-in | ✓                   |
| [ST\_ASTEXT](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_astext)                                               | Built-in | ✓                   |
| [ST\_AZIMUTH](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_azimuth)                                             | Built-in | ✓                   |
| [ST\_BOUNDARY](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_boundary)                                           | Built-in | ✓                   |
| [ST\_BOUNDINGBOX](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_boundingbox)                                     | Built-in | ✓                   |
| [ST\_BUFFER](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_buffer)                                               | Built-in | ✓                   |
| [ST\_BUFFERWITHTOLERANCE](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_bufferwithtolerance)                     | Built-in | ✓                   |
| [ST\_CENTROID](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_centroid)                                           | Built-in | ✓                   |
| [ST\_CENTROID\_AGG](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_centroid_agg)                                  | Built-in | ✓                   |
| [ST\_CLOSESTPOINT](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_closestpoint)                                   | Built-in | ✓                   |
| [ST\_CLUSTERDBSCAN](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_clusterdbscan)                                 | Built-in | ✓                   |
| [ST\_CONTAINS](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_contains)                                           | Built-in | ✓                   |
| [ST\_CONVEXHULL](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_convexhull)                                       | Built-in | ✓                   |
| [ST\_COVEREDBY](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_coveredby)                                         | Built-in | ✓                   |
| [ST\_COVERS](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_covers)                                               | Built-in | ✓                   |
| [ST\_DIFFERENCE](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_difference)                                       | Built-in | ✓                   |
| [ST\_DIMENSION](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_dimension)                                         | Built-in | ✓                   |
| [ST\_DISJOINT](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_disjoint)                                           | Built-in | ✓                   |
| [ST\_DISTANCE](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_distance)                                           | Built-in | ✓                   |
| [ST\_DUMP](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_dump)                                                   | Built-in | ✓                   |
| [ST\_DWITHIN](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_dwithin)                                             | Built-in | ✓                   |
| [ST\_ENDPOINT](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_endpoint)                                           | Built-in | ✓                   |
| [ST\_EQUALS](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_equals)                                               | Built-in | ✓                   |
| [ST\_EXTENT](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_extent)                                               | Built-in | —                   |
| [ST\_EXTERIORRING](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_exteriorring)                                   | Built-in | ✓                   |
| [ST\_GEOGFROM](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_geogfrom)                                           | Built-in | ✓                   |
| [ST\_GEOGFROMGEOJSON](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_geogfromgeojson)                             | Built-in | ✓                   |
| [ST\_GEOGFROMTEXT](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_geogfromtext)                                   | Built-in | ✓                   |
| [ST\_GEOGFROMWKB](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_geogfromwkb)                                     | Built-in | ✓                   |
| [ST\_GEOGPOINT](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_geogpoint)                                         | Built-in | ✓                   |
| [ST\_GEOGPOINTFROMGEOHASH](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_geogpointfromgeohash)                   | Built-in | ✓                   |
| [ST\_GEOHASH](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_geohash)                                             | Built-in | ✓                   |
| [ST\_GEOMETRYTYPE](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_geometrytype)                                   | Built-in | ✓                   |
| [ST\_HAUSDORFFDISTANCE](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_hausdorffdistance)                         | Built-in | —                   |
| [ST\_HAUSDORFFDWITHIN](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_hausdorffdwithin)                           | Built-in | —                   |
| [ST\_INTERIORRINGS](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_interiorrings)                                 | Built-in | ✓                   |
| [ST\_INTERSECTION](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_intersection)                                   | Built-in | ✓                   |
| [ST\_INTERSECTS](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_intersects)                                       | Built-in | ✓                   |
| [ST\_INTERSECTSBOX](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_intersectsbox)                                 | Built-in | ✓                   |
| [ST\_ISCLOSED](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_isclosed)                                           | Built-in | ✓                   |
| [ST\_ISCOLLECTION](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_iscollection)                                   | Built-in | ✓                   |
| [ST\_ISEMPTY](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_isempty)                                             | Built-in | ✓                   |
| [ST\_ISRING](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_isring)                                               | Built-in | ✓                   |
| [ST\_LENGTH](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_length)                                               | Built-in | ✓                   |
| [ST\_LINEINTERPOLATEPOINT](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_lineinterpolatepoint)                   | Built-in | —                   |
| [ST\_LINELOCATEPOINT](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_linelocatepoint)                             | Built-in | ✓                   |
| [ST\_LINESUBSTRING](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_linesubstring)                                 | Built-in | —                   |
| [ST\_MAKELINE](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_makeline)                                           | Built-in | ✓                   |
| [ST\_MAKEPOLYGON](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_makepolygon)                                     | Built-in | ✓                   |
| [ST\_MAKEPOLYGONORIENTED](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_makepolygonoriented)                     | Built-in | ✓                   |
| [ST\_MAXDISTANCE](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_maxdistance)                                     | Built-in | ✓                   |
| [ST\_NPOINTS](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_npoints)                                             | Built-in | ✓                   |
| [ST\_NUMGEOMETRIES](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_numgeometries)                                 | Built-in | ✓                   |
| [ST\_NUMPOINTS](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_numpoints)                                         | Built-in | ✓                   |
| [ST\_PERIMETER](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_perimeter)                                         | Built-in | ✓                   |
| [ST\_POINTN](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_pointn)                                               | Built-in | ✓                   |
| [ST\_REGIONSTATS](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_regionstats)                                     | Built-in | —                   |
| [ST\_SIMPLIFY](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_simplify)                                           | Built-in | ✓                   |
| [ST\_SNAPTOGRID](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_snaptogrid)                                       | Built-in | ✓                   |
| [ST\_STARTPOINT](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_startpoint)                                       | Built-in | ✓                   |
| [ST\_TOUCHES](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_touches)                                             | Built-in | ✓                   |
| [ST\_UNION](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_union)                                                 | Built-in | ✓                   |
| [ST\_UNION\_AGG](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_union_agg)                                        | Built-in | ✓                   |
| [ST\_WITHIN](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_within)                                               | Built-in | ✓                   |
| [ST\_X](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_x)                                                         | Built-in | ✓                   |
| [ST\_Y](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_y)                                                         | Built-in | ✓                   |
| [STARTS\_WITH](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#starts_with)                                              | Built-in | ✓                   |
| [STDDEV](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/statistical_aggregate_functions#stddev)                                          | Built-in | ✓                   |
| [STDDEV\_POP](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/statistical_aggregate_functions#stddev_pop)                                 | Built-in | ✓                   |
| [STDDEV\_SAMP](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/statistical_aggregate_functions#stddev_samp)                               | Built-in | ✓                   |
| [STRING (JSON)](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#string_for_json)                                           | Built-in | ✓                   |
| [STRING (Timestamp)](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/timestamp_functions#string)                                          | Built-in | ✓                   |
| [STRING\_AGG](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/aggregate_functions#string_agg)                                             | Built-in | ✓                   |
| [STRPOS](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#strpos)                                                         | Built-in | ✓                   |
| [SUBSTR](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#substr)                                                         | Built-in | ✓                   |
| [SUBSTRING](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#substring)                                                   | Built-in | —                   |
| [SUM](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/aggregate_functions#sum)                                                            | Built-in | ✓                   |
| [SUM (Differential Privacy)](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/aggregate-dp-functions#dp_sum)                               | Built-in | ✓                   |
| [TAN](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#tan)                                                         | Built-in | ✓                   |
| [TANH](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#tanh)                                                       | Built-in | ✓                   |
| [TEXT\_ANALYZE](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/text-analysis-functions#text_analyze)                                     | Built-in | —                   |
| [TF\_IDF](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/text-analysis-functions#tf_idf)                                                 | Built-in | —                   |
| [TIME](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/time_functions#time)                                                               | Built-in | ✓                   |
| [TIME\_ADD](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/time_functions#time_add)                                                      | Built-in | ✓                   |
| [TIME\_DIFF](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/time_functions#time_diff)                                                    | Built-in | ✓                   |
| [TIME\_SUB](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/time_functions#time_sub)                                                      | Built-in | ✓                   |
| [TIME\_TRUNC](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/time_functions#time_trunc)                                                  | Built-in | ✓                   |
| [TIMESTAMP](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/timestamp_functions#timestamp)                                                | Built-in | ✓                   |
| [TIMESTAMP\_ADD](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/timestamp_functions#timestamp_add)                                       | Built-in | ✓                   |
| [TIMESTAMP\_BUCKET](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/time-series-functions#timestamp_bucket)                               | Built-in | —                   |
| [TIMESTAMP\_DIFF](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/timestamp_functions#timestamp_diff)                                     | Built-in | ✓                   |
| [TIMESTAMP\_MICROS](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/timestamp_functions#timestamp_micros)                                 | Built-in | ✓                   |
| [TIMESTAMP\_MILLIS](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/timestamp_functions#timestamp_millis)                                 | Built-in | ✓                   |
| [TIMESTAMP\_SECONDS](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/timestamp_functions#timestamp_seconds)                               | Built-in | ✓                   |
| [TIMESTAMP\_SUB](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/timestamp_functions#timestamp_sub)                                       | Built-in | ✓                   |
| [TIMESTAMP\_TRUNC](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/timestamp_functions#timestamp_trunc)                                   | Built-in | ✓                   |
| [TO\_BASE32](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#to_base32)                                                  | Built-in | ✓                   |
| [TO\_BASE64](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#to_base64)                                                  | Built-in | ✓                   |
| [TO\_CODE\_POINTS](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#to_code_points)                                       | Built-in | ✓                   |
| [TO\_HEX](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#to_hex)                                                        | Built-in | ✓                   |
| [TO\_JSON](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#to_json)                                                        | Built-in | ✓                   |
| [TO\_JSON\_STRING](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#to_json_string)                                         | Built-in | ✓                   |
| [TRANSLATE](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#translate)                                                   | Built-in | ✓                   |
| [TRIM](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#trim)                                                             | Built-in | ✓                   |
| [TRUNC](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#trunc)                                                     | Built-in | ✓                   |
| [TYPEOF](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/utility-functions#typeof)                                                        | Built-in | —                   |
| [UNICODE](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#unicode)                                                       | Built-in | ✓                   |
| [UNIX\_DATE](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/date_functions#unix_date)                                                    | Built-in | ✓                   |
| [UNIX\_MICROS](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/timestamp_functions#unix_micros)                                           | Built-in | ✓                   |
| [UNIX\_MILLIS](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/timestamp_functions#unix_millis)                                           | Built-in | ✓                   |
| [UNIX\_SECONDS](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/timestamp_functions#unix_seconds)                                         | Built-in | ✓                   |
| [UPPER](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#upper)                                                           | Built-in | ✓                   |
| [VAR\_POP](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/statistical_aggregate_functions#var_pop)                                       | Built-in | ✓                   |
| [VAR\_SAMP](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/statistical_aggregate_functions#var_samp)                                     | Built-in | ✓                   |
| [VARIANCE](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/statistical_aggregate_functions#variance)                                      | Built-in | ✓                   |
| [VECTOR\_INDEX.STATISTICS](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/vectorindex_functions#vector_indexstatistics)                  | Built-in | —                   |
| [VECTOR\_SEARCH](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/search_functions#vector_search)                                          | Built-in | —                   |

## Was this page helpful?

YesNo

[Privacy policy](https://www.getdbt.com/cloud/privacy-policy)[Create a GitHub issue](https://github.com/dbt-labs/docs.getdbt.com/issues)

This site is protected by reCAPTCHA and the Google [Privacy Policy](https://policies.google.com/privacy) and [Terms of Service](https://policies.google.com/terms) apply.