functions
pyspark.sql.functions => snowflake.snowpark.functions
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
Was this helpful?