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
• agg aggregate function
• aggregate function

• ai_forecast 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
• approx_top_k_accumulate aggregate function
• approx_top_k_combine aggregate function
• approx_top_k_estimate 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_and_agg 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
• classifier 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_time 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_coverash3 function
• h3_try_coverash3string function
• h3_try_distance function
• h3_try_polyfillash3 function
• h3_try_polyfillash3string function
• h3_try_tessellateaswkb 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
• http_request 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
• ip_as_binary function
• ip_as_string function
• ip_cidr function
• ip_cidr_contains function
• ip_host function
• ip_network function
• ip_network_first function
• ip_network_last function
• ip_prefix_length function
• ip_version function
• is_account_group_member function
• is_member function
• is_valid_utf8 function
• is_variant_null function
• is distinct operator
• is false operator
• isearch function
• 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
• kll_sketch_agg_bigint aggregate function
• kll_sketch_agg_double aggregate function
• kll_sketch_agg_float aggregate function
• kll_sketch_get_n_bigint function
• kll_sketch_get_n_double function
• kll_sketch_get_n_float function
• kll_sketch_get_quantile_bigint function
• kll_sketch_get_quantile_double function
• kll_sketch_get_quantile_float function
• kll_sketch_get_rank_bigint function
• kll_sketch_get_rank_double function
• kll_sketch_get_rank_float function
• kll_sketch_merge_bigint function
• kll_sketch_merge_double function
• kll_sketch_merge_float function
• kll_merge_agg_bigint aggregate function
• kll_merge_agg_double aggregate function
• kll_merge_agg_float aggregate function
• kll_sketch_to_string_bigint function
• kll_sketch_to_string_double function
• kll_sketch_to_string_float 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

• listagg aggregate 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_time 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

• match_number function

• first function for MATCH_RECOGNIZE

• last function for MATCH_RECOGNIZE

• next function for MATCH_RECOGNIZE

• prev function for MATCH_RECOGNIZE

• max aggregate function

• max_by aggregate function

• md5 function

• mean aggregate function

• measure 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

• ?:: (question double 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

• remote_query 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

• search 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

• st_addpoint function

• st_area function

• st_asbinary function

• st_asewkb function

• st_asewkt function

• st_asgeojson function

• st_astext function

• st_aswkb function

• st_aswkt function

• st_azimuth function

• st_boundary function

• st_buffer function

• st_centroid function

• st_closestpoint function

• st_collect function

• st_concavehull function

• st_contains function

• st_convexhull function

• st_covers function

• st_difference function

• st_dimension function

• st_disjoint function

• st_distance function

• st_distancesphere function

• st_distancespheroid function

• st_dump function

• st_dwithin function

• st_endpoint function

• st_envelope function

• st_envelope_agg function

• st_equals function

• st_estimatesrid function

• st_exteriorring function

• st_flipcoordinates function

• st_force2d function

• st_geogfromewkt function

• st_geogfromgeojson function

• st_geogfromtext function

• st_geogfromwkb function

• st_geogfromwkt function

• st_geohash function

• st_geomfromgeojson function

• st_geomfromewkb function

• st_geomfromewkt function

• st_geomfromgeohash function

• st_geomfromtext function

• st_geomfromwkb function

• st_geomfromwkt function

• st_geometryn function

• st_geometrytype function

• st_interiorringn function

• st_intersection function

• st_intersects function

• st_isempty function

• st_isvalid function

• st_length function

• st_m function

• st_makeenvelope function

• st_makeline function

• st_makepoint function

• st_multi function

• st_makepolygon function

• st_ndims function

• st_npoints function

• st_nrings function

• st_numgeometries function

• st_numpoints function

• st_numinteriorrings function

• st_perimeter function

• st_point function

• st_pointfromgeohash function

• st_pointn function

• st_pointonsurface function

• st_removepoint function

• st_reverse function

• st_rotate function

• st_scale function

• st_setpoint function

• st_setsrid function

• st_simplify function

• st_srid function

• st_startpoint function

• st_touches function

• st_transform function

• st_translate function

• st_union function

• st_union_agg function

• st_within function

• st_x function

• st_xmax function

• st_xmin function

• st_y function

• st_ymax function

• st_ymin function

• st_z function

• st_zmax function

• st_zmin 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

• string_agg aggregate function

• struct function

• substr function

• substring function

• substring_index function

• sum aggregate function

• table_changes table-valued function

• tan function

• tanh function

• theta_difference function

• theta_intersection function

• theta_intersection_agg aggregate function

• theta_sketch_agg aggregate function

• theta_sketch_estimate function

• theta_union function

• theta_union_agg aggregate function

• ~ (tilde sign) operator

• time_diff function

• time_from_micros function

• time_from_millis function

• time_from_seconds function

• time_to_micros function

• time_to_millis function

• time_to_seconds function

• time_trunc function

• timediff function

• timestamp function

• timestamp_micros function

• timestamp_millis function

• timestamp_seconds function

• timestampadd function

• timestampdiff function

• tinyint function

• parse_timestamp function

• to_avro function

• to_binary function

• to_char function

• to_csv function

• to_date function

• to_geography function
• to_geometry function
• to_json function
• to_number function
• to_time function
• to_timestamp function
• to_unix_timestamp function
• to_utc_timestamp function
• to_varchar function
• to_variant_object 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_ip_as_binary function
• try_ip_as_string function
• try_ip_cidr function
• try_ip_host function
• try_mod function
• try_multiply function
• try_parse_json function
• try_parse_timestamp function
• try_reflect function
• try_secret function
• try_subtract function
• try_sum aggregate function
• try_to_binary function

• try_to_geography function
• try_to_geometry function
• try_to_number function
• try_to_time function
• try_to_timestamp function
• try_url_decode function
• try_validate_utf8 function
• try_variant_get function
• try_zstd_decompress function
• tuple_difference_double function
• tuple_difference_integer function
• tuple_intersection_agg_double aggregate function
• tuple_intersection_agg_integer aggregate function
• tuple_intersection_double function
• tuple_intersection_integer function
• tuple_sketch_agg_double aggregate function
• tuple_sketch_agg_integer aggregate function
• tuple_sketch_estimate_double function
• tuple_sketch_estimate_integer function
• tuple_sketch_summary_double function
• tuple_sketch_summary_integer function
• tuple_sketch_theta_double function
• tuple_sketch_theta_integer function
• tuple_union_agg_double aggregate function
• tuple_union_agg_integer aggregate function
• tuple_union_double function
• tuple_union_integer 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