Functions supported in Databricks-to-Databricks shared views

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

• collate

• collation

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

• make_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_area

• st_asbinary

• st_asewkb

• st_asgeojson

• st_astext

• st_aswkb

• st_aswkt

• st_buffer

• st_centroid

• st_contains

• st_convexhull

• st_difference

• st_distance

• st_distancesphere

• st_distancespheroid

• st_envelope

• st_geogarea

• st_geogfromgeojson

• st_geogfromtext

• st_geogfromwkb

• st_geogfromwkt

• st_geoglength

• st_geogperimeter

• st_geohash

• st_geometryn

• st_geometrytype

• st_geomfromewkb

• st_geomfromgeohash

• st_geomfromgeojson

• st_geomfromtext

• st_geomfromwkb

• st_geomfromwkt

• st_intersection

• st_intersects

• st_isempty

• st_isvalid

• st_length

• st_makeline

• st_makepolygon

• st_ndims

• st_npoints

• st_numgeometries

• st_perimeter

• st_point

• st_pointfromgeohash

• st_rotate

• st_scale

• st_setsrid

• st_simplify

• st_srid

• st_transform

• st_translate

• st_union

• st_union_agg

• st_x

• st_xmax

• st_xmin

• st_y

• st_ymax

• st_ymin

• st_zmax

• st_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_geography

• to_geometry

• to_number

• to_timestamp

• to_timestamp_ltz

• to_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_geography

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