> ## Documentation Index > Fetch the complete documentation index at: https://docs.e6data.com/llms.txt > Use this file to discover all available pages before exploring further. # Databricks function compatibility > Which Databricks SQL functions and operators Query Engine supports, with links to the function reference. This page lists the Databricks SQL functions and operators and whether Query Engine supports each one. Supported functions link to their page in the [SQL function reference](/query/sql/functions). The last section lists names from other SQL dialects that Query Engine accepts as another name for a function.

Yes Supported Partial Supported with limits No Not supported yet

## Summary | Area | Yes | Partial | No | | - | - | - | - | | [Aggregate functions](#aggregate-functions) | 44 | 0 | 23 | | [AI functions](#ai-functions) | 0 | 0 | 16 | | [Array functions](#array-functions) | 23 | 0 | 7 | | [Bitmap functions](#bitmap-functions) | 1 | 0 | 5 | | [Bitwise functions](#bitwise-functions) | 6 | 0 | 1 | | [Compression](#compression) | 0 | 0 | 3 | | [Conditional functions](#conditional-functions) | 13 | 0 | 2 | | [Data Source/IO functions](#data-source-io-functions) | 0 | 0 | 18 | | [Date/Time functions](#date-time-functions) | 56 | 0 | 28 | | [Generator/Table functions](#generator-table-functions) | 4 | 0 | 4 | | [Geospatial (ST)](#geospatial-st) | 0 | 0 | 97 | | [Geospatial Conversion](#geospatial-conversion) | 0 | 0 | 4 | | [H3 Geospatial](#h3-geospatial) | 0 | 0 | 40 | | [Hash/Crypto functions](#hash-crypto-functions) | 4 | 0 | 6 | | [Higher-Order functions](#higher-order-functions) | 5 | 0 | 6 | | [HyperLogLog (HLL)](#hyperloglog-hll) | 0 | 0 | 6 | | [Ingestion functions](#ingestion-functions) | 0 | 0 | 5 | | [IP Address functions](#ip-address-functions) | 0 | 0 | 14 | | [JSON functions](#json-functions) | 6 | 0 | 4 | | [KLL Sketch functions](#kll-sketch-functions) | 0 | 0 | 22 | | [Map functions](#map-functions) | 5 | 0 | 5 | | [Math/Numeric functions](#math-numeric-functions) | 45 | 0 | 13 | | [MCV Sketch functions](#mcv-sketch-functions) | 0 | 0 | 2 | | [Operators](#operators) | 26 | 0 | 2 | | [Regex functions](#regex-functions) | 7 | 0 | 2 | | [Serialization functions](#serialization-functions) | 0 | 0 | 8 | | [Session/Metadata functions](#session-metadata-functions) | 3 | 0 | 20 | | [String functions](#string-functions) | 56 | 0 | 14 | | [Struct functions](#struct-functions) | 2 | 0 | 0 | | [Tag/Governance functions](#tag-governance-functions) | 0 | 0 | 6 | | [Theta Sketch functions](#theta-sketch-functions) | 0 | 0 | 7 | | [Tuple Sketch functions](#tuple-sketch-functions) | 0 | 0 | 24 | | [Type Casting](#type-casting) | 4 | 0 | 13 | | [Utility/Misc](#utility-misc) | 3 | 0 | 27 | | [Variant/Semi-structured](#variant-semi-structured) | 2 | 0 | 6 | | [Vector functions](#vector-functions) | 0 | 0 | 8 | | [Window functions](#window-functions) | 7 | 0 | 2 | | [XML functions](#xml-functions) | 0 | 0 | 12 | | [Uncategorized](#uncategorized) | 0 | 0 | 1 | | [Names from other SQL dialects](#names-from-other-sql-dialects) | 82 | 0 | 0 | ## Aggregate functions | Function | e6data | | - | - | | `any` | Yes | | [`any_value`](/query/sql/functions/aggregate/any_value) | Yes | | [`approx_count_distinct`](/query/sql/functions/aggregate/approx_count_distinct) | Yes | | [`approx_percentile`](/query/sql/functions/aggregate/approx_percentile) | Yes | | [`approx_top_k`](/query/sql/functions/aggregate/approx_top_k) | Yes | | `approx_top_k_accumulate` | No | | `approx_top_k_combine` | No | | `approx_top_k_estimate` | No | | [`array_agg`](/query/sql/functions/aggregate/collect_list) | Yes | | [`avg`](/query/sql/functions/aggregate/avg) | Yes | | `bit_and` | No | | [`bit_or`](/query/sql/functions/aggregate/bitoragg) | Yes | | [`bit_xor`](/query/sql/functions/aggregate/bit_xor) | Yes | | `bool_and` | No | | [`bool_or`](/query/sql/functions/aggregate/bool_or) | Yes | | [`collect_list`](/query/sql/functions/aggregate/collect_list) | Yes | | [`collect_set`](/query/sql/functions/aggregate/collect_set) | Yes | | [`corr`](/query/sql/functions/aggregate/corr) | Yes | | [`count`](/query/sql/functions/aggregate/count) | Yes | | [`count_if`](/query/sql/functions/aggregate/countif) | Yes | | `count_min_sketch` | No | | [`covar_pop`](/query/sql/functions/aggregate/covar_pop) | Yes | | [`covar_samp`](/query/sql/functions/aggregate/covar_samp) | Yes | | [`every`](/query/sql/functions/aggregate/every) | Yes | | [`first`](/query/sql/functions/aggregate/first_value) | Yes | | [`first_value`](/query/sql/functions/aggregate/first_value) | Yes | | [`grouping`](/query/sql/functions/aggregate/grouping) | Yes | | [`grouping_id`](/query/sql/functions/aggregate/grouping) | Yes | | `histogram_numeric` | No | | `kurtosis` | No | | [`last`](/query/sql/functions/aggregate/last_value) | Yes | | [`last_value`](/query/sql/functions/aggregate/last_value) | Yes | | [`listagg`](/query/sql/functions/aggregate/listagg) | Yes | | [`max`](/query/sql/functions/aggregate/max) | Yes | | [`max_by`](/query/sql/functions/aggregate/max_by) | Yes | | [`mean`](/query/sql/functions/aggregate/avg) | Yes | | `measure` | No | | [`median`](/query/sql/functions/aggregate/median) | Yes | | [`min`](/query/sql/functions/aggregate/min) | Yes | | `min_by` | No | | [`mode`](/query/sql/functions/aggregate/mode) | Yes | | [`percentile`](/query/sql/functions/aggregate/percentile) | Yes | | [`percentile_approx`](/query/sql/functions/aggregate/percentile_approx) | Yes | | [`percentile_cont`](/query/sql/functions/aggregate/percentile_cont) | Yes | | `percentile_disc` | No | | `regr_avgx` | No | | `regr_avgy` | No | | `regr_count` | Yes | | `regr_intercept` | No | | `regr_r2` | No | | `regr_slope` | No | | `regr_sxx` | No | | `regr_sxy` | No | | `regr_syy` | No | | `skewness` | No | | [`some`](/query/sql/functions/aggregate/some) | Yes | | `std` | Yes | | [`stddev`](/query/sql/functions/aggregate/stddev) | Yes | | [`stddev_pop`](/query/sql/functions/aggregate/stddev_pop) | Yes | | [`stddev_samp`](/query/sql/functions/aggregate/stddev) | Yes | | [`string_agg`](/query/sql/functions/aggregate/listagg) | Yes | | [`sum`](/query/sql/functions/aggregate/sum) | Yes | | `try_avg` | No | | `try_sum` | No | | `var_pop` | No | | [`var_samp`](/query/sql/functions/aggregate/variance) | Yes | | [`variance`](/query/sql/functions/aggregate/variance) | Yes | ## AI functions | Function | e6data | | - | - | | `ai_analyze_sentiment` | No | | `ai_classify` | No | | `ai_complete` | No | | `ai_embed` | No | | `ai_extract` | No | | `ai_fix_grammar` | No | | `ai_forecast` | No | | `ai_gen` | No | | `ai_generate_text` | No | | `ai_mask` | No | | `ai_parse_document` | No | | `ai_query` | No | | `ai_similarity` | No | | `ai_summarize` | No | | `ai_top_drivers` | No | | `ai_translate` | No | ## Array functions | Function | e6data | | - | - | | [`array`](/query/sql/functions/array/array) | Yes | | [`array_append`](/query/sql/functions/array/array_append) | Yes | | [`array_compact`](/query/sql/functions/array/array_compact) | Yes | | [`array_contains`](/query/sql/functions/array/array_contains) | Yes | | [`array_distinct`](/query/sql/functions/array/array_distinct) | Yes | | `array_except` | No | | `array_insert` | No | | [`array_intersect`](/query/sql/functions/array/array_intersect) | Yes | | [`array_join`](/query/sql/functions/array/array_to_string) | Yes | | [`array_max`](/query/sql/functions/array/array_max) | Yes | | [`array_min`](/query/sql/functions/array/array_min) | Yes | | [`array_position`](/query/sql/functions/array/array_position) | Yes | | [`array_prepend`](/query/sql/functions/array/array_prepend) | Yes | | `array_remove` | No | | `array_repeat` | No | | [`array_size`](/query/sql/functions/array/array_size) | Yes | | [`array_sort`](/query/sql/functions/array/array_sort) | Yes | | `array_union` | No | | [`arrays_overlap`](/query/sql/functions/array/arrays_overlap) | Yes | | `arrays_zip` | No | | [`cardinality`](/query/sql/functions/array/cardinality) | Yes | | [`element_at`](/query/sql/functions/array/element_at) | Yes | | [`flatten`](/query/sql/functions/array/flatten) | Yes | | [`get`](/query/sql/functions/array/get) | Yes | | [`sequence`](/query/sql/functions/array/sequence) | Yes | | `shuffle` | No | | [`size`](/query/sql/functions/array/size) | Yes | | [`slice`](/query/sql/functions/array/array_slice) | Yes | | [`sort_array`](/query/sql/functions/array/sort_array) | Yes | | [`try_element_at`](/query/sql/functions/array/try_element_at) | Yes | ## Bitmap functions | Function | e6data | | - | - | | `bitmap_and_agg` | No | | `bitmap_bit_position` | No | | `bitmap_bucket_number` | No | | `bitmap_construct_agg` | No | | [`bitmap_count`](/query/sql/functions/bitmap/bitmap_count) | Yes | | `bitmap_or_agg` | No | ## Bitwise functions | Function | e6data | | - | - | | [`bit_count`](/query/sql/functions/bitwise/bit_count) | Yes | | [`bit_get`](/query/sql/functions/bitwise/bit_get) | Yes | | `bit_reverse` | No | | [`getbit`](/query/sql/functions/bitwise/bit_get) | Yes | | [`shiftleft`](/query/sql/functions/bitwise/bitwise_shift_left) | Yes | | [`shiftright`](/query/sql/functions/bitwise/shiftright) | Yes | | `shiftrightunsigned` | Yes | ## Compression | Function | e6data | | - | - | | `try_zstd_decompress` | No | | `zstd_compress` | No | | `zstd_decompress` | No | ## Conditional functions | Function | e6data | | - | - | | [`case`](/query/sql/functions/conditional/case) | Yes | | [`coalesce`](/query/sql/functions/conditional/coalesce) | Yes | | [`equal_null`](/query/sql/functions/conditional/equal_null) | Yes | | [`greatest`](/query/sql/functions/conditional/greatest) | Yes | | [`if`](/query/sql/functions/conditional/if) | Yes | | [`iff`](/query/sql/functions/conditional/iff) | Yes | | [`ifnull`](/query/sql/functions/conditional/nvl) | Yes | | [`least`](/query/sql/functions/conditional/least) | Yes | | `nanvl` | No | | [`nullif`](/query/sql/functions/conditional/nullif) | Yes | | `nullifzero` | No | | [`nvl`](/query/sql/functions/conditional/nvl) | Yes | | [`nvl2`](/query/sql/functions/conditional/nvl2) | Yes | | `when` | Yes | | [`zeroifnull`](/query/sql/functions/conditional/zeroifnull) | Yes | ## Data Source/IO functions | Function | e6data | | - | - | | `cloud_files` | No | | `cloud_files_state` | No | | `copy_file` | No | | `create_file` | No | | `list_files` | No | | `read_files` | No | | `read_kafka` | No | | `read_kinesis` | No | | `read_pubsub` | No | | `read_pulsar` | No | | `read_state_metadata` | No | | `read_statestore` | No | | `read_streaming_checkpoint` | No | | `table_changes` | No | | `table_changes_by_path` | No | | `to_file` | No | | `try_copy_file` | No | | `try_to_file` | No | ## Date/Time functions | Function | e6data | | - | - | | [`add_months`](/query/sql/functions/date-time/add_months) | Yes | | [`convert_timezone`](/query/sql/functions/date-time/convert_timezone) | Yes | | [`curdate`](/query/sql/functions/date-time/curdate) | Yes | | [`current_date`](/query/sql/functions/date-time/curdate) | Yes | | `current_time` | No | | [`current_timestamp`](/query/sql/functions/date-time/current_timestamp) | Yes | | [`current_timezone`](/query/sql/functions/date-time/current_timezone) | Yes | | [`date`](/query/sql/functions/date-time/date) | Yes | | [`date_add`](/query/sql/functions/date-time/dateadd) | Yes | | [`date_diff`](/query/sql/functions/date-time/datediff) | Yes | | [`date_format`](/query/sql/functions/date-time/date_format) | Yes | | `date_from_unix_date` | No | | [`date_part`](/query/sql/functions/date-time/date_part) | Yes | | [`date_sub`](/query/sql/functions/date-time/date_sub) | Yes | | [`date_trunc`](/query/sql/functions/date-time/date_trunc) | Yes | | [`dateadd`](/query/sql/functions/date-time/dateadd) | Yes | | [`datediff`](/query/sql/functions/date-time/datediff) | Yes | | [`datepart`](/query/sql/functions/date-time/date_part) | Yes | | [`day`](/query/sql/functions/date-time/day) | Yes | | [`dayname`](/query/sql/functions/date-time/dayname) | Yes | | `dayofmonth` | Yes | | [`dayofweek`](/query/sql/functions/date-time/dayofweek) | Yes | | `dayofyear` | Yes | | [`extract`](/query/sql/functions/date-time/extract) | Yes | | [`from_unixtime`](/query/sql/functions/date-time/from_unixtime) | Yes | | [`from_utc_timestamp`](/query/sql/functions/date-time/from_utc_timestamp) | Yes | | [`getdate`](/query/sql/functions/date-time/current_timestamp) | Yes | | [`hour`](/query/sql/functions/date-time/hour) | Yes | | [`last_day`](/query/sql/functions/date-time/last_day) | Yes | | `localtimestamp` | No | | [`make_date`](/query/sql/functions/date-time/make_date) | Yes | | `make_dt_interval` | No | | `make_interval` | No | | [`make_time`](/query/sql/functions/date-time/make_time) | Yes | | [`make_timestamp`](/query/sql/functions/date-time/make_timestamp) | Yes | | `make_timestamp_ltz` | No | | `make_timestamp_ntz` | No | | `make_ym_interval` | No | | [`minute`](/query/sql/functions/date-time/minute) | Yes | | [`month`](/query/sql/functions/date-time/month) | Yes | | [`monthname`](/query/sql/functions/date-time/monthname) | Yes | | [`months_between`](/query/sql/functions/date-time/months_between) | Yes | | [`next_day`](/query/sql/functions/date-time/next_day) | Yes | | [`now`](/query/sql/functions/date-time/current_timestamp) | Yes | | [`parse_timestamp`](/query/sql/functions/date-time/parse_timestamp) | Yes | | [`quarter`](/query/sql/functions/date-time/quarter) | Yes | | [`second`](/query/sql/functions/date-time/second) | Yes | | `session_window` | No | | `time` | Yes | | `time_diff` | No | | `time_from_micros` | No | | `time_from_millis` | No | | `time_from_seconds` | No | | `time_to_micros` | No | | `time_to_millis` | No | | `time_to_seconds` | No | | `time_trunc` | No | | [`timestamp_micros`](/query/sql/functions/date-time/timestamp_micros) | Yes | | [`timestamp_millis`](/query/sql/functions/date-time/timestamp_millis) | Yes | | [`timestamp_seconds`](/query/sql/functions/date-time/timestamp_seconds) | Yes | | [`to_date`](/query/sql/functions/date-time/to_date) | Yes | | [`to_time`](/query/sql/functions/date-time/to_time) | Yes | | [`to_timestamp`](/query/sql/functions/date-time/to_timestamp) | Yes | | `to_timestamp_ltz` | No | | [`to_timestamp_ntz`](/query/sql/functions/date-time/to_timestamp_ntz) | Yes | | [`to_unix_timestamp`](/query/sql/functions/date-time/unix_timestamp) | Yes | | [`to_utc_timestamp`](/query/sql/functions/date-time/to_utc_timestamp) | Yes | | [`trunc`](/query/sql/functions/date-time/trunc) | Yes | | `try_make_interval` | No | | `try_make_timestamp` | No | | `try_make_timestamp_ltz` | No | | `try_make_timestamp_ntz` | No | | `try_parse_timestamp` | No | | [`try_to_date`](/query/sql/functions/date-time/try_to_date) | Yes | | `try_to_time` | No | | [`try_to_timestamp`](/query/sql/functions/date-time/try_to_timestamp) | Yes | | `unix_date` | No | | `unix_micros` | No | | `unix_millis` | No | | `unix_seconds` | No | | [`unix_timestamp`](/query/sql/functions/date-time/unix_timestamp) | Yes | | [`weekday`](/query/sql/functions/date-time/weekday) | Yes | | [`weekofyear`](/query/sql/functions/date-time/weekofyear) | Yes | | [`year`](/query/sql/functions/date-time/year) | Yes | ## Generator/Table functions | Function | e6data | | - | - | | [`explode`](/query/sql/functions/table/explode) | Yes | | [`explode_outer`](/query/sql/functions/table/explode_outer) | Yes | | [`inline`](/query/sql/functions/table/inline) | No | | [`inline_outer`](/query/sql/functions/table/inline_outer) | No | | [`posexplode`](/query/sql/functions/table/posexplode) | Yes | | `posexplode_outer` | No | | [`range`](/query/sql/functions/table/range) | No | | [`stack`](/query/sql/functions/table/stack) | Yes | ## Geospatial (ST) | Function | e6data | | - | - | | `st_addpoint` | No | | `st_area` | No | | `st_asbinary` | No | | `st_asewkb` | No | | `st_asewkt` | No | | `st_asgeojson` | No | | `st_astext` | No | | `st_aswkb` | No | | `st_aswkt` | No | | `st_azimuth` | No | | `st_boundary` | No | | `st_buffer` | No | | `st_centroid` | No | | `st_closestpoint` | No | | `st_collect` | No | | `st_concavehull` | No | | `st_contains` | No | | `st_convexhull` | No | | `st_covers` | No | | `st_difference` | No | | `st_dimension` | No | | `st_disjoint` | No | | `st_distance` | No | | `st_distancesphere` | No | | `st_distancespheroid` | No | | `st_dump` | No | | `st_dwithin` | No | | `st_endpoint` | No | | `st_envelope` | No | | `st_envelope_agg` | No | | `st_equals` | No | | `st_estimatesrid` | No | | `st_exteriorring` | No | | `st_flipcoordinates` | No | | `st_force2d` | No | | `st_geogfromewkt` | No | | `st_geogfromgeojson` | No | | `st_geogfromtext` | No | | `st_geogfromwkb` | No | | `st_geogfromwkt` | No | | `st_geohash` | No | | `st_geometryn` | No | | `st_geometrytype` | No | | `st_geomfromewkb` | No | | `st_geomfromewkt` | No | | `st_geomfromgeohash` | No | | `st_geomfromgeojson` | No | | `st_geomfromtext` | No | | `st_geomfromwkb` | No | | `st_geomfromwkt` | No | | `st_interiorringn` | No | | `st_intersection` | No | | `st_intersects` | No | | `st_isempty` | No | | `st_isvalid` | No | | `st_length` | No | | `st_m` | No | | `st_makeenvelope` | No | | `st_makeline` | No | | `st_makepoint` | No | | `st_makepolygon` | No | | `st_multi` | No | | `st_ndims` | No | | `st_npoints` | No | | `st_nrings` | No | | `st_numgeometries` | No | | `st_numinteriorrings` | No | | `st_numpoints` | No | | `st_perimeter` | No | | `st_point` | No | | `st_pointfromgeohash` | No | | `st_pointn` | No | | `st_pointonsurface` | No | | `st_removepoint` | No | | `st_reverse` | No | | `st_rotate` | No | | `st_scale` | No | | `st_setpoint` | No | | `st_setsrid` | No | | `st_simplify` | No | | `st_srid` | No | | `st_startpoint` | No | | `st_touches` | No | | `st_transform` | No | | `st_translate` | No | | `st_union` | No | | `st_union_agg` | No | | `st_within` | No | | `st_x` | No | | `st_xmax` | No | | `st_xmin` | No | | `st_y` | No | | `st_ymax` | No | | `st_ymin` | No | | `st_z` | No | | `st_zmax` | No | | `st_zmin` | No | ## Geospatial Conversion | Function | e6data | | - | - | | `to_geography` | No | | `to_geometry` | No | | `try_to_geography` | No | | `try_to_geometry` | No | ## H3 Geospatial | Function | e6data | | - | - | | `h3_boundaryasgeojson` | No | | `h3_boundaryaswkb` | No | | `h3_boundaryaswkt` | No | | `h3_centerasgeojson` | No | | `h3_centeraswkb` | No | | `h3_centeraswkt` | No | | `h3_compact` | No | | `h3_coverash3` | No | | `h3_coverash3string` | No | | `h3_distance` | No | | `h3_getpentagoncellids` | No | | `h3_h3tostring` | No | | `h3_hexring` | No | | `h3_ischildof` | No | | `h3_ispentagon` | No | | `h3_isvalid` | No | | `h3_kring` | No | | `h3_kringdistances` | No | | `h3_longlatash3` | No | | `h3_longlatash3string` | No | | `h3_maxchild` | No | | `h3_minchild` | No | | `h3_pointash3` | No | | `h3_pointash3string` | No | | `h3_polyfillash3` | No | | `h3_polyfillash3string` | No | | `h3_resolution` | No | | `h3_stringtoh3` | No | | `h3_tessellateaswkb` | No | | `h3_tochildren` | No | | `h3_toparent` | No | | `h3_try_coverash3` | No | | `h3_try_coverash3string` | No | | `h3_try_distance` | No | | `h3_try_polyfillash3` | No | | `h3_try_polyfillash3string` | No | | `h3_try_tessellateaswkb` | No | | `h3_try_validate` | No | | `h3_uncompact` | No | | `h3_validate` | No | ## Hash/Crypto functions | Function | e6data | | - | - | | `aes_decrypt` | No | | `aes_encrypt` | No | | [`crc32`](/query/sql/functions/hash/crc32) | Yes | | `hash` | No | | [`md5`](/query/sql/functions/hash/md5) | No | | [`sha`](/query/sql/functions/hash/sha1) | Yes | | [`sha1`](/query/sql/functions/hash/sha1) | Yes | | [`sha2`](/query/sql/functions/hash/sha2) | Yes | | `try_aes_decrypt` | No | | `xxhash64` | No | ## Higher-Order functions | Function | e6data | | - | - | | `agg` | Yes | | [`aggregate`](/query/sql/functions/array/reduce) | Yes | | `exists` | No | | [`filter`](/query/sql/functions/array/filter) | Yes | | `forall` | No | | `map_filter` | No | | [`reduce`](/query/sql/functions/array/reduce) | Yes | | [`transform`](/query/sql/functions/array/transform) | Yes | | `transform_keys` | No | | `transform_values` | No | | `zip_with` | No | ## HyperLogLog (HLL) | Function | e6data | | - | - | | `hll_cardinality_internal` | No | | `hll_collect_internal` | No | | `hll_sketch_agg` | No | | `hll_sketch_estimate` | No | | `hll_union` | No | | `hll_union_agg` | No | ## Ingestion functions | Function | e6data | | - | - | | `ingestion_describe_table` | No | | `ingestion_list_catalogs` | No | | `ingestion_list_schemas` | No | | `ingestion_list_tables` | No | | `ingestion_read_data` | No | ## IP Address functions | Function | e6data | | - | - | | `ip_as_binary` | No | | `ip_as_string` | No | | `ip_cidr` | No | | `ip_cidr_contains` | No | | `ip_host` | No | | `ip_network` | No | | `ip_network_first` | No | | `ip_network_last` | No | | `ip_prefix_length` | No | | `ip_version` | No | | `try_ip_as_binary` | No | | `try_ip_as_string` | No | | `try_ip_cidr` | No | | `try_ip_host` | No | ## JSON functions | Function | e6data | | - | - | | [`from_json`](/query/sql/functions/json/from_json) | Yes | | [`get_json_object`](/query/sql/functions/json/get_json_object) | Yes | | `json_array_length` | No | | `json_object_keys` | No | | [`json_tuple`](/query/sql/functions/table/json_tuple) | Yes | | [`parse_json`](/query/sql/functions/json/parse_json) | Yes | | `schema_of_json` | No | | `schema_of_json_agg` | No | | [`to_json`](/query/sql/functions/json/to_json) | Yes | | [`try_parse_json`](/query/sql/functions/json/try_parse_json) | Yes | ## KLL Sketch functions | Function | e6data | | - | - | | `kll_collect_internal` | No | | `kll_merge_agg_bigint` | No | | `kll_merge_agg_double` | No | | `kll_merge_agg_float` | No | | `kll_sketch_agg_bigint` | No | | `kll_sketch_agg_double` | No | | `kll_sketch_agg_float` | No | | `kll_sketch_get_n_bigint` | No | | `kll_sketch_get_n_double` | No | | `kll_sketch_get_n_float` | No | | `kll_sketch_get_quantile_bigint` | No | | `kll_sketch_get_quantile_double` | No | | `kll_sketch_get_quantile_float` | No | | `kll_sketch_get_rank_bigint` | No | | `kll_sketch_get_rank_double` | No | | `kll_sketch_get_rank_float` | No | | `kll_sketch_merge_bigint` | No | | `kll_sketch_merge_double` | No | | `kll_sketch_merge_float` | No | | `kll_sketch_to_string_bigint` | No | | `kll_sketch_to_string_double` | No | | `kll_sketch_to_string_float` | No | ## Map functions | Function | e6data | | - | - | | [`map`](/query/sql/functions/map/map) | Yes | | `map_concat` | No | | `map_contains_key` | No | | [`map_entries`](/query/sql/functions/map/map_entries) | Yes | | [`map_from_arrays`](/query/sql/functions/map/map_from_arrays) | No | | [`map_from_entries`](/query/sql/functions/map/map_from_entries) | Yes | | [`map_keys`](/query/sql/functions/map/map_keys) | Yes | | [`map_values`](/query/sql/functions/map/map_values) | Yes | | `map_zip_with` | No | | `str_to_map` | No | ## Math/Numeric functions | Function | e6data | | - | - | | [`abs`](/query/sql/functions/math/abs) | Yes | | [`acos`](/query/sql/functions/math/acos) | Yes | | [`acosh`](/query/sql/functions/math/acosh) | Yes | | [`asin`](/query/sql/functions/math/asin) | Yes | | [`asinh`](/query/sql/functions/math/asinh) | Yes | | [`atan`](/query/sql/functions/math/atan) | Yes | | [`atan2`](/query/sql/functions/math/atan2) | Yes | | [`atanh`](/query/sql/functions/math/atanh) | Yes | | `bround` | No | | [`cbrt`](/query/sql/functions/math/cbrt) | Yes | | [`ceil`](/query/sql/functions/math/ceiling) | Yes | | [`ceiling`](/query/sql/functions/math/ceiling) | Yes | | [`cos`](/query/sql/functions/math/cos) | Yes | | [`cosh`](/query/sql/functions/math/cosh) | Yes | | [`cot`](/query/sql/functions/math/cot) | Yes | | [`csc`](/query/sql/functions/math/cosec) | Yes | | [`degrees`](/query/sql/functions/math/degrees) | Yes | | `div` | No | | `e` | No | | [`exp`](/query/sql/functions/math/exp) | Yes | | `expm1` | No | | [`factorial`](/query/sql/functions/math/factorial) | Yes | | [`floor`](/query/sql/functions/math/floor) | Yes | | `hypot` | No | | [`ln`](/query/sql/functions/math/ln) | Yes | | [`log`](/query/sql/functions/math/log) | Yes | | [`log10`](/query/sql/functions/math/log10) | Yes | | [`log1p`](/query/sql/functions/math/log1p) | Yes | | [`log2`](/query/sql/functions/math/log2) | Yes | | [`mod`](/query/sql/functions/math/mod) | Yes | | `negative` | No | | [`pi`](/query/sql/functions/math/pi) | Yes | | [`pmod`](/query/sql/functions/math/pmod) | Yes | | `positive` | No | | [`pow`](/query/sql/functions/math/power) | Yes | | [`power`](/query/sql/functions/math/power) | Yes | | [`radians`](/query/sql/functions/math/radians) | Yes | | [`rand`](/query/sql/functions/math/rand) | Yes | | `randn` | No | | [`random`](/query/sql/functions/math/rand) | Yes | | [`rint`](/query/sql/functions/math/rint) | Yes | | [`round`](/query/sql/functions/math/round) | Yes | | [`sec`](/query/sql/functions/math/sec) | Yes | | [`sign`](/query/sql/functions/math/sign) | Yes | | [`signum`](/query/sql/functions/math/sign) | Yes | | [`sin`](/query/sql/functions/math/sin) | Yes | | [`sinh`](/query/sql/functions/math/sinh) | Yes | | [`sqrt`](/query/sql/functions/math/sqrt) | Yes | | [`tan`](/query/sql/functions/math/tan) | Yes | | [`tanh`](/query/sql/functions/math/tanh) | Yes | | `try_add` | No | | [`try_divide`](/query/sql/functions/math/try_divide) | Yes | | `try_mod` | No | | [`try_multiply`](/query/sql/functions/math/try_multiply) | Yes | | `try_remainder` | No | | `try_subtract` | No | | `uniform` | No | | [`width_bucket`](/query/sql/functions/math/width_bucket) | Yes | ## MCV Sketch functions | Function | e6data | | - | - | | `mcv_cardinality_internal` | No | | `mcv_collect_internal` | No | ## Operators | Function | e6data | | - | - | | `!` | Yes | | `!=` | Yes | | `%` | Yes | | `&` | Yes | | `*` | Yes | | `+` | Yes | | `-` | Yes | | `/` | Yes | | `<` | Yes | | `<<` | Yes | | `<=` | Yes | | `<=>` | Yes | | `<>` | Yes | | `>` | Yes | | `>=` | Yes | | `>>` | Yes | | `>>>` | Yes | | `^` | No | | `and` | Yes | | `between` | Yes | | [`ilike`](/query/sql/functions/string/ilike) | Yes | | [`in`](/query/sql/functions/conditional/in) | Yes | | [`like`](/query/sql/functions/string/like) | Yes | | [`not`](/query/sql/functions/conditional/not) | Yes | | `or` | Yes | | `\|` | No | | `\|\|` | Yes | | `~` | Yes | ## Regex functions | Function | e6data | | - | - | | `regexp` | No | | [`regexp_count`](/query/sql/functions/regex/regexp_count) | Yes | | [`regexp_extract`](/query/sql/functions/regex/regexp_extract) | Yes | | [`regexp_extract_all`](/query/sql/functions/regex/regexp_extract_all) | Yes | | `regexp_instr` | No | | [`regexp_like`](/query/sql/functions/regex/rlike) | Yes | | [`regexp_replace`](/query/sql/functions/regex/regexp_replace) | Yes | | [`regexp_substr`](/query/sql/functions/regex/regexp_substr) | Yes | | [`rlike`](/query/sql/functions/regex/rlike) | Yes | ## Serialization functions | Function | e6data | | - | - | | `from_avro` | No | | `from_csv` | No | | `from_protobuf` | No | | `schema_of_avro` | No | | `schema_of_csv` | No | | `to_avro` | No | | `to_csv` | No | | `to_protobuf` | No | ## Session/Metadata functions | Function | e6data | | - | - | | [`current_catalog`](/query/sql/functions/conditional/current_catalog) | Yes | | `current_database` | No | | `current_metastore` | No | | `current_oauth_custom_identity_claim` | No | | `current_path` | No | | `current_recipient` | No | | [`current_schema`](/query/sql/functions/conditional/current_schema) | Yes | | `current_user` | No | | `current_version` | No | | `get_session_user_privileges` | No | | `input_file_block_length` | No | | `input_file_block_start` | No | | `input_file_name` | No | | `is_account_group_member` | No | | `is_member` | No | | `monotonically_increasing_id` | No | | `session_user` | No | | `spark_partition_id` | No | | `sql_keywords` | No | | `user` | No | | `user_home_catalog` | No | | [`uuid`](/query/sql/functions/string/uuid) | Yes | | `version` | No | ## String functions | Function | e6data | | - | - | | [`ascii`](/query/sql/functions/string/ascii) | Yes | | [`base64`](/query/sql/functions/string/to_base64) | Yes | | `bin` | No | | `btrim` | Yes | | [`char`](/query/sql/functions/string/chr) | Yes | | [`char_length`](/query/sql/functions/string/character_length) | Yes | | [`character_length`](/query/sql/functions/string/character_length) | Yes | | [`charindex`](/query/sql/functions/string/charindex) | Yes | | [`chr`](/query/sql/functions/string/chr) | Yes | | [`concat`](/query/sql/functions/string/concat) | Yes | | [`concat_ws`](/query/sql/functions/string/concat_ws) | Yes | | `contains` | Yes | | [`conv`](/query/sql/functions/math/conv) | Yes | | [`decode`](/query/sql/functions/conditional/decode) | Yes | | `elt` | No | | [`encode`](/query/sql/functions/string/encode) | Yes | | [`endswith`](/query/sql/functions/string/ends_with) | Yes | | `find_in_set` | No | | [`format_number`](/query/sql/functions/string/format_number) | Yes | | [`format_string`](/query/sql/functions/string/format_string) | Yes | | [`hex`](/query/sql/functions/math/hex) | Yes | | [`initcap`](/query/sql/functions/string/initcap) | Yes | | [`instr`](/query/sql/functions/string/instr) | Yes | | `is_valid_utf8` | No | | [`lcase`](/query/sql/functions/string/lower) | Yes | | [`left`](/query/sql/functions/string/left) | Yes | | [`len`](/query/sql/functions/string/len) | Yes | | [`length`](/query/sql/functions/string/len) | Yes | | [`levenshtein`](/query/sql/functions/string/levenshtein) | Yes | | [`locate`](/query/sql/functions/string/charindex) | Yes | | [`lower`](/query/sql/functions/string/lower) | Yes | | [`lpad`](/query/sql/functions/string/lpad) | Yes | | [`ltrim`](/query/sql/functions/string/ltrim) | Yes | | `make_valid_utf8` | No | | [`octet_length`](/query/sql/functions/string/octet_length) | Yes | | [`overlay`](/query/sql/functions/string/overlay) | Yes | | [`parse_url`](/query/sql/functions/string/parse_url) | Yes | | [`position`](/query/sql/functions/string/position) | Yes | | `printf` | Yes | | `quote` | No | | `randstr` | No | | [`repeat`](/query/sql/functions/string/repeat) | Yes | | [`replace`](/query/sql/functions/string/replace) | Yes | | [`reverse`](/query/sql/functions/string/reverse) | Yes | | [`right`](/query/sql/functions/string/right) | Yes | | [`rpad`](/query/sql/functions/string/rpad) | Yes | | [`rtrim`](/query/sql/functions/string/rtrim) | Yes | | `sentences` | No | | [`soundex`](/query/sql/functions/string/soundex) | No | | `space` | No | | [`split`](/query/sql/functions/string/split) | Yes | | [`split_part`](/query/sql/functions/string/split_part) | Yes | | [`startswith`](/query/sql/functions/string/starts_with) | Yes | | `stringdecode` | No | | [`substr`](/query/sql/functions/string/substring) | Yes | | [`substring`](/query/sql/functions/string/substring) | Yes | | [`substring_index`](/query/sql/functions/string/substring_index) | Yes | | [`to_char`](/query/sql/functions/date-time/to_varchar) | Yes | | [`to_varchar`](/query/sql/functions/date-time/to_varchar) | Yes | | [`translate`](/query/sql/functions/string/translate) | Yes | | [`trim`](/query/sql/functions/string/trim) | Yes | | [`try_url_decode`](/query/sql/functions/string/try_url_decode) | Yes | | `try_validate_utf8` | No | | [`ucase`](/query/sql/functions/string/upper) | Yes | | [`unbase64`](/query/sql/functions/string/from_base64) | Yes | | `unhex` | No | | [`upper`](/query/sql/functions/string/upper) | Yes | | [`url_decode`](/query/sql/functions/string/url_decode) | Yes | | [`url_encode`](/query/sql/functions/string/url_encode) | Yes | | `validate_utf8` | No | ## Struct functions | Function | e6data | | - | - | | [`named_struct`](/query/sql/functions/struct/named_struct) | Yes | | `struct` | Yes | ## Tag/Governance functions | Function | e6data | | - | - | | `get_column_tag_value` | No | | `get_tag_value` | No | | `has_tag` | No | | `has_tag_value` | No | | `hastag` | No | | `hastagvalue` | No | ## Theta Sketch functions | Function | e6data | | - | - | | `theta_difference` | No | | `theta_intersection` | No | | `theta_intersection_agg` | No | | `theta_sketch_agg` | No | | `theta_sketch_estimate` | No | | `theta_union` | No | | `theta_union_agg` | No | ## Tuple Sketch functions | Function | e6data | | - | - | | `tuple_difference_double` | No | | `tuple_difference_integer` | No | | `tuple_difference_theta_double` | No | | `tuple_difference_theta_integer` | No | | `tuple_intersection_agg_double` | No | | `tuple_intersection_agg_integer` | No | | `tuple_intersection_double` | No | | `tuple_intersection_integer` | No | | `tuple_intersection_theta_double` | No | | `tuple_intersection_theta_integer` | No | | `tuple_sketch_agg_double` | No | | `tuple_sketch_agg_integer` | No | | `tuple_sketch_estimate_double` | No | | `tuple_sketch_estimate_integer` | No | | `tuple_sketch_summary_double` | No | | `tuple_sketch_summary_integer` | No | | `tuple_sketch_theta_double` | No | | `tuple_sketch_theta_integer` | No | | `tuple_union_agg_double` | No | | `tuple_union_agg_integer` | No | | `tuple_union_double` | No | | `tuple_union_integer` | No | | `tuple_union_theta_double` | No | | `tuple_union_theta_integer` | No | ## Type Casting | Function | e6data | | - | - | | `bigint` | No | | `binary` | No | | `boolean` | No | | [`cast`](/query/sql/functions/conditional/cast) | Yes | | `decimal` | No | | `double` | No | | `float` | No | | `int` | No | | `smallint` | No | | `string` | No | | [`timestamp`](/query/sql/functions/date-time/timestamp) | Yes | | `tinyint` | No | | `to_binary` | No | | `to_number` | No | | `try_to_binary` | No | | [`try_to_number`](/query/sql/functions/conditional/try_to_number) | Yes | | [`typeof`](/query/sql/functions/conditional/typeof) | Yes | ## Utility/Misc | Function | e6data | | - | - | | `assert_true` | No | | `classifier` | No | | `collate` | No | | `collation` | No | | `collations` | No | | `event_log` | No | | `get_warmup_tracing` | No | | `http_request` | No | | `isearch` | No | | [`isnan`](/query/sql/functions/math/isnan) | Yes | | `isnotnull` | Yes | | [`isnull`](/query/sql/functions/conditional/isnull) | Yes | | `java_method` | No | | `list_secrets` | No | | `luhn_check` | No | | `mask` | No | | `match_number` | No | | `metric_store` | No | | `next` | No | | `prev` | No | | `python_worker_logs` | No | | `raise_error` | No | | `reflect` | No | | `remote_query` | No | | `search` | No | | `secret` | No | | `try_reflect` | No | | `try_secret` | No | | `window` | No | | `window_time` | No | ## Variant/Semi-structured | Function | e6data | | - | - | | `is_variant_null` | No | | `schema_of_variant` | No | | `schema_of_variant_agg` | No | | `to_variant_object` | No | | [`try_variant_get`](/query/sql/functions/json/try_variant_get) | Yes | | `variant_explode` | No | | `variant_explode_outer` | No | | [`variant_get`](/query/sql/functions/json/variant_get) | Yes | ## Vector functions | Function | e6data | | - | - | | `vector_avg` | No | | `vector_cosine_similarity` | No | | `vector_inner_product` | No | | `vector_l2_distance` | No | | `vector_norm` | No | | `vector_normalize` | No | | `vector_search` | No | | `vector_sum` | No | ## Window functions | Function | e6data | | - | - | | [`cume_dist`](/query/sql/functions/window/cume_dist) | Yes | | [`dense_rank`](/query/sql/functions/window/dense_rank) | Yes | | [`lag`](/query/sql/functions/window/lag) | Yes | | [`lead`](/query/sql/functions/window/lead) | Yes | | `nth_value` | No | | [`ntile`](/query/sql/functions/window/ntile) | Yes | | `percent_rank` | No | | [`rank`](/query/sql/functions/window/rank) | Yes | | [`row_number`](/query/sql/functions/window/row_number) | Yes | ## XML functions | Function | e6data | | - | - | | `from_xml` | No | | `schema_of_xml` | No | | `to_xml` | No | | `xpath` | No | | `xpath_boolean` | No | | `xpath_double` | No | | `xpath_float` | No | | `xpath_int` | No | | `xpath_long` | No | | `xpath_number` | No | | `xpath_short` | No | | `xpath_string` | No | ## Uncategorized | Function | e6data | | - | - | | `lcm` | No | ## Names from other SQL dialects | Function | e6data | | - | - | | `approx_distinct` | Yes | | `array_cat` | Yes | | [`array_concat`](/query/sql/functions/array/array_concat) | Yes | | `array_element` | Yes | | `array_has_any` | Yes | | `array_indexof` | Yes | | `array_length` | Yes | | `array_reverse` | Yes | | [`array_slice`](/query/sql/functions/array/array_slice) | Yes | | [`array_to_string`](/query/sql/functions/array/array_to_string) | Yes | | [`array_unique_agg`](/query/sql/functions/aggregate/array_unique_agg) | Yes | | `binary_length` | Yes | | [`bitwise_arithmetic_shift_right`](/query/sql/functions/bitwise/shiftright) | Yes | | [`bitwise_logical_shift_right`](/query/sql/functions/bitwise/bitwise_logical_shift_right) | Yes | | [`bitwise_not`](/query/sql/functions/bitwise/bitwise_not) | Yes | | [`bitwise_shift_left`](/query/sql/functions/bitwise/bitwise_shift_left) | Yes | | [`cosec`](/query/sql/functions/math/cosec) | Yes | | `covar` | Yes | | `date32_to_string` | Yes | | `date_from_parts` | Yes | | `datesub` | Yes | | [`datetime`](/query/sql/functions/date-time/datetime) | Yes | | [`days`](/query/sql/functions/date-time/day) | Yes | | `e6_concat_ws` | Yes | | `e6_decode_string` | Yes | | `e6_from_base64` | Yes | | `e6_instr` | Yes | | `e6_to_base64` | Yes | | `e6_to_hex` | Yes | | [`ends_with`](/query/sql/functions/string/ends_with) | Yes | | [`format_date`](/query/sql/functions/date-time/date_format) | Yes | | [`format_timestamp`](/query/sql/functions/date-time/format_timestamp) | Yes | | [`from_unixtime_withunit`](/query/sql/functions/date-time/from_unixtime_withunit) | Yes | | [`generate_date_array`](/query/sql/functions/date-time/generate_date_array) | Yes | | [`generate_timestamp_array`](/query/sql/functions/date-time/generate_timestamp_array) | Yes | | `get_field` | Yes | | [`get_path`](/query/sql/functions/json/get_path) | Yes | | [`getutcdate`](/query/sql/functions/date-time/getutcdate) | Yes | | [`json_extract`](/query/sql/functions/json/json_extract) | Yes | | [`json_extract_scalar`](/query/sql/functions/json/json_value) | Yes | | [`json_format`](/query/sql/functions/json/json_format) | Yes | | [`json_value`](/query/sql/functions/json/json_value) | Yes | | `left_shift` | Yes | | `list_cat` | Yes | | `list_compact` | Yes | | `list_concat` | Yes | | `list_has_any` | Yes | | `list_indexof` | Yes | | `list_intersect` | Yes | | `list_join` | Yes | | `list_length` | Yes | | `list_max` | Yes | | `list_position` | Yes | | `list_reverse` | Yes | | `list_slice` | Yes | | `list_to_string` | Yes | | `make_array` | Yes | | `make_list` | Yes | | [`map_coalesce_extract`](/query/sql/functions/map/map_coalesce_extract) | Yes | | `map_size` | Yes | | [`object_agg`](/query/sql/functions/aggregate/object_agg) | Yes | | `quantile_cont` | Yes | | [`regexp_contains`](/query/sql/functions/regex/regexp_contains) | Yes | | `right_shift` | Yes | | [`row`](/query/sql/functions/struct/row) | Yes | | `sign_interval` | Yes | | `snowflake_initcap` | Yes | | `snowflake_random` | Yes | | [`starts_with`](/query/sql/functions/string/starts_with) | Yes | | `substr_index` | Yes | | `sum0` | Yes | | [`timestamp_add`](/query/sql/functions/date-time/timestamp_add) | Yes | | [`timestamp_diff`](/query/sql/functions/date-time/timestampdiff) | Yes | | [`to_hex`](/query/sql/functions/string/to_hex) | Yes | | [`to_timestamp_tz`](/query/sql/functions/date-time/to_timestamp_tz) | Yes | | [`to_unixtime`](/query/sql/functions/date-time/to_unixtime) | Yes | | `today` | Yes | | `try_map_element` | Yes | | `var` | Yes | | `var_sample` | Yes | | `variant_flatten` | Yes | | `week_of_year` | Yes | This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.