SPRKPY1037

pyspark.sql.functions.sort_array has a workaround

Description

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

Input code:

sort_array(data, True)

Output code:

#EWI: SPRKPY1037 => pyspark.sql.functions.sort_array has a workaround, see documentation for more info
sort_array(data)

Scenario

sort_array(col: Column, asc: bool = True)

Action: Import snowpark_extensions package, which contains a helper for array_sort function.

import snowpark_extensions
array_sort(data)

Recommendation

  • For more support, you can email us at snowconvert-info@snowflake.com. If you have a contract for support with Snowflake, reach out to your sales engineer and they can direct your support needs.

#332: [SIT-1562] SQL Readiness

Change request updated