SPRKDBX1001

The %run command has a partial mapping, because it has a different behavior in Snowpark.

Message: The %run command has a partial mapping, because it has a different behavior in Snowpark.

Category: Conversion Error.

Description

This issue appears when the SMA detects the use of the %run command that does not have a direct equivalent in Snowpark. The way the %run command works in DBX is similar to an import, meaning it includes the code from another notebook into the current one, sharing variables, functions and states with the notebook where the command was executed.

Scenario

Input

Below is an example the %run command.

%run /Workspace/Users/path/to/Notebook/notebookName

Output

The SMA adds the EWI SPRKDBX1001 on the output code to let you know that this element has a different behavior in Snowpark.

EWI: SPRKDBX1001 => The %run command has a partial mapping, because it has a different behavior in Snowpark.
%python
spark.sql("EXECUTE NOTEBOOK <DATABASE>.<SCHEMA>.notebookName()")

Recommended fix

There is no recommended fix, you can't use import as an approach for this scenario because this just works with .py files, that's the reason for using EXECUTE NOTEBOOK, but it has a different behavior from %run.

Please note that even though the element has a partial mapping, it does not necessarily mean that a solution or workaround cannot be found. It only means that the SMA itself cannot find the solution.

Additional recommendations

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