search
SnowflakeDocumentation Home

SPRKPY1018

pyspark.sql.functions.date_sub has a workaround

hashtag
Category

Warning.

hashtag
Description

This issue appears when the tool detects the usage of pyspark.sql.functions.date_sub which has a workaround.

Input code:

col = date_sub(colName, 5)

Output code:

#EWI: SPRKPY1018 => pyspark.sql.functions.date_sub has a workaround, see documentation for more info
col = date_sub(colName, 5)

hashtag
Scenario:

date_sub(start: ColumnOrName, days: int) Action: Import snowpark_extensions package, which contains a helper for date_sub function.

import snowpark_extensions
col = date_sub(colName, 5)

hashtag
Recommendation

  • For more support, you can email us at [email protected]envelope. If you have a contract for support with Snowflake, reach out to your sales engineer and they can direct your support needs.

PreviousSPRKPY1017NextSPRKPY1019