Getting started
User guides
abs
function (Databricks SQL)acos
function (Databricks SQL)acosh
function (Databricks SQL)add_months
function (Databricks SQL)aes_decrypt
function (Databricks SQL)aes_encrypt
function (Databricks SQL)aggregate
function (Databricks SQL)&
(ampersand sign) operator (Databricks SQL)and
predicate (Databricks SQL)any
aggregate function (Databricks SQL)approx_count_distinct
aggregate function (Databricks SQL)approx_percentile
aggregate function (Databricks SQL)approx_top_k
aggregate function (Databricks SQL)array
function (Databricks SQL)array_agg
aggregate function (Databricks SQL)array_contains
function (Databricks SQL)array_distinct
function (Databricks SQL)array_except
function (Databricks SQL)array_intersect
function (Databricks SQL)array_join
function (Databricks SQL)array_max
function (Databricks SQL)array_min
function (Databricks SQL)array_position
function (Databricks SQL)array_remove
function (Databricks SQL)array_repeat
function (Databricks SQL)array_size
function (Databricks SQL)array_sort
function (Databricks SQL)array_union
function (Databricks SQL)arrays_overlap
function (Databricks SQL)arrays_zip
function (Databricks SQL)ascii
function (Databricks SQL)asin
function (Databricks SQL)asinh
function (Databricks SQL)assert_true
function (Databricks SQL)*
(asterisk sign) operator (Databricks SQL)atan
function (Databricks SQL)atan2
function (Databricks SQL)atanh
function (Databricks SQL)avg
aggregate function (Databricks SQL)!=
(bangeq sign) operator (Databricks SQL)!
(bang sign) operator (Databricks SQL)base64
function (Databricks SQL)between
predicate (Databricks SQL)bigint
function (Databricks SQL)bin
function (Databricks SQL)binary
function (Databricks SQL)bit_and
aggregate function (Databricks SQL)bit_count
function (Databricks SQL)bit_get
function (Databricks SQL)bit_length
function (Databricks SQL)bit_or
aggregate function (Databricks SQL)bit_reverse
function (Databricks SQL)bit_xor
aggregate function (Databricks SQL)bool_and
aggregate function (Databricks SQL)bool_or
aggregate function (Databricks SQL)boolean
function (Databricks SQL)[ ]
(bracket sign) operator (Databricks SQL)bround
function (Databricks SQL)btrim
function (Databricks SQL)cardinality
function (Databricks SQL)^
(caret sign) operator (Databricks SQL)case
expression (Databricks SQL)cast
function (Databricks SQL)cbrt
function (Databricks SQL)ceil
function (Databricks SQL)ceiling
function (Databricks SQL)char
function (Databricks SQL)char_length
function (Databricks SQL)character_length
function (Databricks SQL)charindex
function (Databricks SQL)chr
function (Databricks SQL)coalesce
function (Databricks SQL)collect_list
aggregate function (Databricks SQL)collect_set
aggregate function (Databricks SQL)::
(colon colon sign) operator (Databricks SQL):
(colon sign) operator (Databricks SQL)concat
function (Databricks SQL)concat_ws
function (Databricks SQL)contains
function (Databricks SQL)conv
function (Databricks SQL)corr
aggregate function (Databricks SQL)cos
function (Databricks SQL)cosh
function (Databricks SQL)cot
function (Databricks SQL)count
aggregate function (Databricks SQL)count_if
aggregate function (Databricks SQL)count_min_sketch
aggregate function (Databricks SQL)covar_pop
aggregate function (Databricks SQL)covar_samp
aggregate function (Databricks SQL)crc32
function (Databricks SQL)csc
function (Databricks SQL)cube
function (Databricks SQL)cume_dist
analytic window function (Databricks SQL)current_catalog
function (Databricks SQL)current_database
function (Databricks SQL)current_date
function (Databricks SQL)current_schema
function (Databricks SQL)current_timestamp
function (Databricks SQL)current_timezone
function (Databricks SQL)current_user
function (Databricks SQL)current_version
function (Databricks SQL)date
function (Databricks SQL)date_add
function (Databricks SQL)date_format
function (Databricks SQL)date_from_unix_date
function (Databricks SQL)date_part
function (Databricks SQL)date_sub
function (Databricks SQL)date_trunc
function (Databricks SQL)dateadd
function (Databricks SQL)datediff
function (Databricks SQL)datediff
(timestamp) function (Databricks SQL)day
function (Databricks SQL)dayofmonth
function (Databricks SQL)dayofweek
function (Databricks SQL)dayofyear
function (Databricks SQL)decimal
function (Databricks SQL)decode
function (Databricks SQL)decode
(character set) function (Databricks SQL)degrees
function (Databricks SQL)dense_rank
ranking window function (Databricks SQL)div
operator (Databricks SQL)double
function (Databricks SQL)e
function (Databricks SQL)element_at
function (Databricks SQL)elt
function (Databricks SQL)encode
function (Databricks SQL)endswith
function (Databricks SQL)==
(eq eq sign) operator (Databricks SQL)=
(eq sign) operator (Databricks SQL)every
aggregate function (Databricks SQL)exists
function (Databricks SQL)exp
function (Databricks SQL)explode
table-valued generator function (Databricks SQL)explode_outer
table-valued generator function (Databricks SQL)expm1
function (Databricks SQL)extract
function (Databricks SQL)factorial
function (Databricks SQL)filter
function (Databricks SQL)find_in_set
function (Databricks SQL)first
aggregate function (Databricks SQL)first_value
aggregate function (Databricks SQL)flatten
function (Databricks SQL)float
function (Databricks SQL)floor
function (Databricks SQL)forall
function (Databricks SQL)format_number
function (Databricks SQL)format_string
function (Databricks SQL)from_csv
function (Databricks SQL)from_json
function (Databricks SQL)from_unixtime
function (Databricks SQL)from_utc_timestamp
function (Databricks SQL)get_json_object
function (Databricks SQL)getbit
function (Databricks SQL)greatest
function (Databricks SQL)grouping
function (Databricks SQL)grouping_id
function (Databricks SQL)>=
(gt eq sign) operator (Databricks SQL)>
(gt sign) operator (Databricks SQL)hash
function (Databricks SQL)hex
function (Databricks SQL)hour
function (Databricks SQL)hypot
function (Databricks SQL)if
function (Databricks SQL)iff
function (Databricks SQL)ifnull
function (Databricks SQL)ilike
operator (Databricks SQL)in
predicate (Databricks SQL)initcap
function (Databricks SQL)inline
table-valued generator function (Databricks SQL)inline_outer
table-valued generator function (Databricks SQL)input_file_block_length
function (Databricks SQL)input_file_block_start
function (Databricks SQL)input_file_name
function (Databricks SQL)instr
function (Databricks SQL)int
function (Databricks SQL)is_member
function (Databricks SQL)is distinct
operator (Databricks SQL)is false
operator (Databricks SQL)isnan
function (Databricks SQL)isnotnull
function (Databricks SQL)isnull
function (Databricks SQL)is null
operator (Databricks SQL)is true
operator (Databricks SQL)json_array_length
function (Databricks SQL)json_object_keys
function (Databricks SQL)json_tuple
table-valued generator function (Databricks SQL)kurtosis
aggregate function (Databricks SQL)lag
analytic window function (Databricks SQL)last
aggregate function (Databricks SQL)last_day
function (Databricks SQL)last_value
aggregate function (Databricks SQL)lcase
function (Databricks SQL)lead
analytic window function (Databricks SQL)least
function (Databricks SQL)left
function (Databricks SQL)length
function (Databricks SQL)levenshtein
function (Databricks SQL)like
operator (Databricks SQL)ln
function (Databricks SQL)locate
function (Databricks SQL)log
function (Databricks SQL)log10
function (Databricks SQL)log1p
function (Databricks SQL)log2
function (Databricks SQL)lower
function (Databricks SQL)lpad
function (Databricks SQL)<=>
(lt eq gt sign) operator (Databricks SQL)<=
(lt eq sign) operator (Databricks SQL)<>
(lt gt sign) operator (Databricks SQL)ltrim
function (Databricks SQL)<
(lt sign) operator (Databricks SQL)make_date
function (Databricks SQL)make_dt_interval
function (Databricks SQL)make_interval
function (Databricks SQL)make_timestamp
function (Databricks SQL)make_ym_interval
function (Databricks SQL)map
function (Databricks SQL)map_concat
function (Databricks SQL)map_contains_key
function (Databricks SQL)map_entries
function (Databricks SQL)map_filter
function (Databricks SQL)map_from_arrays
function (Databricks SQL)map_from_entries
function (Databricks SQL)map_keys
function (Databricks SQL)map_values
function (Databricks SQL)map_zip_with
function (Databricks SQL)max
aggregate function (Databricks SQL)max_by
aggregate function (Databricks SQL)md5
function (Databricks SQL)mean
aggregate function (Databricks SQL)min
aggregate function (Databricks SQL)min_by
aggregate function (Databricks SQL)-
(minus sign) operator (Databricks SQL)-
(minus sign) unary operator (Databricks SQL)minute
function (Databricks SQL)mod
function (Databricks SQL)monotonically_increasing_id
function (Databricks SQL)month
function (Databricks SQL)months_between
function (Databricks SQL)named_struct
function (Databricks SQL)nanvl
function (Databricks SQL)negative
function (Databricks SQL)next_day
function (Databricks SQL)not
operator (Databricks SQL)now
function (Databricks SQL)nth_value
analytic window function (Databricks SQL)ntile
ranking window function (Databricks SQL)nullif
function (Databricks SQL)nvl
function (Databricks SQL)nvl2
function (Databricks SQL)octet_length
function (Databricks SQL)or
operator (Databricks SQL)overlay
function (Databricks SQL)parse_url
function (Databricks SQL)percent_rank
ranking window function (Databricks SQL)percentile
aggregate function (Databricks SQL)percentile_approx
aggregate function (Databricks SQL)percentile_cont
aggregate function (Databricks SQL)percentile_disc
aggregate function (Databricks SQL)%
(percent sign) operator (Databricks SQL)pi
function (Databricks SQL)||
(pipe pipe sign) operator (Databricks SQL)|
(pipe sign) operator (Databricks SQL)+
(plus sign) operator (Databricks SQL)+
(plus sign) unary operator (Databricks SQL)pmod
function (Databricks SQL)posexplode
table-valued generator function (Databricks SQL)posexplode_outer
table-valued generator function (Databricks SQL)position
function (Databricks SQL)positive
function (Databricks SQL)pow
function (Databricks SQL)power
function (Databricks SQL)printf
function (Databricks SQL)quarter
function (Databricks SQL)radians
function (Databricks SQL)raise_error
function (Databricks SQL)rand
function (Databricks SQL)randn
function (Databricks SQL)random
function (Databricks SQL)range
table-valued function (Databricks SQL)rank
ranking window function (Databricks SQL)reduce
function (Databricks SQL)regexp
operator (Databricks SQL)regexp_extract
function (Databricks SQL)regexp_extract_all
function (Databricks SQL)regexp_like
function (Databricks SQL)regexp_replace
function (Databricks SQL)regr_avgx
aggregate function (Databricks SQL)regr_avgy
aggregate function (Databricks SQL)regr_count
aggregate function (Databricks SQL)regr_r2
aggregate function (Databricks SQL)regr_sxx
aggregate function (Databricks SQL)regr_sxy
aggregate function (Databricks SQL)regr_syy
aggregate function (Databricks SQL)repeat
function (Databricks SQL)replace
function (Databricks SQL)reverse
function (Databricks SQL)right
function (Databricks SQL)rint
function (Databricks SQL)rlike
operator (Databricks SQL)round
function (Databricks SQL)row_number
ranking window function (Databricks SQL)rpad
function (Databricks SQL)rtrim
function (Databricks SQL)schema_of_csv
function (Databricks SQL)schema_of_json
function (Databricks SQL)sec
function (Databricks SQL)second
function (Databricks SQL)sentences
function (Databricks SQL)sequence
function (Databricks SQL)sha
function (Databricks SQL)sha1
function (Databricks SQL)sha2
function (Databricks SQL)shiftleft
function (Databricks SQL)shiftright
function (Databricks SQL)shiftrightunsigned
function (Databricks SQL)shuffle
function (Databricks SQL)sign
function (Databricks SQL)signum
function (Databricks SQL)sin
function (Databricks SQL)sinh
function (Databricks SQL)size
function (Databricks SQL)skewness
aggregate function (Databricks SQL)/
(slash sign) operator (Databricks SQL)slice
function (Databricks SQL)smallint
function (Databricks SQL)some
aggregate function (Databricks SQL)sort_array
function (Databricks SQL)soundex
function (Databricks SQL)space
function (Databricks SQL)spark_partition_id
function (Databricks SQL)split
function (Databricks SQL)split_part
function (Databricks SQL)sqrt
function (Databricks SQL)stack
table-valued generator function (Databricks SQL)startswith
function (Databricks SQL)std
aggregate function (Databricks SQL)stddev
aggregate function (Databricks SQL)stddev_pop
aggregate function (Databricks SQL)stddev_samp
aggregate function (Databricks SQL)str_to_map
function (Databricks SQL)string
function (Databricks SQL)struct
function (Databricks SQL)substr
function (Databricks SQL)substring
function (Databricks SQL)substring_index
function (Databricks SQL)sum
aggregate function (Databricks SQL)tan
function (Databricks SQL)tanh
function (Databricks SQL)~
(tilde sign) operator (Databricks SQL)timestamp
function (Databricks SQL)timestamp_micros
function (Databricks SQL)timestamp_millis
function (Databricks SQL)timestamp_seconds
function (Databricks SQL)timestampadd
function (Databricks SQL)timestampdiff
function (Databricks SQL)tinyint
function (Databricks SQL)to_csv
function (Databricks SQL)to_date
function (Databricks SQL)to_json
function (Databricks SQL)to_number
function (Databricks SQL)to_timestamp
function (Databricks SQL)to_unix_timestamp
function (Databricks SQL)to_utc_timestamp
function (Databricks SQL)transform
function (Databricks SQL)transform_keys
function (Databricks SQL)transform_values
function (Databricks SQL)translate
function (Databricks SQL)trim
function (Databricks SQL)trunc
function (Databricks SQL)try_add
function (Databricks SQL)try_avg
aggregate function (Databricks SQL)try_cast
function (Databricks SQL)try_divide
function (Databricks SQL)try_element_at
function (Databricks SQL)try_multiply
function (Databricks SQL)try_subtract
function (Databricks SQL)try_sum
aggregate function (Databricks SQL)try_to_number
function (Databricks SQL)typeof
function (Databricks SQL)ucase
function (Databricks SQL)unbase64
function (Databricks SQL)unhex
function (Databricks SQL)unix_date
function (Databricks SQL)unix_micros
function (Databricks SQL)unix_millis
function (Databricks SQL)unix_seconds
function (Databricks SQL)unix_timestamp
function (Databricks SQL)upper
function (Databricks SQL)uuid
function (Databricks SQL)var_pop
aggregate function (Databricks SQL)var_samp
aggregate function (Databricks SQL)variance
aggregate function (Databricks SQL)version
function (Databricks SQL)weekday
function (Databricks SQL)weekofyear
function (Databricks SQL)width_bucket
function (Databricks SQL)window
grouping expression (Databricks SQL)xpath
function (Databricks SQL)xpath_boolean
function (Databricks SQL)xpath_double
function (Databricks SQL)xpath_float
function (Databricks SQL)xpath_int
function (Databricks SQL)xpath_long
function (Databricks SQL)xpath_number
function (Databricks SQL)xpath_short
function (Databricks SQL)xpath_string
function (Databricks SQL)xxhash64
function (Databricks SQL)year
function (Databricks SQL)zip_with
function (Databricks SQL)Administration guides
Reference guides
Resources
Updated Aug 10, 2022