Amazon
Web Services
Microsoft Azure
Google Cloud PlatformAlphabetical list of built-in functions
October 10, 2023
Applies to: 
Databricks SQL Databricks Runtime
This article provides an alphabetically-ordered list of built-in functions and operators in Databricks.
absfunctionacosfunctionacoshfunctionadd_monthsfunctionaes_decryptfunctionaes_encryptfunctionaggregatefunctionai_analyze_sentimentfunctionai_classifyfunctionai_extractfunctionai_fix_grammarfunctionai_forecastfunctionai_genfunctionai_generate_textfunctionai_maskfunctionai_queryfunctionai_similarityfunctionai_summarizefunctionai_translatefunction&(ampersand sign) operatorandpredicateanyaggregate functionany_valueaggregate functionapprox_count_distinctaggregate functionapprox_percentileaggregate functionapprox_top_kaggregate functionarrayfunctionarray_aggaggregate functionarray_appendfunctionarray_compactfunctionarray_containsfunctionarray_distinctfunctionarray_exceptfunctionarray_insertfunctionarray_intersectfunctionarray_joinfunctionarray_maxfunctionarray_minfunctionarray_positionfunctionarray_prependfunctionarray_removefunctionarray_repeatfunctionarray_sizefunctionarray_sortfunctionarray_unionfunctionarrays_overlapfunctionarrays_zipfunctionasciifunctionasinfunctionasinhfunctionassert_truefunction*(asterisk sign) operatoratanfunctionatan2functionatanhfunctionavgaggregate function!=(bangeq sign) operator!(bang sign) operatorbase64functionbetweenpredicatebigintfunctionbinfunctionbinaryfunctionbit_andaggregate functionbit_countfunctionbit_getfunctionbit_lengthfunctionbit_oraggregate functionbit_reversefunctionbit_xoraggregate functionbitmap_bit_positionfunctionbitmap_bucket_numberfunctionbitmap_construct_aggaggregate functionbitmap_countfunctionbitmap_or_aggaggregate functionbool_andaggregate functionbool_oraggregate functionbooleanfunction[ ](bracket sign) operatorbroundfunctionbtrimfunctioncardinalityfunction^(caret sign) operatorcaseexpressioncastfunctioncbrtfunctionceilfunctionceilingfunctioncharfunctionchar_lengthfunctioncharacter_lengthfunctioncharindexfunctionchrfunctioncloud_files_statetable-valued functioncoalescefunctioncollateexpressioncollationfunctioncollationstable functioncollect_listaggregate functioncollect_setaggregate function::(colon colon sign) operator:(colon sign) operatorconcatfunctionconcat_wsfunctioncontainsfunctionconvfunctionconvert_timezonefunctioncorraggregate functioncosfunctioncoshfunctioncotfunctioncountaggregate functioncount_ifaggregate functioncount_min_sketchaggregate functioncovar_popaggregate functioncovar_sampaggregate functioncrc32functioncscfunctioncubefunctioncume_distanalytic window functioncurdatefunctioncurrent_catalogfunctioncurrent_databasefunctioncurrent_datefunctioncurrent_metastorefunctioncurrent_recipientfunctioncurrent_schemafunctioncurrent_timestampfunctioncurrent_timezonefunctioncurrent_userfunctioncurrent_versionfunctiondatefunctiondate_add(days) functiondate_addfunctiondate_difffunctiondate_formatfunctiondate_from_unix_datefunctiondate_partfunctiondate_subfunctiondate_truncfunctiondateaddfunctiondateadd(days) functiondatedifffunctiondatediff(timestamp) functiondayfunctiondaynamefunctiondayofmonthfunctiondayofweekfunctiondayofyearfunctiondecimalfunctiondecode(key) functiondecode(character set) functiondegreesfunctiondense_rankranking window functiondivoperator.(dot sign) operatordoublefunctionefunctionelement_atfunctioneltfunctionencodefunctionendswithfunction==(eq eq sign) operator=(eq sign) operatorequal_nullfunctionevent_logtable-valued functioneveryaggregate functionexistsfunctionexpfunctionexplodetable-valued generator functionexplode_outertable-valued generator functionexpm1functionextractfunctionfactorialfunctionfilterfunctionfind_in_setfunctionfirstaggregate functionfirst_valueaggregate functionflattenfunctionfloatfunctionfloorfunctionforallfunctionformat_numberfunctionformat_stringfunctionfrom_avrofunctionfrom_csvfunctionfrom_jsonfunctionfrom_unixtimefunctionfrom_utc_timestampfunctionfrom_xmlfunctiongetfunctionget_json_objectfunctiongetbitfunctiongetdatefunctiongreatestfunctiongroupingfunctiongrouping_idfunction>=(gt eq sign) operator>(gt sign) operatorh3_boundaryasgeojsonfunctionh3_boundaryaswkbfunctionh3_boundaryaswktfunctionh3_centerasgeojsonfunctionh3_centeraswkbfunctionh3_centeraswktfunctionh3_compactfunctionh3_coverash3functionh3_coverash3stringfunctionh3_distancefunctionh3_h3tostringfunctionh3_hexringfunctionh3_ischildoffunctionh3_ispentagonfunctionh3_isvalidfunctionh3_kringfunctionh3_kringdistancesfunctionh3_longlatash3functionh3_longlatash3stringfunctionh3_maxchildfunctionh3_minchildfunctionh3_pointash3functionh3_pointash3stringfunctionh3_polyfillash3functionh3_polyfillash3stringfunctionh3_resolutionfunctionh3_stringtoh3functionh3_tessellateaswkbfunctionh3_tochildrenfunctionh3_toparentfunctionh3_try_distancefunctionh3_try_polyfillash3functionh3_try_polyfillash3stringfunctionh3_try_validatefunctionh3_uncompactfunctionh3_validatefunctionhashfunctionhexfunctionhistogram_numericaggregate functionhll_sketch_aggaggregate functionhll_sketch_estimatefunctionhll_unionfunctionhll_union_aggfunctionhourfunctionhttp_requestfunctionhypotfunctioniffunctionifffunctionifnullfunctionilikeoperatorinpredicateinitcapfunctioninlinetable-valued generator functioninline_outertable-valued generator functioninput_file_block_lengthfunctioninput_file_block_startfunctioninput_file_namefunctioninstrfunctionintfunctionis_account_group_memberfunctionis_memberfunctionis_valid_utf8functionis_variant_nullfunctionis distinctoperatoris falseoperatorisnanfunctionisnotnullfunctionisnullfunctionis nulloperatoris trueoperatorjava_methodfunctionjson_array_lengthfunctionjson_object_keysfunctionjson_tupletable-valued generator functionkurtosisaggregate functionlaganalytic window functionlastaggregate functionlast_dayfunctionlast_valueaggregate functionlcasefunctionleadanalytic window functionleastfunctionleftfunctionlenfunctionlengthfunctionlevenshteinfunctionlikeoperatorlist_secretstable functionlnfunctionlocatefunctionlogfunctionlog10functionlog1pfunctionlog2functionlowerfunctionlpadfunction<=>(lt eq gt sign) operator<=(lt eq sign) operator<>(lt gt sign) operatorltrimfunction<(lt sign) operatorluhn_checkfunctionmake_datefunctionmake_dt_intervalfunctionmake_intervalfunctionmake_timestampfunctionmake_valid_utf8functionmake_ym_intervalfunctionmapfunctionmap_concatfunctionmap_contains_keyfunctionmap_entriesfunctionmap_filterfunctionmap_from_arraysfunctionmap_from_entriesfunctionmap_keysfunctionmap_valuesfunctionmap_zip_withfunctionmaskfunctionmaxaggregate functionmax_byaggregate functionmd5functionmeanaggregate functionmedianaggregate functionminaggregate functionmin_byaggregate function-(minus sign) operator-(minus sign) unary operatorminutefunctionmodfunctionmodeaggregate functionmonotonically_increasing_idfunctionmonthfunctionmonths_betweenfunctionnamed_structfunctionnanvlfunctionnegativefunctionnext_dayfunctionnotoperatornowfunctionnth_valueanalytic window functionntileranking window functionnulliffunctionnullifzerofunctionnvlfunctionnvl2functionoctet_lengthfunctionoroperatoroverlayfunctionparse_jsonfunctionparse_urlfunctionpercent_rankranking window functionpercentileaggregate functionpercentile_approxaggregate functionpercentile_contaggregate functionpercentile_discaggregate function%(percent sign) operatorpifunction||(pipe pipe sign) operator|(pipe sign) operator+(plus sign) operator+(plus sign) unary operatorpmodfunctionposexplodetable-valued generator functionposexplode_outertable-valued generator functionpositionfunctionpositivefunctionpowfunctionpowerfunctionprintffunctionquarterfunction?::(triple colon sign) operatorradiansfunctionraise_errorfunctionrandfunctionrandnfunctionrandomfunctionrandstrfunctionrangetable-valued functionrankranking window functionread_filestable-valued functionread_kafkatable-valued functionread_kinesisstreaming table-valued functionread_pubsubstreaming table-valued functionread_pulsarstreaming table-valued functionread_state_metadatatable-valued functionread_statestoretable-valued functionreducefunctionreflectfunctionregexpoperatorregexp_countfunctionregexp_extractfunctionregexp_extract_allfunctionregexp_instrfunctionregexp_likefunctionregexp_replacefunctionregexp_substrfunctionregr_avgxaggregate functionregr_avgyaggregate functionregr_countaggregate functionregr_interceptaggregate functionregr_r2aggregate functionregr_slopeaggregate functionregr_sxxaggregate functionregr_sxyaggregate functionregr_syyaggregate functionrepeatfunctionreplacefunctionreversefunctionrightfunctionrintfunctionrlikeoperatorroundfunctionrow_numberranking window functionrpadfunctionrtrimfunctionschema_of_csvfunctionschema_of_jsonfunctionschema_of_json_aggaggregate functionschema_of_variantfunctionschema_of_variant_aggaggregate functionschema_of_xmlfunctionsecfunctionsecondfunctionsecretfunctionsentencesfunctionsequencefunctionsession_userfunctionsession_windowgrouping expressionshafunctionsha1functionsha2functionshiftleftfunctionshiftrightfunctionshiftrightunsignedfunctionshufflefunctionsignfunctionsignumfunctionsinfunctionsinhfunctionsizefunctionskewnessaggregate function/(slash sign) operatorslicefunctionsmallintfunctionsomeaggregate functionsort_arrayfunctionsoundexfunctionspacefunctionspark_partition_idfunctionsplitfunctionsplit_partfunctionsql_keywordsfunctionsqrtfunctionstacktable-valued generator functionstartswithfunctionstdaggregate functionstddevaggregate functionstddev_popaggregate functionstddev_sampaggregate functionstr_to_mapfunctionstringfunctionstructfunctionsubstrfunctionsubstringfunctionsubstring_indexfunctionsumaggregate functiontable_changestable-valued functiontanfunctiontanhfunction~(tilde sign) operatortimedifffunctiontimestampfunctiontimestamp_microsfunctiontimestamp_millisfunctiontimestamp_secondsfunctiontimestampaddfunctiontimestampdifffunctiontinyintfunctionto_avrofunctionto_binaryfunctionto_charfunctionto_csvfunctionto_datefunctionto_jsonfunctionto_numberfunctionto_timestampfunctionto_unix_timestampfunctionto_utc_timestampfunctionto_varcharfunctionto_xmlfunctiontransformfunctiontransform_keysfunctiontransform_valuesfunctiontranslatefunctiontrimfunctiontruncfunctiontry_addfunctiontry_aes_decryptfunctiontry_avgaggregate functiontry_castfunctiontry_dividefunctiontry_element_atfunctiontry_modfunctiontry_multiplyfunctiontry_parse_jsonfunctiontry_reflectfunctiontry_secretfunctiontry_subtractfunctiontry_sumaggregate functiontry_to_binaryfunctiontry_to_numberfunctiontry_to_timestampfunctiontry_url_decodefunctiontry_validate_utf8functiontry_variant_getfunctiontry_zstd_decompressfunctiontypeoffunctionucasefunctionunbase64functionunhexfunctionuniformfunctionunix_datefunctionunix_microsfunctionunix_millisfunctionunix_secondsfunctionunix_timestampfunctionupperfunctionurl_decodefunctionurl_encodefunctionuserfunctionuuidfunctionvalidate_utf8functionvar_popaggregate functionvar_sampaggregate functionvarianceaggregate functionvariant_explodetable-valued functionvariant_explode_outertable-valued functionvariant_getfunctionvector_searchfunctionversionfunctionweekdayfunctionweekofyearfunctionwidth_bucketfunctionwindowgrouping expressionwindow_timefunctionxpathfunctionxpath_booleanfunctionxpath_doublefunctionxpath_floatfunctionxpath_intfunctionxpath_longfunctionxpath_numberfunctionxpath_shortfunctionxpath_stringfunctionxxhash64functionyearfunctionzeroifnullfunctionzip_withfunctionzstd_compressfunctionzstd_decompressfunction