Source
NTH_VALUE
Returns the nth value (up to 1000) within an ordered group of values.
PNDSPY1223
This issue appears when the SMA detects the use of a pandas element that has a direct equivalent in Snowpark pandas, but some scenarios might behave differently than pandas. Reason: N if pat is non - string, repl is a non - string, or n is…
PERCENT_RANK
PERCENT_RANK is calculated as: If n is 1: PERCENT_RANK = 0 If n is greater than 1: PERCENT_RANK = (r - 1) / (n - 1) where r is the RANK of the row and n is the number of rows in the window partition.
String functions (regular expressions)
By default, the POSIX wildcard character . (in the pattern) does not include newline characters \n (in the subject) as matches. To also match newline characters, either replace . with (.|\n) in the pattern argument, or use the s parameter…
PNDSPY1243
This issue appears when the SMA detects the use of a pandas element that has a direct equivalent in Snowpark pandas, but some scenarios might behave differently than pandas. Reason: N for axis = 1 or min_periods = 0. N for string window…
PNDSPY1226
This issue appears when the SMA detects the use of a pandas element that has a direct equivalent in Snowpark pandas, but some scenarios might behave differently than pandas. Reason: N if pat is non - string, n is non - numeric, or regex is…
PNDSPY1244
This issue appears when the SMA detects the use of a pandas element that has a direct equivalent in Snowpark pandas, but some scenarios might behave differently than pandas. Reason: N for axis = 1 or min_periods = 0. N for string window…
TYPEOF
Returns a VARCHAR value that contains the data type of the input expression, such as BOOLEAN, DECIMAL, ARRAY, OBJECT, and so on. Usage notes The returned string might be DECIMAL even if the input is an exact integer, due to optimizations…
PNDSPY1237
This issue appears when the SMA detects the use of a pandas element that has a direct equivalent in Snowpark pandas, but some scenarios might behave differently than pandas. Reason: N for axis = 1 or min_periods = 0. N for string window…
PNDSPY1252
This issue appears when the SMA detects the use of a pandas element that has a direct equivalent in Snowpark pandas, but some scenarios might behave differently than pandas. Reason: N for axis = 1 or min_periods = 0. N for string window…