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 Azure Databricks.

• abs function

• acos function

• acosh function

• add_months function

• aes_decrypt function

• aes_encrypt function

• aggregate function

• & (ampersand sign) operator

• and predicate

• any aggregate function

• any_value aggregate function

• approx_count_distinct aggregate function

• approx_percentile aggregate function

• approx_top_k aggregate function

• array function

• array_agg aggregate function

• array_append function

• array_compact function

• array_contains function

• array_distinct function

• array_except function

• array_insert function

• array_intersect function

• array_join function

• array_max function

• array_min function

• array_position function

• array_prepend function

• array_remove function

• array_repeat function

• array_size function

• array_sort function

• array_union function

• arrays_overlap function

• arrays_zip function

• ascii function

• asin function

• asinh function

• assert_true function

• * (asterisk sign) operator

• atan function

• atan2 function

• atanh function

• avg aggregate function

• != (bangeq sign) operator

• ! (bang sign) operator

• base64 function

• between predicate

• bigint function

• bin function

• binary function

• bit_and aggregate function

• bit_count function

• bit_get function

• bit_length function

• bit_or aggregate function

• bit_reverse function

• bit_xor aggregate function

• bitmap_bit_position function

• bitmap_bucket_number function

• bitmap_construct_agg aggregate function

• bitmap_count function

• bitmap_or_agg aggregate function

• bool_and aggregate function

• bool_or aggregate function

• boolean function

• [ ] (bracket sign) operator

• bround function

• btrim function

• cardinality function

• ^ (caret sign) operator

• case expression

• cast function

• cbrt function

• ceil function

• ceiling function

• char function

• char_length function

• character_length function

• charindex function

• chr function

• cloud_files_state table-valued function

• coalesce function

• collate expression

• collation function

• collations table function

• collect_list aggregate function

• collect_set aggregate function

• :: (colon colon sign) operator

• : (colon sign) operator

• concat function

• concat_ws function

• contains function

• conv function

• convert_timezone function

• corr aggregate function

• cos function

• cosh function

• cot function

• count aggregate function

• count_if aggregate function

• count_min_sketch aggregate function

• covar_pop aggregate function

• covar_samp aggregate function

• crc32 function

• csc function

• cube function

• cume_dist analytic window function

• curdate function

• current_catalog function

• current_database function

• current_date function

• current_metastore function

• current_recipient function

• current_schema function

• current_timestamp function

• current_timezone function

• current_user function

• current_version function

• date function

• date_add (days) function

• date_add function

• date_diff function

• date_format function

• date_from_unix_date function

• date_part function

• date_sub function

• date_trunc function

• dateadd function

• dateadd (days) function

• datediff function

• datediff (timestamp) function

• day function

• dayname function

• dayofmonth function

• dayofweek function

• dayofyear function

• decimal function

• decode (key) function

• decode (character set) function

• degrees function

• dense_rank ranking window function

• div operator

• . (dot sign) operator

• double function

• e function

• element_at function

• elt function

• encode function

• endswith function

• == (eq eq sign) operator

• = (eq sign) operator

• equal_null function

• event_log table-valued function

• every aggregate function

• exists function

• exp function

• explode table-valued generator function

• explode_outer table-valued generator function

• expm1 function

• extract function

• factorial function

• filter function

• find_in_set function

• first aggregate function

• first_value aggregate function

• flatten function

• float function

• floor function

• forall function

• format_number function

• format_string function

• from_avro function

• from_csv function

• from_json function

• from_unixtime function

• from_utc_timestamp function

• from_xml function

• get function

• get_json_object function

• getbit function

• getdate function

• greatest function

• grouping function

• grouping_id function

• >= (gt eq sign) operator

• > (gt sign) operator

• h3_boundaryasgeojson function

• h3_boundaryaswkb function

• h3_boundaryaswkt function

• h3_centerasgeojson function

• h3_centeraswkb function

• h3_centeraswkt function

• h3_compact function

• h3_coverash3 function

• h3_coverash3string function

• h3_distance function

• h3_h3tostring function

• h3_hexring function

• h3_ischildof function

• h3_ispentagon function

• h3_isvalid function

• h3_kring function

• h3_kringdistances function

• h3_longlatash3 function

• h3_longlatash3string function

• h3_maxchild function

• h3_minchild function

• h3_pointash3 function

• h3_pointash3string function

• h3_polyfillash3 function

• h3_polyfillash3string function

• h3_resolution function

• h3_stringtoh3 function

• h3_tessellateaswkb function

• h3_tochildren function

• h3_toparent function

• h3_try_distance function

• h3_try_polyfillash3 function

• h3_try_polyfillash3string function

• h3_try_validate function

• h3_uncompact function

• h3_validate function

• hash function

• hex function

• histogram_numeric aggregate function

• hll_sketch_agg aggregate function

• hll_sketch_estimate function

• hll_union function

• hll_union_agg function

• hour function

• hypot function

• if function

• iff function

• ifnull function

• ilike operator

• in predicate

• initcap function

• inline table-valued generator function

• inline_outer table-valued generator function

• input_file_block_length function

• input_file_block_start function

• input_file_name function

• instr function

• int function

• is_account_group_member function

• is_member function

• is_valid_utf8 function

• is_variant_null function

• is distinct operator

• is false operator

• isnan function

• isnotnull function

• isnull function

• is null operator

• is true operator

• java_method function

• json_array_length function

• json_object_keys function

• json_tuple table-valued generator function

• kurtosis aggregate function

• lag analytic window function

• last aggregate function

• last_day function

• last_value aggregate function

• lcase function

• lead analytic window function

• least function

• left function

• len function

• length function

• levenshtein function

• like operator

• list_secrets table function

• ln function

• locate function

• log function

• log10 function

• log1p function

• log2 function

• lower function

• lpad function

• <=> (lt eq gt sign) operator

• <= (lt eq sign) operator

• <> (lt gt sign) operator

• ltrim function

• < (lt sign) operator

• luhn_check function

• make_date function

• make_dt_interval function

• make_interval function

• make_timestamp function

• make_valid_utf8 function

• make_ym_interval function

• map function

• map_concat function

• map_contains_key function

• map_entries function

• map_filter function

• map_from_arrays function

• map_from_entries function

• map_keys function

• map_values function

• map_zip_with function

• mask function

• max aggregate function

• max_by aggregate function

• md5 function

• mean aggregate function

• median aggregate function

• min aggregate function

• min_by aggregate function

• - (minus sign) operator

• - (minus sign) unary operator

• minute function

• mod function

• mode aggregate function

• monotonically_increasing_id function

• month function

• months_between function

• named_struct function

• nanvl function

• negative function

• next_day function

• not operator

• now function

• nth_value analytic window function

• ntile ranking window function

• nullif function

• nullifzero function

• nvl function

• nvl2 function

• octet_length function

• or operator

• overlay function

• parse_json function

• parse_url function

• percent_rank ranking window function

• percentile aggregate function

• percentile_approx aggregate function

• percentile_cont aggregate function

• percentile_disc aggregate function

• % (percent sign) operator

• pi function

• || (pipe pipe sign) operator

• | (pipe sign) operator

• + (plus sign) operator

• + (plus sign) unary operator

• pmod function

• posexplode table-valued generator function

• posexplode_outer table-valued generator function

• position function

• positive function

• pow function

• power function

• printf function

• quarter function

• ?:: (triple colon sign) operator

• radians function

• raise_error function

• rand function

• randn function

• random function

• randstr function

• range table-valued function

• rank ranking window function

• read_files table-valued function

• read_kafka table-valued function

• read_kinesis streaming table-valued function

• read_pulsar streaming table-valued function

• read_state_metadata table-valued function

• read_statestore table-valued function

• reduce function

• reflect function

• regexp operator

• regexp_count function

• regexp_extract function

• regexp_extract_all function

• regexp_instr function

• regexp_like function

• regexp_replace function

• regexp_substr function

• regr_avgx aggregate function

• regr_avgy aggregate function

• regr_count aggregate function

• regr_intercept aggregate function

• regr_r2 aggregate function

• regr_slope aggregate function

• regr_sxx aggregate function

• regr_sxy aggregate function

• regr_syy aggregate function

• repeat function

• replace function

• reverse function

• right function

• rint function

• rlike operator

• round function

• row_number ranking window function

• rpad function

• rtrim function

• schema_of_csv function

• schema_of_json function

• schema_of_json_agg aggregate function

• schema_of_variant function

• schema_of_variant_agg aggregate function

• schema_of_xml function

• sec function

• second function

• secret function

• sentences function

• sequence function

• session_user function

• session_window grouping expression

• sha function

• sha1 function

• sha2 function

• shiftleft function

• shiftright function

• shiftrightunsigned function

• shuffle function

• sign function

• signum function

• sin function

• sinh function

• size function

• skewness aggregate function

• / (slash sign) operator

• slice function

• smallint function

• some aggregate function

• sort_array function

• soundex function

• space function

• spark_partition_id function

• split function

• split_part function

• sql_keywords function

• sqrt function

• stack table-valued generator function

• startswith function

• std aggregate function

• stddev aggregate function

• stddev_pop aggregate function

• stddev_samp aggregate function

• str_to_map function

• string function

• struct function

• substr function

• substring function

• substring_index function

• sum aggregate function

• table_changes table-valued function

• tan function

• tanh function

• ~ (tilde sign) operator

• timediff function

• timestamp function

• timestamp_micros function

• timestamp_millis function

• timestamp_seconds function

• timestampadd function

• timestampdiff function

• tinyint function

• to_avro function

• to_binary function

• to_char function

• to_csv function

• to_date function

• to_json function

• to_number function

• to_timestamp function

• to_unix_timestamp function

• to_utc_timestamp function

• to_varchar function

• to_xml function

• transform function

• transform_keys function

• transform_values function

• translate function

• trim function

• trunc function

• try_add function

• try_aes_decrypt function

• try_avg aggregate function

• try_cast function

• try_divide function

• try_element_at function

• try_mod function

• try_multiply function

• try_parse_json function

• try_reflect function

• try_secret function

• try_subtract function

• try_sum aggregate function

• try_to_binary function

• try_to_number function

• try_to_timestamp function

• try_url_decode function

• try_validate_utf8 function

• try_variant_get function

• try_zstd_decompress function

• typeof function

• ucase function

• unbase64 function

• unhex function

• uniform function

• unix_date function

• unix_micros function

• unix_millis function

• unix_seconds function

• unix_timestamp function

• upper function

• url_decode function

• url_encode function

• user function

• uuid function

• validate_utf8 function

• var_pop aggregate function

• var_samp aggregate function

• variance aggregate function

• variant_explode table-valued function

• variant_explode_outer table-valued function

• variant_get function

• version function

• weekday function

• weekofyear function

• width_bucket function

• window grouping expression

• window_time function

• xpath function

• xpath_boolean function

• xpath_double function

• xpath_float function

• xpath_int function

• xpath_long function

• xpath_number function

• xpath_short function

• xpath_string function

• xxhash64 function

• year function

• zeroifnull function

• zip_with function

• zstd_compress function

• zstd_decompress function