Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
This article describes functions and operators supported in Databricks-to-Databricks Delta Sharing shared views.
To keep your data secure, shared views for Databricks-to-Databricks Delta Sharing only allows the following subset of Azure Databricks built-in functions and operators:
- -
- !
- /
- /
- &
- %
- ^
- +
- <
<<- <=
- <=>
- =
- ==
- >
- >=
>>>>>- |
- ~
- abs
- acos
- acosh
- add_months
- aes_decrypt
- aes_encrypt
- aggregate
- and
- any
- any_value
- approx_count_distinct
- approx_percentile
- approx_top_k
- array
- array_agg
- array_append
- array_compact
- array_contains
- array_distinct
- array_except
- array_insert
- array_intersect
- array_join
- array_max
- array_min
- array_position
- array_prepend
- array_remove
- array_repeat
- array_size
- array_sort
- array_union
- arrays_overlap
- arrays_zip
- ascii
- asin
- asinh
- assert_true
- atan
- atan2
- atanh
- avg
- base64
- between
- bigint
- bin
- binary
- bit_and
- bit_count
- bit_get
- bit_length
- bit_or
- bit_reverse
- bit_xor
- bitmap_bit_position
- bitmap_bucket_number
- bitmap_construct_agg
- bitmap_count
- bitmap_or_agg
- bool_and
- bool_or
- boolean
- bround
- btrim
- cardinality
- cast
- cbrt
- ceil
- ceiling
- char
- char_length
- character_length
- charindex
- chr
- coalesce
collatecollation- collect_list
- collect_set
- concat
- contains
- conv
- convert_timezone
- corr
- cos
- cosh
- cot
- count
- count_if
- count_min_sketch
- covar_pop
- covar_samp
- crc32
- csc
- cume_dist
- curdate
- current_catalog
- current_database
- current_date
- current_metastore
- current_recipient
- current_schema
- current_timestamp
- current_timezone
- current_user
- current_version
- date
- date_add
- date_diff
- date_format
- date_from_unix_date
- date_part
- date_sub
- date_trunc
- dateadd
- datediff
datepart- day
- dayofmonth
- dayofweek
- dayofyear
- decimal
- decode
- degrees
- dense_rank
- div
- double
- e
- element_at
- encode
- endswith
- every
- exists
- exp
- explode
- explode_outer
- expm1
- extract
- factorial
- filter
- find_in_set
- first
- first_value
- flatten
- float
- floor
- forall
- format_number
- format_string
- from_unixtime
- from_utc_timestamp
- get
- getbit
- getdate
- greatest
- grouping
- grouping_id
- h3_boundaryasgeojson
- h3_boundaryaswkb
- h3_boundaryaswkt
- h3_centerasgeojson
- h3_centeraswkb
- h3_centeraswkt
- h3_compact
- h3_coverash3
- h3_coverash3string
- h3_distance
h3_getpentagoncellids- h3_h3tostring
- h3_hexring
- h3_ischildof
- h3_ispentagon
- h3_isvalid
- h3_kring
- h3_kringdistances
- h3_longlatash3
- h3_longlatash3string
- h3_maxchild
- h3_minchild
- h3_pointash3
- h3_pointash3string
- h3_polyfillash3
- h3_polyfillash3string
- h3_resolution
- h3_stringtoh3
- h3_tessellateaswkb
- h3_tochildren
- h3_toparent
- h3_try_distance
- h3_try_polyfillash3
- h3_try_polyfillash3string
- h3_try_validate
- h3_uncompact
- h3_validate
- hash
- hex
- histogram_numeric
- hll_sketch_agg
- hll_union_agg
- hour
- hypot
- if
- iff
- ifnull
- ilike
- in
- inline
- inline_outer
- int
- is_account_group_member
- is_member
- isnan
- isnotnull
- isnull
- kurtosis
- lag
- last
- last_day
- last_value
- lead
- least
- left
- len
- length
- levenshtein
- like
- ln
localtimestamp- log
- log10
- log1p
- log2
- lower
- luhn_check
- make_date
- make_dt_interval
- make_interval
- make_timestamp
make_timestamp_ltzmake_timestamp_ntz- make_ym_interval
- map
- map_concat
- map_contains_key
- map_entries
- map_filter
- map_from_arrays
- map_from_entries
- map_keys
- map_values
- map_zip_with
- max
- max_by
- md5
- mean
- median
- min
- min_by
- minute
- mod
- mode
- month
monthname- months_between
- named_struct
- nanvl
- negative
- next_day
- not
- now
- nth_value
- ntile
- nullif
- octet_length
- or
- overlay
- percent_rank
- percentile
- percentile_approx
- percentile_cont
- percentile_disc
- pi
- pmod
- position
- positive
- pow
- power
- printf
- quarter
- radians
- rand
- randn
- random
- rank
- reduce
- regexp
- regexp_extract
- regexp_extract_all
- regexp_like
- regexp_replace
- regr_avgx
- regr_avgy
- regr_count
- regr_intercept
- regr_r2
- regr_slope
- regr_sxx
- regr_sxy
- regr_syy
- repeat
- replace
- reverse
- right
- rint
- rlike
- round
- row_number
- rpad
- rtrim
- sec
- second
- sequence
- session_user
- session_window
- sha
- sha1
- sha2
- shiftleft
- shiftright
- shiftrightunsigned
- shuffle
- sign
- signum
- sin
- sinh
- size
- skewness
- slice
- smallint
- some
- sort_array
- split
- split_part
- sqrt
st_areast_asbinaryst_asewkbst_asgeojsonst_astextst_aswkbst_aswktst_bufferst_centroidst_containsst_convexhullst_differencest_distancest_distancespherest_distancespheroidst_envelopest_geogareast_geogfromgeojsonst_geogfromtextst_geogfromwkbst_geogfromwktst_geoglengthst_geogperimeterst_geohashst_geometrynst_geometrytypest_geomfromewkbst_geomfromgeohashst_geomfromgeojsonst_geomfromtextst_geomfromwkbst_geomfromwktst_intersectionst_intersectsst_isemptyst_isvalidst_lengthst_makelinest_makepolygonst_ndimsst_npointsst_numgeometriesst_perimeterst_pointst_pointfromgeohashst_rotatest_scalest_setsridst_simplifyst_sridst_transformst_translatest_unionst_union_aggst_xst_xmaxst_xminst_yst_ymaxst_yminst_zmaxst_zmin- stack
- startswith
- std
- stddev
- stddev_pop
- stddev_samp
- str_to_map
- string
stringdecode- struct
- substr
- substring
- substring_index
- sum
- tan
- tanh
- timestamp
- timestamp_micros
- timestamp_millis
- timestamp_seconds
- tinyint
- to_binary
- to_char
- to_date
to_geographyto_geometry- to_number
- to_timestamp
to_timestamp_ltzto_timestamp_ntz- to_unix_timestamp
- to_utc_timestamp
- to_varchar
- transform
- transform_keys
- transform_values
- trim
- trunc
- try_add
- try_avg
- try_divide
- try_mod
- try_multiply
try_remainder- try_subtract
- try_sum
- try_to_binary
try_to_geographytry_to_geometry- try_to_number
- try_to_timestamp
- typeof
- ucase
- unbase64
- unhex
- unix_date
- unix_micros
- unix_millis
- unix_seconds
- unix_timestamp
- upper
- url_decode
- url_encode
- user
- uuid
- var_pop
- var_samp
- variance
- version
- weekday
- weekofyear
when- width_bucket
- window
- window_time
- year
- zip_with