---
title: Functions supported in Databricks-to-Databricks view sharing | Databricks on AWS
source: https://docs.databricks.com/aws/en/delta-sharing/shared-view-functions-data-databricks
ingestedAt: "2026-06-18T08:05:55.076Z"
---

This page describes functions and operators supported in [Databricks-to-Databricks view sharing](https://docs.databricks.com/aws/en/delta-sharing/read-data-databricks#views).

To keep your data secure, Databricks-to-Databricks view sharing only allows the following subset of Databricks [built-in functions and operators](https://docs.databricks.com/aws/en/sql/language-manual/sql-ref-functions-builtin-alpha):

*   [\-](https://docs.databricks.com/aws/en/sql/language-manual/functions/minussign)
*   [!](https://docs.databricks.com/aws/en/sql/language-manual/functions/bangsign)
*   [/](https://docs.databricks.com/aws/en/sql/language-manual/functions/asterisksign)
*   [/](https://docs.databricks.com/aws/en/sql/language-manual/functions/slashsign)
*   [&](https://docs.databricks.com/aws/en/sql/language-manual/functions/ampersandsign)
*   [%](https://docs.databricks.com/aws/en/sql/language-manual/functions/percentsign)
*   [^](https://docs.databricks.com/aws/en/sql/language-manual/functions/caretsign)
*   [+](https://docs.databricks.com/aws/en/sql/language-manual/functions/plussign)
*   [<](https://docs.databricks.com/aws/en/sql/language-manual/functions/ltsign)
*   `<<`
*   [<=](https://docs.databricks.com/aws/en/sql/language-manual/functions/lteqsign)
*   [<=>](https://docs.databricks.com/aws/en/sql/language-manual/functions/lteqgtsign)
*   [\=](https://docs.databricks.com/aws/en/sql/language-manual/functions/eqsign)
*   [\==](https://docs.databricks.com/aws/en/sql/language-manual/functions/eqeqsign)
*   [\>](https://docs.databricks.com/aws/en/sql/language-manual/functions/gtsign)
*   [\>=](https://docs.databricks.com/aws/en/sql/language-manual/functions/gteqsign)
*   `>>`
*   `>>>`
*   [|](https://docs.databricks.com/aws/en/sql/language-manual/functions/pipesign)
*   [~](https://docs.databricks.com/aws/en/sql/language-manual/functions/tildesign)
*   [abs](https://docs.databricks.com/aws/en/sql/language-manual/functions/abs)
*   [acos](https://docs.databricks.com/aws/en/sql/language-manual/functions/acos)
*   [acosh](https://docs.databricks.com/aws/en/sql/language-manual/functions/acosh)
*   [add\_months](https://docs.databricks.com/aws/en/sql/language-manual/functions/add_months)
*   [aes\_decrypt](https://docs.databricks.com/aws/en/sql/language-manual/functions/aes_decrypt)
*   [aes\_encrypt](https://docs.databricks.com/aws/en/sql/language-manual/functions/aes_encrypt)
*   [aggregate](https://docs.databricks.com/aws/en/sql/language-manual/functions/aggregate)
*   [and](https://docs.databricks.com/aws/en/sql/language-manual/functions/and)
*   [any](https://docs.databricks.com/aws/en/sql/language-manual/functions/any)
*   [any\_value](https://docs.databricks.com/aws/en/sql/language-manual/functions/any_value)
*   [approx\_count\_distinct](https://docs.databricks.com/aws/en/sql/language-manual/functions/approx_count_distinct)
*   [approx\_percentile](https://docs.databricks.com/aws/en/sql/language-manual/functions/approx_percentile)
*   [approx\_top\_k](https://docs.databricks.com/aws/en/sql/language-manual/functions/approx_top_k)
*   [array](https://docs.databricks.com/aws/en/sql/language-manual/functions/array)
*   [array\_agg](https://docs.databricks.com/aws/en/sql/language-manual/functions/array_agg)
*   [array\_append](https://docs.databricks.com/aws/en/sql/language-manual/functions/array_append)
*   [array\_compact](https://docs.databricks.com/aws/en/sql/language-manual/functions/array_compact)
*   [array\_contains](https://docs.databricks.com/aws/en/sql/language-manual/functions/array_contains)
*   [array\_distinct](https://docs.databricks.com/aws/en/sql/language-manual/functions/array_distinct)
*   [array\_except](https://docs.databricks.com/aws/en/sql/language-manual/functions/array_except)
*   [array\_insert](https://docs.databricks.com/aws/en/sql/language-manual/functions/array_insert)
*   [array\_intersect](https://docs.databricks.com/aws/en/sql/language-manual/functions/array_intersect)
*   [array\_join](https://docs.databricks.com/aws/en/sql/language-manual/functions/array_join)
*   [array\_max](https://docs.databricks.com/aws/en/sql/language-manual/functions/array_max)
*   [array\_min](https://docs.databricks.com/aws/en/sql/language-manual/functions/array_min)
*   [array\_position](https://docs.databricks.com/aws/en/sql/language-manual/functions/array_position)
*   [array\_prepend](https://docs.databricks.com/aws/en/sql/language-manual/functions/array_prepend)
*   [array\_remove](https://docs.databricks.com/aws/en/sql/language-manual/functions/array_remove)
*   [array\_repeat](https://docs.databricks.com/aws/en/sql/language-manual/functions/array_repeat)
*   [array\_size](https://docs.databricks.com/aws/en/sql/language-manual/functions/array_size)
*   [array\_sort](https://docs.databricks.com/aws/en/sql/language-manual/functions/array_sort)
*   [array\_union](https://docs.databricks.com/aws/en/sql/language-manual/functions/array_union)
*   [arrays\_overlap](https://docs.databricks.com/aws/en/sql/language-manual/functions/arrays_overlap)
*   [arrays\_zip](https://docs.databricks.com/aws/en/sql/language-manual/functions/arrays_zip)
*   [ascii](https://docs.databricks.com/aws/en/sql/language-manual/functions/ascii)
*   [asin](https://docs.databricks.com/aws/en/sql/language-manual/functions/asin)
*   [asinh](https://docs.databricks.com/aws/en/sql/language-manual/functions/asinh)
*   [assert\_true](https://docs.databricks.com/aws/en/sql/language-manual/functions/assert_true)
*   [atan](https://docs.databricks.com/aws/en/sql/language-manual/functions/atan)
*   [atan2](https://docs.databricks.com/aws/en/sql/language-manual/functions/atan2)
*   [atanh](https://docs.databricks.com/aws/en/sql/language-manual/functions/atanh)
*   [avg](https://docs.databricks.com/aws/en/sql/language-manual/functions/avg)
*   [base64](https://docs.databricks.com/aws/en/sql/language-manual/functions/base64)
*   [between](https://docs.databricks.com/aws/en/sql/language-manual/functions/between)
*   [bigint](https://docs.databricks.com/aws/en/sql/language-manual/functions/bigint)
*   [bin](https://docs.databricks.com/aws/en/sql/language-manual/functions/bin)
*   [binary](https://docs.databricks.com/aws/en/sql/language-manual/functions/binary)
*   [bit\_and](https://docs.databricks.com/aws/en/sql/language-manual/functions/bit_and)
*   [bit\_count](https://docs.databricks.com/aws/en/sql/language-manual/functions/bit_count)
*   [bit\_get](https://docs.databricks.com/aws/en/sql/language-manual/functions/bit_get)
*   [bit\_length](https://docs.databricks.com/aws/en/sql/language-manual/functions/bit_length)
*   [bit\_or](https://docs.databricks.com/aws/en/sql/language-manual/functions/bit_or)
*   [bit\_reverse](https://docs.databricks.com/aws/en/sql/language-manual/functions/bit_reverse)
*   [bit\_xor](https://docs.databricks.com/aws/en/sql/language-manual/functions/bit_xor)
*   [bitmap\_bit\_position](https://docs.databricks.com/aws/en/sql/language-manual/functions/bitmap_bit_position)
*   [bitmap\_bucket\_number](https://docs.databricks.com/aws/en/sql/language-manual/functions/bitmap_bucket_number)
*   [bitmap\_construct\_agg](https://docs.databricks.com/aws/en/sql/language-manual/functions/bitmap_construct_agg)
*   [bitmap\_count](https://docs.databricks.com/aws/en/sql/language-manual/functions/bitmap_count)
*   [bitmap\_or\_agg](https://docs.databricks.com/aws/en/sql/language-manual/functions/bitmap_or_agg)
*   [bool\_and](https://docs.databricks.com/aws/en/sql/language-manual/functions/bool_and)
*   [bool\_or](https://docs.databricks.com/aws/en/sql/language-manual/functions/bool_or)
*   [boolean](https://docs.databricks.com/aws/en/sql/language-manual/functions/boolean)
*   [bround](https://docs.databricks.com/aws/en/sql/language-manual/functions/bround)
*   [btrim](https://docs.databricks.com/aws/en/sql/language-manual/functions/btrim)
*   [cardinality](https://docs.databricks.com/aws/en/sql/language-manual/functions/cardinality)
*   [cast](https://docs.databricks.com/aws/en/sql/language-manual/functions/cast)
*   [cbrt](https://docs.databricks.com/aws/en/sql/language-manual/functions/cbrt)
*   [ceil](https://docs.databricks.com/aws/en/sql/language-manual/functions/ceil)
*   [ceiling](https://docs.databricks.com/aws/en/sql/language-manual/functions/ceiling)
*   [char](https://docs.databricks.com/aws/en/sql/language-manual/functions/char)
*   [char\_length](https://docs.databricks.com/aws/en/sql/language-manual/functions/char_length)
*   [character\_length](https://docs.databricks.com/aws/en/sql/language-manual/functions/character_length)
*   [charindex](https://docs.databricks.com/aws/en/sql/language-manual/functions/charindex)
*   [chr](https://docs.databricks.com/aws/en/sql/language-manual/functions/chr)
*   [coalesce](https://docs.databricks.com/aws/en/sql/language-manual/functions/coalesce)
*   `collate`
*   `collation`
*   [collect\_list](https://docs.databricks.com/aws/en/sql/language-manual/functions/collect_list)
*   [collect\_set](https://docs.databricks.com/aws/en/sql/language-manual/functions/collect_set)
*   [concat](https://docs.databricks.com/aws/en/sql/language-manual/functions/concat)
*   [contains](https://docs.databricks.com/aws/en/sql/language-manual/functions/contains)
*   [conv](https://docs.databricks.com/aws/en/sql/language-manual/functions/conv)
*   [convert\_timezone](https://docs.databricks.com/aws/en/sql/language-manual/functions/convert_timezone)
*   [corr](https://docs.databricks.com/aws/en/sql/language-manual/functions/corr)
*   [cos](https://docs.databricks.com/aws/en/sql/language-manual/functions/cos)
*   [cosh](https://docs.databricks.com/aws/en/sql/language-manual/functions/cosh)
*   [cot](https://docs.databricks.com/aws/en/sql/language-manual/functions/cot)
*   [count](https://docs.databricks.com/aws/en/sql/language-manual/functions/count)
*   [count\_if](https://docs.databricks.com/aws/en/sql/language-manual/functions/count_if)
*   [count\_min\_sketch](https://docs.databricks.com/aws/en/sql/language-manual/functions/count_min_sketch)
*   [covar\_pop](https://docs.databricks.com/aws/en/sql/language-manual/functions/covar_pop)
*   [covar\_samp](https://docs.databricks.com/aws/en/sql/language-manual/functions/covar_samp)
*   [crc32](https://docs.databricks.com/aws/en/sql/language-manual/functions/crc32)
*   [csc](https://docs.databricks.com/aws/en/sql/language-manual/functions/csc)
*   [cume\_dist](https://docs.databricks.com/aws/en/sql/language-manual/functions/cume_dist)
*   [curdate](https://docs.databricks.com/aws/en/sql/language-manual/functions/curdate)
*   [current\_catalog](https://docs.databricks.com/aws/en/sql/language-manual/functions/current_catalog)
*   [current\_database](https://docs.databricks.com/aws/en/sql/language-manual/functions/current_database)
*   [current\_date](https://docs.databricks.com/aws/en/sql/language-manual/functions/current_date)
*   [current\_metastore](https://docs.databricks.com/aws/en/sql/language-manual/functions/current_metastore)
*   [current\_recipient](https://docs.databricks.com/aws/en/sql/language-manual/functions/current_recipient)
*   [current\_schema](https://docs.databricks.com/aws/en/sql/language-manual/functions/current_schema)
*   [current\_timestamp](https://docs.databricks.com/aws/en/sql/language-manual/functions/current_timestamp)
*   [current\_timezone](https://docs.databricks.com/aws/en/sql/language-manual/functions/current_timezone)
*   [current\_version](https://docs.databricks.com/aws/en/sql/language-manual/functions/current_version)
*   [date](https://docs.databricks.com/aws/en/sql/language-manual/functions/date)
*   [date\_add](https://docs.databricks.com/aws/en/sql/language-manual/functions/date_add)
*   [date\_diff](https://docs.databricks.com/aws/en/sql/language-manual/functions/date_diff)
*   [date\_format](https://docs.databricks.com/aws/en/sql/language-manual/functions/date_format)
*   [date\_from\_unix\_date](https://docs.databricks.com/aws/en/sql/language-manual/functions/date_from_unix_date)
*   [date\_part](https://docs.databricks.com/aws/en/sql/language-manual/functions/date_part)
*   [date\_sub](https://docs.databricks.com/aws/en/sql/language-manual/functions/date_sub)
*   [date\_trunc](https://docs.databricks.com/aws/en/sql/language-manual/functions/date_trunc)
*   [dateadd](https://docs.databricks.com/aws/en/sql/language-manual/functions/dateadd)
*   [datediff](https://docs.databricks.com/aws/en/sql/language-manual/functions/datediff)
*   `datepart`
*   [day](https://docs.databricks.com/aws/en/sql/language-manual/functions/day)
*   [dayofmonth](https://docs.databricks.com/aws/en/sql/language-manual/functions/dayofmonth)
*   [dayofweek](https://docs.databricks.com/aws/en/sql/language-manual/functions/dayofweek)
*   [dayofyear](https://docs.databricks.com/aws/en/sql/language-manual/functions/dayofyear)
*   [decimal](https://docs.databricks.com/aws/en/sql/language-manual/functions/decimal)
*   [decode](https://docs.databricks.com/aws/en/sql/language-manual/functions/decode)
*   [degrees](https://docs.databricks.com/aws/en/sql/language-manual/functions/degrees)
*   [dense\_rank](https://docs.databricks.com/aws/en/sql/language-manual/functions/dense_rank)
*   [div](https://docs.databricks.com/aws/en/sql/language-manual/functions/div)
*   [double](https://docs.databricks.com/aws/en/sql/language-manual/functions/double)
*   [e](https://docs.databricks.com/aws/en/sql/language-manual/functions/e)
*   [element\_at](https://docs.databricks.com/aws/en/sql/language-manual/functions/element_at)
*   [encode](https://docs.databricks.com/aws/en/sql/language-manual/functions/encode)
*   [endswith](https://docs.databricks.com/aws/en/sql/language-manual/functions/endswith)
*   [every](https://docs.databricks.com/aws/en/sql/language-manual/functions/every)
*   [exists](https://docs.databricks.com/aws/en/sql/language-manual/functions/exists)
*   [exp](https://docs.databricks.com/aws/en/sql/language-manual/functions/exp)
*   [explode](https://docs.databricks.com/aws/en/sql/language-manual/functions/explode)
*   [explode\_outer](https://docs.databricks.com/aws/en/sql/language-manual/functions/explode_outer)
*   [expm1](https://docs.databricks.com/aws/en/sql/language-manual/functions/expm1)
*   [extract](https://docs.databricks.com/aws/en/sql/language-manual/functions/extract)
*   [factorial](https://docs.databricks.com/aws/en/sql/language-manual/functions/factorial)
*   [filter](https://docs.databricks.com/aws/en/sql/language-manual/functions/filter)
*   [find\_in\_set](https://docs.databricks.com/aws/en/sql/language-manual/functions/find_in_set)
*   [first](https://docs.databricks.com/aws/en/sql/language-manual/functions/first)
*   [first\_value](https://docs.databricks.com/aws/en/sql/language-manual/functions/first_value)
*   [flatten](https://docs.databricks.com/aws/en/sql/language-manual/functions/flatten)
*   [float](https://docs.databricks.com/aws/en/sql/language-manual/functions/float)
*   [floor](https://docs.databricks.com/aws/en/sql/language-manual/functions/floor)
*   [forall](https://docs.databricks.com/aws/en/sql/language-manual/functions/forall)
*   [format\_number](https://docs.databricks.com/aws/en/sql/language-manual/functions/format_number)
*   [format\_string](https://docs.databricks.com/aws/en/sql/language-manual/functions/format_string)
*   [from\_unixtime](https://docs.databricks.com/aws/en/sql/language-manual/functions/from_unixtime)
*   [from\_utc\_timestamp](https://docs.databricks.com/aws/en/sql/language-manual/functions/from_utc_timestamp)
*   [get](https://docs.databricks.com/aws/en/sql/language-manual/functions/get)
*   [getbit](https://docs.databricks.com/aws/en/sql/language-manual/functions/getbit)
*   [getdate](https://docs.databricks.com/aws/en/sql/language-manual/functions/getdate)
*   [greatest](https://docs.databricks.com/aws/en/sql/language-manual/functions/greatest)
*   [grouping](https://docs.databricks.com/aws/en/sql/language-manual/functions/grouping)
*   [grouping\_id](https://docs.databricks.com/aws/en/sql/language-manual/functions/grouping_id)
*   [h3\_boundaryasgeojson](https://docs.databricks.com/aws/en/sql/language-manual/functions/h3_boundaryasgeojson)
*   [h3\_boundaryaswkb](https://docs.databricks.com/aws/en/sql/language-manual/functions/h3_boundaryaswkb)
*   [h3\_boundaryaswkt](https://docs.databricks.com/aws/en/sql/language-manual/functions/h3_boundaryaswkt)
*   [h3\_centerasgeojson](https://docs.databricks.com/aws/en/sql/language-manual/functions/h3_centerasgeojson)
*   [h3\_centeraswkb](https://docs.databricks.com/aws/en/sql/language-manual/functions/h3_centeraswkb)
*   [h3\_centeraswkt](https://docs.databricks.com/aws/en/sql/language-manual/functions/h3_centeraswkt)
*   [h3\_compact](https://docs.databricks.com/aws/en/sql/language-manual/functions/h3_compact)
*   [h3\_coverash3](https://docs.databricks.com/aws/en/sql/language-manual/functions/h3_coverash3)
*   [h3\_coverash3string](https://docs.databricks.com/aws/en/sql/language-manual/functions/h3_coverash3string)
*   [h3\_distance](https://docs.databricks.com/aws/en/sql/language-manual/functions/h3_distance)
*   [h3\_h3tostring](https://docs.databricks.com/aws/en/sql/language-manual/functions/h3_h3tostring)
*   [h3\_hexring](https://docs.databricks.com/aws/en/sql/language-manual/functions/h3_hexring)
*   [h3\_ischildof](https://docs.databricks.com/aws/en/sql/language-manual/functions/h3_ischildof)
*   [h3\_ispentagon](https://docs.databricks.com/aws/en/sql/language-manual/functions/h3_ispentagon)
*   [h3\_isvalid](https://docs.databricks.com/aws/en/sql/language-manual/functions/h3_isvalid)
*   [h3\_kring](https://docs.databricks.com/aws/en/sql/language-manual/functions/h3_kring)
*   [h3\_kringdistances](https://docs.databricks.com/aws/en/sql/language-manual/functions/h3_kringdistances)
*   [h3\_longlatash3](https://docs.databricks.com/aws/en/sql/language-manual/functions/h3_longlatash3)
*   [h3\_longlatash3string](https://docs.databricks.com/aws/en/sql/language-manual/functions/h3_longlatash3string)
*   [h3\_maxchild](https://docs.databricks.com/aws/en/sql/language-manual/functions/h3_maxchild)
*   [h3\_minchild](https://docs.databricks.com/aws/en/sql/language-manual/functions/h3_minchild)
*   [h3\_pointash3](https://docs.databricks.com/aws/en/sql/language-manual/functions/h3_pointash3)
*   [h3\_pointash3string](https://docs.databricks.com/aws/en/sql/language-manual/functions/h3_pointash3string)
*   [h3\_polyfillash3](https://docs.databricks.com/aws/en/sql/language-manual/functions/h3_polyfillash3)
*   [h3\_polyfillash3string](https://docs.databricks.com/aws/en/sql/language-manual/functions/h3_polyfillash3string)
*   [h3\_resolution](https://docs.databricks.com/aws/en/sql/language-manual/functions/h3_resolution)
*   [h3\_stringtoh3](https://docs.databricks.com/aws/en/sql/language-manual/functions/h3_stringtoh3)
*   [h3\_tessellateaswkb](https://docs.databricks.com/aws/en/sql/language-manual/functions/h3_tessellateaswkb)
*   [h3\_tochildren](https://docs.databricks.com/aws/en/sql/language-manual/functions/h3_tochildren)
*   [h3\_toparent](https://docs.databricks.com/aws/en/sql/language-manual/functions/h3_toparent)
*   [h3\_try\_coverash3](https://docs.databricks.com/aws/en/sql/language-manual/functions/h3_try_coverash3)
*   [h3\_try\_coverash3string](https://docs.databricks.com/aws/en/sql/language-manual/functions/h3_try_coverash3string)
*   [h3\_try\_distance](https://docs.databricks.com/aws/en/sql/language-manual/functions/h3_try_distance)
*   [h3\_try\_polyfillash3](https://docs.databricks.com/aws/en/sql/language-manual/functions/h3_try_polyfillash3)
*   [h3\_try\_polyfillash3string](https://docs.databricks.com/aws/en/sql/language-manual/functions/h3_try_polyfillash3string)
*   [h3\_try\_tessellateaswkb](https://docs.databricks.com/aws/en/sql/language-manual/functions/h3_try_tessellateaswkb)
*   [h3\_try\_validate](https://docs.databricks.com/aws/en/sql/language-manual/functions/h3_try_validate)
*   [h3\_uncompact](https://docs.databricks.com/aws/en/sql/language-manual/functions/h3_uncompact)
*   [h3\_validate](https://docs.databricks.com/aws/en/sql/language-manual/functions/h3_validate)
*   [hash](https://docs.databricks.com/aws/en/sql/language-manual/functions/hash)
*   [hex](https://docs.databricks.com/aws/en/sql/language-manual/functions/hex)
*   [histogram\_numeric](https://docs.databricks.com/aws/en/sql/language-manual/functions/histogram_numeric)
*   [hll\_sketch\_agg](https://docs.databricks.com/aws/en/sql/language-manual/functions/hll_sketch_agg)
*   [hll\_union\_agg](https://docs.databricks.com/aws/en/sql/language-manual/functions/hll_union_agg)
*   [hour](https://docs.databricks.com/aws/en/sql/language-manual/functions/hour)
*   [hypot](https://docs.databricks.com/aws/en/sql/language-manual/functions/hypot)
*   [if](https://docs.databricks.com/aws/en/sql/language-manual/functions/if)
*   [iff](https://docs.databricks.com/aws/en/sql/language-manual/functions/iff)
*   [ifnull](https://docs.databricks.com/aws/en/sql/language-manual/functions/ifnull)
*   [ilike](https://docs.databricks.com/aws/en/sql/language-manual/functions/ilike)
*   [in](https://docs.databricks.com/aws/en/sql/language-manual/functions/in)
*   [inline](https://docs.databricks.com/aws/en/sql/language-manual/functions/inline)
*   [inline\_outer](https://docs.databricks.com/aws/en/sql/language-manual/functions/inline_outer)
*   [int](https://docs.databricks.com/aws/en/sql/language-manual/functions/int)
*   [isnan](https://docs.databricks.com/aws/en/sql/language-manual/functions/isnan)
*   [isnotnull](https://docs.databricks.com/aws/en/sql/language-manual/functions/isnotnull)
*   [isnull](https://docs.databricks.com/aws/en/sql/language-manual/functions/isnull)
*   [kurtosis](https://docs.databricks.com/aws/en/sql/language-manual/functions/kurtosis)
*   [lag](https://docs.databricks.com/aws/en/sql/language-manual/functions/lag)
*   [last](https://docs.databricks.com/aws/en/sql/language-manual/functions/last)
*   [last\_day](https://docs.databricks.com/aws/en/sql/language-manual/functions/last_day)
*   [last\_value](https://docs.databricks.com/aws/en/sql/language-manual/functions/last_value)
*   [lead](https://docs.databricks.com/aws/en/sql/language-manual/functions/lead)
*   [least](https://docs.databricks.com/aws/en/sql/language-manual/functions/least)
*   [left](https://docs.databricks.com/aws/en/sql/language-manual/functions/left)
*   [len](https://docs.databricks.com/aws/en/sql/language-manual/functions/len)
*   [length](https://docs.databricks.com/aws/en/sql/language-manual/functions/length)
*   [levenshtein](https://docs.databricks.com/aws/en/sql/language-manual/functions/levenshtein)
*   [like](https://docs.databricks.com/aws/en/sql/language-manual/functions/like)
*   [ln](https://docs.databricks.com/aws/en/sql/language-manual/functions/ln)
*   `localtimestamp`
*   [log](https://docs.databricks.com/aws/en/sql/language-manual/functions/log)
*   [log10](https://docs.databricks.com/aws/en/sql/language-manual/functions/log10)
*   [log1p](https://docs.databricks.com/aws/en/sql/language-manual/functions/log1p)
*   [log2](https://docs.databricks.com/aws/en/sql/language-manual/functions/log2)
*   [lower](https://docs.databricks.com/aws/en/sql/language-manual/functions/lower)
*   [luhn\_check](https://docs.databricks.com/aws/en/sql/language-manual/functions/luhn_check)
*   [make\_date](https://docs.databricks.com/aws/en/sql/language-manual/functions/make_date)
*   [make\_dt\_interval](https://docs.databricks.com/aws/en/sql/language-manual/functions/make_dt_interval)
*   [make\_interval](https://docs.databricks.com/aws/en/sql/language-manual/functions/make_interval)
*   [make\_timestamp](https://docs.databricks.com/aws/en/sql/language-manual/functions/make_timestamp)
*   `make_timestamp_ltz`
*   `make_timestamp_ntz`
*   [make\_ym\_interval](https://docs.databricks.com/aws/en/sql/language-manual/functions/make_ym_interval)
*   [map](https://docs.databricks.com/aws/en/sql/language-manual/functions/map)
*   [map\_concat](https://docs.databricks.com/aws/en/sql/language-manual/functions/map_concat)
*   [map\_contains\_key](https://docs.databricks.com/aws/en/sql/language-manual/functions/map_contains_key)
*   [map\_entries](https://docs.databricks.com/aws/en/sql/language-manual/functions/map_entries)
*   [map\_filter](https://docs.databricks.com/aws/en/sql/language-manual/functions/map_filter)
*   [map\_from\_arrays](https://docs.databricks.com/aws/en/sql/language-manual/functions/map_from_arrays)
*   [map\_from\_entries](https://docs.databricks.com/aws/en/sql/language-manual/functions/map_from_entries)
*   [map\_keys](https://docs.databricks.com/aws/en/sql/language-manual/functions/map_keys)
*   [map\_values](https://docs.databricks.com/aws/en/sql/language-manual/functions/map_values)
*   [map\_zip\_with](https://docs.databricks.com/aws/en/sql/language-manual/functions/map_zip_with)
*   [max](https://docs.databricks.com/aws/en/sql/language-manual/functions/max)
*   [max\_by](https://docs.databricks.com/aws/en/sql/language-manual/functions/max_by)
*   [md5](https://docs.databricks.com/aws/en/sql/language-manual/functions/md5)
*   [mean](https://docs.databricks.com/aws/en/sql/language-manual/functions/mean)
*   [median](https://docs.databricks.com/aws/en/sql/language-manual/functions/median)
*   [min](https://docs.databricks.com/aws/en/sql/language-manual/functions/min)
*   [min\_by](https://docs.databricks.com/aws/en/sql/language-manual/functions/min_by)
*   [minute](https://docs.databricks.com/aws/en/sql/language-manual/functions/minute)
*   [mod](https://docs.databricks.com/aws/en/sql/language-manual/functions/mod)
*   [mode](https://docs.databricks.com/aws/en/sql/language-manual/functions/mode)
*   [month](https://docs.databricks.com/aws/en/sql/language-manual/functions/month)
*   `monthname`
*   [months\_between](https://docs.databricks.com/aws/en/sql/language-manual/functions/months_between)
*   [named\_struct](https://docs.databricks.com/aws/en/sql/language-manual/functions/named_struct)
*   [nanvl](https://docs.databricks.com/aws/en/sql/language-manual/functions/nanvl)
*   [negative](https://docs.databricks.com/aws/en/sql/language-manual/functions/negative)
*   [next\_day](https://docs.databricks.com/aws/en/sql/language-manual/functions/next_day)
*   [not](https://docs.databricks.com/aws/en/sql/language-manual/functions/not)
*   [now](https://docs.databricks.com/aws/en/sql/language-manual/functions/now)
*   [nth\_value](https://docs.databricks.com/aws/en/sql/language-manual/functions/nth_value)
*   [ntile](https://docs.databricks.com/aws/en/sql/language-manual/functions/ntile)
*   [nullif](https://docs.databricks.com/aws/en/sql/language-manual/functions/nullif)
*   [octet\_length](https://docs.databricks.com/aws/en/sql/language-manual/functions/octet_length)
*   [or](https://docs.databricks.com/aws/en/sql/language-manual/functions/or)
*   [overlay](https://docs.databricks.com/aws/en/sql/language-manual/functions/overlay)
*   [percent\_rank](https://docs.databricks.com/aws/en/sql/language-manual/functions/percent_rank)
*   [percentile](https://docs.databricks.com/aws/en/sql/language-manual/functions/percentile)
*   [percentile\_approx](https://docs.databricks.com/aws/en/sql/language-manual/functions/percentile_approx)
*   [percentile\_cont](https://docs.databricks.com/aws/en/sql/language-manual/functions/percentile_cont)
*   [percentile\_disc](https://docs.databricks.com/aws/en/sql/language-manual/functions/percentile_disc)
*   [pi](https://docs.databricks.com/aws/en/sql/language-manual/functions/pi)
*   [pmod](https://docs.databricks.com/aws/en/sql/language-manual/functions/pmod)
*   [position](https://docs.databricks.com/aws/en/sql/language-manual/functions/position)
*   [positive](https://docs.databricks.com/aws/en/sql/language-manual/functions/positive)
*   [pow](https://docs.databricks.com/aws/en/sql/language-manual/functions/pow)
*   [power](https://docs.databricks.com/aws/en/sql/language-manual/functions/power)
*   [printf](https://docs.databricks.com/aws/en/sql/language-manual/functions/printf)
*   [quarter](https://docs.databricks.com/aws/en/sql/language-manual/functions/quarter)
*   [radians](https://docs.databricks.com/aws/en/sql/language-manual/functions/radians)
*   [rand](https://docs.databricks.com/aws/en/sql/language-manual/functions/rand)
*   [randn](https://docs.databricks.com/aws/en/sql/language-manual/functions/randn)
*   [random](https://docs.databricks.com/aws/en/sql/language-manual/functions/random)
*   [rank](https://docs.databricks.com/aws/en/sql/language-manual/functions/rank)
*   [reduce](https://docs.databricks.com/aws/en/sql/language-manual/functions/reduce)
*   [regexp](https://docs.databricks.com/aws/en/sql/language-manual/functions/regexp)
*   [regexp\_extract](https://docs.databricks.com/aws/en/sql/language-manual/functions/regexp_extract)
*   [regexp\_extract\_all](https://docs.databricks.com/aws/en/sql/language-manual/functions/regexp_extract_all)
*   [regexp\_like](https://docs.databricks.com/aws/en/sql/language-manual/functions/regexp_like)
*   [regexp\_replace](https://docs.databricks.com/aws/en/sql/language-manual/functions/regexp_replace)
*   [regr\_avgx](https://docs.databricks.com/aws/en/sql/language-manual/functions/regr_avgx)
*   [regr\_avgy](https://docs.databricks.com/aws/en/sql/language-manual/functions/regr_avgy)
*   [regr\_count](https://docs.databricks.com/aws/en/sql/language-manual/functions/regr_count)
*   [regr\_intercept](https://docs.databricks.com/aws/en/sql/language-manual/functions/regr_intercept)
*   [regr\_r2](https://docs.databricks.com/aws/en/sql/language-manual/functions/regr_r2)
*   [regr\_slope](https://docs.databricks.com/aws/en/sql/language-manual/functions/regr_slope)
*   [regr\_sxx](https://docs.databricks.com/aws/en/sql/language-manual/functions/regr_sxx)
*   [regr\_sxy](https://docs.databricks.com/aws/en/sql/language-manual/functions/regr_sxy)
*   [regr\_syy](https://docs.databricks.com/aws/en/sql/language-manual/functions/regr_syy)
*   [repeat](https://docs.databricks.com/aws/en/sql/language-manual/functions/repeat)
*   [replace](https://docs.databricks.com/aws/en/sql/language-manual/functions/replace)
*   [reverse](https://docs.databricks.com/aws/en/sql/language-manual/functions/reverse)
*   [right](https://docs.databricks.com/aws/en/sql/language-manual/functions/right)
*   [rint](https://docs.databricks.com/aws/en/sql/language-manual/functions/rint)
*   [rlike](https://docs.databricks.com/aws/en/sql/language-manual/functions/rlike)
*   [round](https://docs.databricks.com/aws/en/sql/language-manual/functions/round)
*   [row\_number](https://docs.databricks.com/aws/en/sql/language-manual/functions/row_number)
*   [rpad](https://docs.databricks.com/aws/en/sql/language-manual/functions/rpad)
*   [rtrim](https://docs.databricks.com/aws/en/sql/language-manual/functions/rtrim)
*   [sec](https://docs.databricks.com/aws/en/sql/language-manual/functions/sec)
*   [second](https://docs.databricks.com/aws/en/sql/language-manual/functions/second)
*   [sequence](https://docs.databricks.com/aws/en/sql/language-manual/functions/sequence)
*   [session\_window](https://docs.databricks.com/aws/en/sql/language-manual/functions/session_window)
*   [sha](https://docs.databricks.com/aws/en/sql/language-manual/functions/sha)
*   [sha1](https://docs.databricks.com/aws/en/sql/language-manual/functions/sha1)
*   [sha2](https://docs.databricks.com/aws/en/sql/language-manual/functions/sha2)
*   [shiftleft](https://docs.databricks.com/aws/en/sql/language-manual/functions/shiftleft)
*   [shiftright](https://docs.databricks.com/aws/en/sql/language-manual/functions/shiftright)
*   [shiftrightunsigned](https://docs.databricks.com/aws/en/sql/language-manual/functions/shiftrightunsigned)
*   [shuffle](https://docs.databricks.com/aws/en/sql/language-manual/functions/shuffle)
*   [sign](https://docs.databricks.com/aws/en/sql/language-manual/functions/sign)
*   [signum](https://docs.databricks.com/aws/en/sql/language-manual/functions/signum)
*   [sin](https://docs.databricks.com/aws/en/sql/language-manual/functions/sin)
*   [sinh](https://docs.databricks.com/aws/en/sql/language-manual/functions/sinh)
*   [size](https://docs.databricks.com/aws/en/sql/language-manual/functions/size)
*   [skewness](https://docs.databricks.com/aws/en/sql/language-manual/functions/skewness)
*   [slice](https://docs.databricks.com/aws/en/sql/language-manual/functions/slice)
*   [smallint](https://docs.databricks.com/aws/en/sql/language-manual/functions/smallint)
*   [some](https://docs.databricks.com/aws/en/sql/language-manual/functions/some)
*   [sort\_array](https://docs.databricks.com/aws/en/sql/language-manual/functions/sort_array)
*   [split](https://docs.databricks.com/aws/en/sql/language-manual/functions/split)
*   [split\_part](https://docs.databricks.com/aws/en/sql/language-manual/functions/split_part)
*   [sqrt](https://docs.databricks.com/aws/en/sql/language-manual/functions/sqrt)
*   [stack](https://docs.databricks.com/aws/en/sql/language-manual/functions/stack)
*   [startswith](https://docs.databricks.com/aws/en/sql/language-manual/functions/startswith)
*   [std](https://docs.databricks.com/aws/en/sql/language-manual/functions/std)
*   [stddev](https://docs.databricks.com/aws/en/sql/language-manual/functions/stddev)
*   [stddev\_pop](https://docs.databricks.com/aws/en/sql/language-manual/functions/stddev_pop)
*   [stddev\_samp](https://docs.databricks.com/aws/en/sql/language-manual/functions/stddev_samp)
*   [str\_to\_map](https://docs.databricks.com/aws/en/sql/language-manual/functions/str_to_map)
*   [string](https://docs.databricks.com/aws/en/sql/language-manual/functions/string)
*   `stringdecode`
*   [struct](https://docs.databricks.com/aws/en/sql/language-manual/functions/struct)
*   [substr](https://docs.databricks.com/aws/en/sql/language-manual/functions/substr)
*   [substring](https://docs.databricks.com/aws/en/sql/language-manual/functions/substring)
*   [substring\_index](https://docs.databricks.com/aws/en/sql/language-manual/functions/substring_index)
*   [sum](https://docs.databricks.com/aws/en/sql/language-manual/functions/sum)
*   [tan](https://docs.databricks.com/aws/en/sql/language-manual/functions/tan)
*   [tanh](https://docs.databricks.com/aws/en/sql/language-manual/functions/tanh)
*   [timestamp](https://docs.databricks.com/aws/en/sql/language-manual/functions/timestamp)
*   [timestamp\_micros](https://docs.databricks.com/aws/en/sql/language-manual/functions/timestamp_micros)
*   [timestamp\_millis](https://docs.databricks.com/aws/en/sql/language-manual/functions/timestamp_millis)
*   [timestamp\_seconds](https://docs.databricks.com/aws/en/sql/language-manual/functions/timestamp_seconds)
*   [tinyint](https://docs.databricks.com/aws/en/sql/language-manual/functions/tinyint)
*   [to\_binary](https://docs.databricks.com/aws/en/sql/language-manual/functions/to_binary)
*   [to\_char](https://docs.databricks.com/aws/en/sql/language-manual/functions/to_char)
*   [to\_date](https://docs.databricks.com/aws/en/sql/language-manual/functions/to_date)
*   `to_geography`
*   `to_geometry`
*   [to\_number](https://docs.databricks.com/aws/en/sql/language-manual/functions/to_number)
*   [to\_timestamp](https://docs.databricks.com/aws/en/sql/language-manual/functions/to_timestamp)
*   `to_timestamp_ltz`
*   `to_timestamp_ntz`
*   [to\_unix\_timestamp](https://docs.databricks.com/aws/en/sql/language-manual/functions/to_unix_timestamp)
*   [to\_utc\_timestamp](https://docs.databricks.com/aws/en/sql/language-manual/functions/to_utc_timestamp)
*   [to\_varchar](https://docs.databricks.com/aws/en/sql/language-manual/functions/to_varchar)
*   [transform](https://docs.databricks.com/aws/en/sql/language-manual/functions/transform)
*   [transform\_keys](https://docs.databricks.com/aws/en/sql/language-manual/functions/transform_keys)
*   [transform\_values](https://docs.databricks.com/aws/en/sql/language-manual/functions/transform_values)
*   [trim](https://docs.databricks.com/aws/en/sql/language-manual/functions/trim)
*   [trunc](https://docs.databricks.com/aws/en/sql/language-manual/functions/trunc)
*   [try\_add](https://docs.databricks.com/aws/en/sql/language-manual/functions/try_add)
*   [try\_avg](https://docs.databricks.com/aws/en/sql/language-manual/functions/try_avg)
*   [try\_divide](https://docs.databricks.com/aws/en/sql/language-manual/functions/try_divide)
*   [try\_mod](https://docs.databricks.com/aws/en/sql/language-manual/functions/try_mod)
*   [try\_multiply](https://docs.databricks.com/aws/en/sql/language-manual/functions/try_multiply)
*   `try_remainder`
*   [try\_subtract](https://docs.databricks.com/aws/en/sql/language-manual/functions/try_subtract)
*   [try\_sum](https://docs.databricks.com/aws/en/sql/language-manual/functions/try_sum)
*   [try\_to\_binary](https://docs.databricks.com/aws/en/sql/language-manual/functions/try_to_binary)
*   `try_to_geography`
*   `try_to_geometry`
*   [try\_to\_number](https://docs.databricks.com/aws/en/sql/language-manual/functions/try_to_number)
*   [try\_to\_timestamp](https://docs.databricks.com/aws/en/sql/language-manual/functions/try_to_timestamp)
*   [typeof](https://docs.databricks.com/aws/en/sql/language-manual/functions/typeof)
*   [ucase](https://docs.databricks.com/aws/en/sql/language-manual/functions/ucase)
*   [unbase64](https://docs.databricks.com/aws/en/sql/language-manual/functions/unbase64)
*   [unhex](https://docs.databricks.com/aws/en/sql/language-manual/functions/unhex)
*   [unix\_date](https://docs.databricks.com/aws/en/sql/language-manual/functions/unix_date)
*   [unix\_micros](https://docs.databricks.com/aws/en/sql/language-manual/functions/unix_micros)
*   [unix\_millis](https://docs.databricks.com/aws/en/sql/language-manual/functions/unix_millis)
*   [unix\_seconds](https://docs.databricks.com/aws/en/sql/language-manual/functions/unix_seconds)
*   [unix\_timestamp](https://docs.databricks.com/aws/en/sql/language-manual/functions/unix_timestamp)
*   [upper](https://docs.databricks.com/aws/en/sql/language-manual/functions/upper)
*   [url\_decode](https://docs.databricks.com/aws/en/sql/language-manual/functions/url_decode)
*   [url\_encode](https://docs.databricks.com/aws/en/sql/language-manual/functions/url_encode)
*   [uuid](https://docs.databricks.com/aws/en/sql/language-manual/functions/uuid)
*   [var\_pop](https://docs.databricks.com/aws/en/sql/language-manual/functions/var_pop)
*   [var\_samp](https://docs.databricks.com/aws/en/sql/language-manual/functions/var_samp)
*   [variance](https://docs.databricks.com/aws/en/sql/language-manual/functions/variance)
*   [version](https://docs.databricks.com/aws/en/sql/language-manual/functions/version)
*   [weekday](https://docs.databricks.com/aws/en/sql/language-manual/functions/weekday)
*   [weekofyear](https://docs.databricks.com/aws/en/sql/language-manual/functions/weekofyear)
*   `when`
*   [width\_bucket](https://docs.databricks.com/aws/en/sql/language-manual/functions/width_bucket)
*   [window](https://docs.databricks.com/aws/en/sql/language-manual/functions/window)
*   [window\_time](https://docs.databricks.com/aws/en/sql/language-manual/functions/window_time)
*   [year](https://docs.databricks.com/aws/en/sql/language-manual/functions/year)
*   [zip\_with](https://docs.databricks.com/aws/en/sql/language-manual/functions/zip_with)
