Window supported APIs¶

The following table is structured as follows: The first column contains the method name. The second column is a flag for whether or not there is an implementation in Snowpark for the method in the left column.

Note

Y stands for yes, i.e., supports distributed implementation, N stands for no and API simply errors out, P stands for partial (meaning some parameters may not be supported yet), and D stands for defaults to single node pandas execution via UDF/Sproc. engine and engine_kwargs are always ignored in Snowpark pandas. The execution engine will always be Snowflake.

Rolling window functions

Rolling window functions	Snowpark implemented? (Y/N/P/D)	Notes for current implementation
`aggregate`	N
`apply`	N
`corr`	N
`count`	N
`cov`	N
`kurt`	N
`max`	P	Supports integer `window`, `min_periods >= 1`, and `center` for `axis = 0`
`mean`	P	Supports integer `window`, `min_periods >= 1`, and `center` for `axis = 0`
`median`	N
`min`	P	Supports integer `window`, `min_periods >= 1`, and `center` for `axis = 0`
`quantile`	N
`rank`	N
`sem`	N
`skew`	N
`std`	P	Supports integer `window`, `min_periods >= 1`, and `center` for `axis = 0`
`sum`	P	Supports integer `window`, `min_periods >= 1`, and `center` for `axis = 0`
`var`	P	Supports integer `window`, `min_periods >= 1`, and `center` for `axis = 0`

Weighted window functions

Weighted window functions	Snowpark implemented? (Y/N/P/D)	Notes for current implementation
`mean`	N
`std`	N
`sum`	N
`var`	N

Expanding window functions

Expanding window functions	Snowpark implemented? (Y/N/P/D)	Notes for current implementation
`aggregate`	N
`apply`	N
`corr`	N
`count`	N
`cov`	N
`kurt`	N
`max`	N
`mean`	N
`median`	N
`min`	N
`quantile`	N
`rank`	N
`sem`	N
`skew`	N
`std`	N
`sum`	N
`var`	N

Exponentially-weighted window functions

Exponential moving window functions	Snowpark implemented? (Y/N/P/D)	Notes for current implementation
`corr`	N
`cov`	N
`mean`	N
`std`	N
`sum`	N
`var`	N

Window indexer

Window Functions	Snowpark implemented? (Y/N/P/D)	Notes for current implementation
`api.indexers.BaseIndexer`	N
`api.indexers.FixedForwardWindowIndexer`	N
`api.indexers.VariableOffsetWindowIndexer`	N