functions

pyspark.sql.functions => snowflake.snowpark.functions

FullnameSupportedAutomatedStatus

pyspark.sql.functions

TRUE

TRUE

Direct

pyspark.sql.functions.abs

TRUE

TRUE

Direct

pyspark.sql.functions.acos

TRUE

TRUE

Direct

pyspark.sql.functions.add_months

TRUE

TRUE

Direct

pyspark.sql.functions.approx_count_distinct

TRUE

TRUE

Direct

pyspark.sql.functions.array

TRUE

TRUE

Direct

pyspark.sql.functions.array_contains

TRUE

TRUE

Direct

pyspark.sql.functions.array_distinct

TRUE

TRUE

Direct

pyspark.sql.functions.array_intersect

TRUE

TRUE

Rename

pyspark.sql.functions.array_join

TRUE

TRUE

Rename

pyspark.sql.functions.array_max

TRUE

TRUE

Direct

pyspark.sql.functions.array_min

TRUE

TRUE

Direct

pyspark.sql.functions.array_position

TRUE

TRUE

Direct

pyspark.sql.functions.array_sort

TRUE

TRUE

Direct

pyspark.sql.functions.arrays_overlap

TRUE

TRUE

Direct

pyspark.sql.functions.asc

TRUE

TRUE

Direct

pyspark.sql.functions.asc_nulls_first

TRUE

TRUE

Direct

pyspark.sql.functions.asc_nulls_last

TRUE

TRUE

Direct

pyspark.sql.functions.ascii

TRUE

TRUE

Direct

pyspark.sql.functions.asin

TRUE

TRUE

Direct

pyspark.sql.functions.atan

TRUE

TRUE

Direct

pyspark.sql.functions.atan2

TRUE

TRUE

Direct

pyspark.sql.functions.avg

TRUE

TRUE

Direct

pyspark.sql.functions.bin

TRUE

TRUE

Rename

pyspark.sql.functions.broadcast

TRUE

TRUE

Transformation

pyspark.sql.functions.bround

TRUE

TRUE

Direct

pyspark.sql.functions.ceil

TRUE

TRUE

Direct

pyspark.sql.functions.coalesce

TRUE

TRUE

Direct

pyspark.sql.functions.col

TRUE

TRUE

Direct

pyspark.sql.functions.column

TRUE

TRUE

Direct

pyspark.sql.functions.concat

TRUE

TRUE

Direct

pyspark.sql.functions.concat_ws

TRUE

TRUE

Direct

pyspark.sql.functions.corr

TRUE

TRUE

Direct

pyspark.sql.functions.cos

TRUE

TRUE

Direct

pyspark.sql.functions.cosh

TRUE

TRUE

Direct

pyspark.sql.functions.count

TRUE

TRUE

Direct

pyspark.sql.functions.count_distinct

TRUE

TRUE

Direct

pyspark.sql.functions.countDistinct

TRUE

TRUE

Direct

pyspark.sql.functions.covar_pop

TRUE

TRUE

Direct

pyspark.sql.functions.covar_samp

TRUE

TRUE

Direct

pyspark.sql.functions.create_map

TRUE

TRUE

Helper

pyspark.sql.functions.cume_dist

TRUE

TRUE

Direct

pyspark.sql.functions.current_date

TRUE

TRUE

Direct

pyspark.sql.functions.current_timestamp

TRUE

TRUE

Direct

pyspark.sql.functions.date_add

TRUE

TRUE

Direct

pyspark.sql.functions.date_format

TRUE

TRUE

Direct

pyspark.sql.functions.date_sub

TRUE

TRUE

Direct

pyspark.sql.functions.date_trunc

TRUE

TRUE

Direct

pyspark.sql.functions.datediff

TRUE

TRUE

Rename

pyspark.sql.functions.dayofmonth

TRUE

TRUE

Direct

pyspark.sql.functions.dayofweek

TRUE

TRUE

Direct

pyspark.sql.functions.dayofyear

TRUE

TRUE

Direct

pyspark.sql.functions.degrees

TRUE

TRUE

Direct

pyspark.sql.functions.dense_rank

TRUE

TRUE

Direct

pyspark.sql.functions.desc

TRUE

TRUE

Direct

pyspark.sql.functions.desc_nulls_first

TRUE

TRUE

Direct

pyspark.sql.functions.desc_nulls_last

TRUE

TRUE

Direct

pyspark.sql.functions.explode

TRUE

TRUE

Direct

pyspark.sql.functions.explode_outer

TRUE

TRUE

Direct

pyspark.sql.functions.expr

TRUE

TRUE

Direct

pyspark.sql.functions.factorial

TRUE

TRUE

Direct

pyspark.sql.functions.format_number

TRUE

TRUE

Direct

pyspark.sql.functions.first

TRUE

TRUE

Rename

pyspark.sql.functions.flatten

TRUE

TRUE

Rename

pyspark.sql.functions.floor

TRUE

TRUE

Direct

pyspark.sql.functions.from_unixtime

TRUE

TRUE

Direct

pyspark.sql.functions.greatest

TRUE

TRUE

Direct

pyspark.sql.functions.grouping

TRUE

TRUE

Direct

pyspark.sql.functions.grouping_id

TRUE

TRUE

Direct

pyspark.sql.functions.hash

TRUE

TRUE

Direct

pyspark.sql.functions.hour

TRUE

TRUE

Direct

pyspark.sql.functions.initcap

TRUE

TRUE

Direct

pyspark.sql.functions.isnull

TRUE

TRUE

Rename

pyspark.sql.functions.kurtosis

TRUE

TRUE

Direct

pyspark.sql.functions.lag

TRUE

TRUE

Direct

pyspark.sql.functions.first

TRUE

TRUE

Rename

pyspark.sql.functions.last

TRUE

TRUE

Rename

pyspark.sql.functions.last_day

TRUE

TRUE

Direct

pyspark.sql.functions.lead

TRUE

TRUE

Direct

pyspark.sql.functions.least

TRUE

TRUE

Direct

pyspark.sql.functions.length

TRUE

TRUE

Direct

pyspark.sql.functions.lit

TRUE

TRUE

Direct

pyspark.sql.functions.log

TRUE

TRUE

Direct

pyspark.sql.functions.log10

TRUE

TRUE

Rename

pyspark.sql.functions.log2

TRUE

TRUE

Rename

pyspark.sql.functions.lower

TRUE

TRUE

Direct

pyspark.sql.functions.lpad

TRUE

TRUE

Direct

pyspark.sql.functions.ltrim

TRUE

TRUE

Direct

pyspark.sql.functions.map_keys

TRUE

TRUE

Rename

pyspark.sql.functions.max

TRUE

TRUE

Direct

pyspark.sql.functions.md5

TRUE

TRUE

Direct

pyspark.sql.functions.mean

TRUE

TRUE

Direct

pyspark.sql.functions.min

TRUE

TRUE

Direct

pyspark.sql.functions.minute

TRUE

TRUE

Direct

pyspark.sql.functions.month

TRUE

TRUE

Direct

pyspark.sql.functions.months_between

TRUE

TRUE

Direct

pyspark.sql.functions.next_day

TRUE

TRUE

Direct

pyspark.sql.functions.percent_rank

TRUE

TRUE

Direct

pyspark.sql.functions.pow

TRUE

TRUE

Direct

pyspark.sql.functions.quarter

TRUE

TRUE

Direct

pyspark.sql.functions.radians

TRUE

TRUE

Direct

pyspark.sql.functions.rand

TRUE

TRUE

Rename

pyspark.sql.functions.rank

TRUE

TRUE

Direct

pyspark.sql.functions.regexp_extract

TRUE

TRUE

Direct

pyspark.sql.functions.regexp_replace

TRUE

TRUE

Direct

pyspark.sql.functions.repeat

TRUE

TRUE

Direct

pyspark.sql.functions.rint

TRUE

TRUE

Rename

pyspark.sql.functions.round

TRUE

TRUE

Direct

pyspark.sql.functions.row_number

TRUE

TRUE

Direct

pyspark.sql.functions.rpad

TRUE

TRUE

Direct

pyspark.sql.functions.rtrim

TRUE

TRUE

Direct

pyspark.sql.functions.second

TRUE

TRUE

Direct

pyspark.sql.functions.sequence

TRUE

TRUE

Direct

pyspark.sql.functions.sha1

TRUE

TRUE

Direct

pyspark.sql.functions.sha2

TRUE

TRUE

Direct

pyspark.sql.functions.shiftLeft

TRUE

TRUE

Rename

pyspark.sql.functions.shiftRight

TRUE

TRUE

Rename

pyspark.sql.functions.sin

TRUE

TRUE

Direct

pyspark.sql.functions.sinh

TRUE

TRUE

Direct

pyspark.sql.functions.size

TRUE

TRUE

Rename

pyspark.sql.functions.skewness

TRUE

TRUE

Rename

pyspark.sql.functions.soundex

TRUE

TRUE

Direct

pyspark.sql.functions.split

TRUE

TRUE

Direct

pyspark.sql.functions.sqrt

TRUE

TRUE

Direct

pyspark.sql.functions.stddev

TRUE

TRUE

Direct

pyspark.sql.functions.stddev_pop

TRUE

TRUE

Direct

pyspark.sql.functions.stddev_samp

TRUE

TRUE

Direct

pyspark.sql.functions.struct

TRUE

FALSE

WorkAround

pyspark.sql.functions.substring

TRUE

TRUE

Direct

pyspark.sql.functions.substring_index

TRUE

TRUE

Direct

pyspark.sql.functions.sum

TRUE

TRUE

Direct

pyspark.sql.functions.sum_distinct

TRUE

TRUE

Direct

pyspark.sql.functions.sumDistinct

TRUE

TRUE

Rename

pyspark.sql.functions.ntile

TRUE

TRUE

Direct

pyspark.sql.functions.tan

TRUE

TRUE

Direct

pyspark.sql.functions.tanh

TRUE

TRUE

Direct

pyspark.sql.functions.to_date

TRUE

TRUE

Direct

pyspark.sql.functions.to_json

TRUE

TRUE

Direct

pyspark.sql.functions.to_timestamp

TRUE

TRUE

Direct

pyspark.sql.functions.toDegrees

TRUE

TRUE

Rename

pyspark.sql.functions.toRadians

TRUE

TRUE

Rename

pyspark.sql.functions.translate

TRUE

TRUE

Direct

pyspark.sql.functions.trim

TRUE

TRUE

Direct

pyspark.sql.functions.trunc

TRUE

TRUE

Direct

pyspark.sql.functions.udf

TRUE

TRUE

Direct

pyspark.sql.functions.upper

TRUE

TRUE

Direct

pyspark.sql.functions.var_pop

TRUE

TRUE

Direct

pyspark.sql.functions.var_samp

TRUE

TRUE

Direct

pyspark.sql.functions.variance

TRUE

TRUE

Direct

pyspark.sql.functions.weekofyear

TRUE

TRUE

Direct

pyspark.sql.functions.when

TRUE

TRUE

Direct

pyspark.sql.functions.year

TRUE

TRUE

Direct

pyspark.sql.pandas.functions.pandas_udf

FALSE

FALSE

NotSupported

pyspark.sql.functions.monotonically_increasing_id

TRUE

TRUE

Direct

pyspark.sql.functions.reverse

TRUE

TRUE

Direct

Last updated