SPRKPY1018

pyspark.sql.functions.date_sub has a workaround

Category

Warning.

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)

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)

Recommendation

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