Alphabetical list of built-in functions
Applies to: Databricks SQL Databricks Runtime
This article provides an alphabetically-ordered list of built-in functions and operators in Databricks.
abs
functionacos
functionacosh
functionadd_months
functionaes_decrypt
functionaes_encrypt
functionaggregate
functionai_analyze_sentiment
functionai_classify
functionai_extract
functionai_fix_grammar
functionai_forecast
functionai_gen
functionai_generate_text
functionai_mask
functionai_query
functionai_similarity
functionai_summarize
functionai_translate
function&
(ampersand sign) operatorand
predicateany
aggregate functionany_value
aggregate functionapprox_count_distinct
aggregate functionapprox_percentile
aggregate functionapprox_top_k
aggregate functionarray
functionarray_agg
aggregate functionarray_append
functionarray_compact
functionarray_contains
functionarray_distinct
functionarray_except
functionarray_insert
functionarray_intersect
functionarray_join
functionarray_max
functionarray_min
functionarray_position
functionarray_prepend
functionarray_remove
functionarray_repeat
functionarray_size
functionarray_sort
functionarray_union
functionarrays_overlap
functionarrays_zip
functionascii
functionasin
functionasinh
functionassert_true
function*
(asterisk sign) operatoratan
functionatan2
functionatanh
functionavg
aggregate function!=
(bangeq sign) operator!
(bang sign) operatorbase64
functionbetween
predicatebigint
functionbin
functionbinary
functionbit_and
aggregate functionbit_count
functionbit_get
functionbit_length
functionbit_or
aggregate functionbit_reverse
functionbit_xor
aggregate functionbitmap_bit_position
functionbitmap_bucket_number
functionbitmap_construct_agg
aggregate functionbitmap_count
functionbitmap_or_agg
aggregate functionbool_and
aggregate functionbool_or
aggregate functionboolean
function[ ]
(bracket sign) operatorbround
functionbtrim
functioncardinality
function^
(caret sign) operatorcase
expressioncast
functioncbrt
functionceil
functionceiling
functionchar
functionchar_length
functioncharacter_length
functioncharindex
functionchr
functioncloud_files_state
table-valued functioncoalesce
functioncollect_list
aggregate functioncollect_set
aggregate function::
(colon colon sign) operator:
(colon sign) operatorconcat
functionconcat_ws
functioncontains
functionconv
functionconvert_timezone
functioncorr
aggregate functioncos
functioncosh
functioncot
functioncount
aggregate functioncount_if
aggregate functioncount_min_sketch
aggregate functioncovar_pop
aggregate functioncovar_samp
aggregate functioncrc32
functioncsc
functioncube
functioncume_dist
analytic window functioncurdate
functioncurrent_catalog
functioncurrent_database
functioncurrent_date
functioncurrent_metastore
functioncurrent_recipient
functioncurrent_schema
functioncurrent_timestamp
functioncurrent_timezone
functioncurrent_user
functioncurrent_version
functiondate
functiondate_add
(days) functiondate_add
functiondate_diff
functiondate_format
functiondate_from_unix_date
functiondate_part
functiondate_sub
functiondate_trunc
functiondateadd
functiondateadd
(days) functiondatediff
functiondatediff
(timestamp) functionday
functiondayofmonth
functiondayofweek
functiondayofyear
functiondecimal
functiondecode
(key) functiondecode
(character set) functiondegrees
functiondense_rank
ranking window functiondiv
operator.
(dot sign) operatordouble
functione
functionelement_at
functionelt
functionencode
functionendswith
function==
(eq eq sign) operator=
(eq sign) operatorequal_null
functionevent_log
table-valued functionevery
aggregate functionexists
functionexp
functionexplode
table-valued generator functionexplode_outer
table-valued generator functionexpm1
functionextract
functionfactorial
functionfilter
functionfind_in_set
functionfirst
aggregate functionfirst_value
aggregate functionflatten
functionfloat
functionfloor
functionforall
functionformat_number
functionformat_string
functionfrom_avro
functionfrom_csv
functionfrom_json
functionfrom_unixtime
functionfrom_utc_timestamp
functionfrom_xml
functionget
functionget_json_object
functiongetbit
functiongetdate
functiongreatest
functiongrouping
functiongrouping_id
function>=
(gt eq sign) operator>
(gt sign) operatorh3_boundaryasgeojson
functionh3_boundaryaswkb
functionh3_boundaryaswkt
functionh3_centerasgeojson
functionh3_centeraswkb
functionh3_centeraswkt
functionh3_compact
functionh3_coverash3
functionh3_coverash3string
functionh3_distance
functionh3_h3tostring
functionh3_hexring
functionh3_ischildof
functionh3_ispentagon
functionh3_isvalid
functionh3_kring
functionh3_kringdistances
functionh3_longlatash3
functionh3_longlatash3string
functionh3_maxchild
functionh3_minchild
functionh3_pointash3
functionh3_pointash3string
functionh3_polyfillash3
functionh3_polyfillash3string
functionh3_resolution
functionh3_stringtoh3
functionh3_tessellateaswkb
functionh3_tochildren
functionh3_toparent
functionh3_try_distance
functionh3_try_polyfillash3
functionh3_try_polyfillash3string
functionh3_try_validate
functionh3_uncompact
functionh3_validate
functionhash
functionhex
functionhistogram_numeric
aggregate functionhll_sketch_agg
aggregate functionhll_sketch_estimate
functionhll_union
functionhll_union_agg
functionhour
functionhypot
functionif
functioniff
functionifnull
functionilike
operatorin
predicateinitcap
functioninline
table-valued generator functioninline_outer
table-valued generator functioninput_file_block_length
functioninput_file_block_start
functioninput_file_name
functioninstr
functionint
functionis_account_group_member
functionis_member
functionis_valid_utf8
functionis_variant_null
functionis distinct
operatoris false
operatorisnan
functionisnotnull
functionisnull
functionis null
operatoris true
operatorjava_method
functionjson_array_length
functionjson_object_keys
functionjson_tuple
table-valued generator functionkurtosis
aggregate functionlag
analytic window functionlast
aggregate functionlast_day
functionlast_value
aggregate functionlcase
functionlead
analytic window functionleast
functionleft
functionlen
functionlength
functionlevenshtein
functionlike
operatorlist_secrets
table functionln
functionlocate
functionlog
functionlog10
functionlog1p
functionlog2
functionlower
functionlpad
function<=>
(lt eq gt sign) operator<=
(lt eq sign) operator<>
(lt gt sign) operatorltrim
function<
(lt sign) operatorluhn_check
functionmake_date
functionmake_dt_interval
functionmake_interval
functionmake_timestamp
functionmake_valid_utf8
functionmake_ym_interval
functionmap
functionmap_concat
functionmap_contains_key
functionmap_entries
functionmap_filter
functionmap_from_arrays
functionmap_from_entries
functionmap_keys
functionmap_values
functionmap_zip_with
functionmask
functionmax
aggregate functionmax_by
aggregate functionmd5
functionmean
aggregate functionmedian
aggregate functionmin
aggregate functionmin_by
aggregate function-
(minus sign) operator-
(minus sign) unary operatorminute
functionmod
functionmode
aggregate functionmonotonically_increasing_id
functionmonth
functionmonths_between
functionnamed_struct
functionnanvl
functionnegative
functionnext_day
functionnot
operatornow
functionnth_value
analytic window functionntile
ranking window functionnullif
functionnullifzero
functionnvl
functionnvl2
functionoctet_length
functionor
operatoroverlay
functionparse_json
functionparse_url
functionpercent_rank
ranking window functionpercentile
aggregate functionpercentile_approx
aggregate functionpercentile_cont
aggregate functionpercentile_disc
aggregate function%
(percent sign) operatorpi
function||
(pipe pipe sign) operator|
(pipe sign) operator+
(plus sign) operator+
(plus sign) unary operatorpmod
functionposexplode
table-valued generator functionposexplode_outer
table-valued generator functionposition
functionpositive
functionpow
functionpower
functionprintf
functionquarter
function?::
(triple colon sign) operatorradians
functionraise_error
functionrand
functionrandn
functionrandom
functionrange
table-valued functionrank
ranking window functionread_files
table-valued functionread_kafka
table-valued functionread_kinesis
streaming table-valued functionread_pubsub
streaming table-valued functionread_pulsar
streaming table-valued functionread_state_metadata
table-valued functionread_statestore
table-valued functionreduce
functionreflect
functionregexp
operatorregexp_count
functionregexp_extract
functionregexp_extract_all
functionregexp_instr
functionregexp_like
functionregexp_replace
functionregexp_substr
functionregr_avgx
aggregate functionregr_avgy
aggregate functionregr_count
aggregate functionregr_intercept
aggregate functionregr_r2
aggregate functionregr_slope
aggregate functionregr_sxx
aggregate functionregr_sxy
aggregate functionregr_syy
aggregate functionrepeat
functionreplace
functionreverse
functionright
functionrint
functionrlike
operatorround
functionrow_number
ranking window functionrpad
functionrtrim
functionschema_of_csv
functionschema_of_json
functionschema_of_json_agg
aggregate functionschema_of_variant
functionschema_of_variant_agg
aggregate functionschema_of_xml
functionsec
functionsecond
functionsecret
functionsentences
functionsequence
functionsession_user
functionsession_window
grouping expressionsha
functionsha1
functionsha2
functionshiftleft
functionshiftright
functionshiftrightunsigned
functionshuffle
functionsign
functionsignum
functionsin
functionsinh
functionsize
functionskewness
aggregate function/
(slash sign) operatorslice
functionsmallint
functionsome
aggregate functionsort_array
functionsoundex
functionspace
functionspark_partition_id
functionsplit
functionsplit_part
functionsql_keywords
functionsqrt
functionstack
table-valued generator functionstartswith
functionstd
aggregate functionstddev
aggregate functionstddev_pop
aggregate functionstddev_samp
aggregate functionstr_to_map
functionstring
functionstruct
functionsubstr
functionsubstring
functionsubstring_index
functionsum
aggregate functiontable_changes
table-valued functiontan
functiontanh
function~
(tilde sign) operatortimediff
functiontimestamp
functiontimestamp_micros
functiontimestamp_millis
functiontimestamp_seconds
functiontimestampadd
functiontimestampdiff
functiontinyint
functionto_avro
functionto_binary
functionto_char
functionto_csv
functionto_date
functionto_json
functionto_number
functionto_timestamp
functionto_unix_timestamp
functionto_utc_timestamp
functionto_varchar
functionto_xml
functiontransform
functiontransform_keys
functiontransform_values
functiontranslate
functiontrim
functiontrunc
functiontry_add
functiontry_aes_decrypt
functiontry_avg
aggregate functiontry_cast
functiontry_divide
functiontry_element_at
functiontry_mod
functiontry_multiply
functiontry_parse_json
functiontry_reflect
functiontry_secret
functiontry_subtract
functiontry_sum
aggregate functiontry_to_binary
functiontry_to_number
functiontry_to_timestamp
functiontry_url_decode
functiontry_validate_utf8
functiontry_variant_get
functiontry_zstd_decompress
functiontypeof
functionucase
functionunbase64
functionunhex
functionunix_date
functionunix_micros
functionunix_millis
functionunix_seconds
functionunix_timestamp
functionupper
functionurl_decode
functionurl_encode
functionuser
functionuuid
functionvalidate_utf8
functionvar_pop
aggregate functionvar_samp
aggregate functionvariance
aggregate functionvariant_explode
table-valued functionvariant_explode_outer
table-valued functionvariant_get
functionvector_search
functionversion
functionweekday
functionweekofyear
functionwidth_bucket
functionwindow
grouping expressionwindow_time
functionxpath
functionxpath_boolean
functionxpath_double
functionxpath_float
functionxpath_int
functionxpath_long
functionxpath_number
functionxpath_short
functionxpath_string
functionxxhash64
functionyear
functionzeroifnull
functionzip_with
functionzstd_compress
functionzstd_decompress
function