PNDSPY1260¶

Message Pandas < pandas.io.json._json.read_json > has a partial mapping with a few scenarios not supported in Snowpark.

Category Warning

Description¶

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.

Missing or Unsupported Parameters: orient, typ, dtype, convert_axes, lines, convert_dates, date_unit, keep_default_dates, encoding_errors, nrows, and chunksize will raise an error. precise_float, engine, dtype_backend, and storage_options are ignored.

Reason: P: - if ndjson files are passed - Supported parameters are compression and encoding.

Scenario¶

A method with a few scenarios that aren’t supported in Snowpark.

Input¶

The following example shows a method with a few unsupported scenarios in Snowpark.

import pandas as pd

df = pd.DataFrame({'A': [1, 2, 3], 'B': [4, 5, 6]})
result = pd.read_json(df)

Copy

Output¶

The SMA adds the EWI PNDSPY1260 to the output code to let you know that this element has a few scenarios that aren’t supported in Snowpark.

import snowflake.snowpark.modin.pandas as pd

#EWI: PNDSPY1260 => pandas.io.json._json.read_json has a partial mapping, with few scenarios not supported. Check Snowpark pandas documentation for more detail.
df = pd.DataFrame({'A': [1, 2, 3], 'B': [4, 5, 6]})
result = pd.read_json(df)

Copy

Recommended fix¶

The following parameters are not supported in Snowpark pandas: orient, typ, dtype, convert_axes, lines, convert_dates, date_unit, keep_default_dates, encoding_errors, nrows, and chunksize will raise an error. precise_float, engine, dtype_backend, and storage_options are ignored..

Recommended approaches:

Avoid unsupported parameters: Modify your code to not use these parameters if they are not essential.

Use .to_pandas() for full compatibility: If you need these parameters, convert to native pandas first:

# Convert to native pandas when unsupported parameters are needed
native_df = df.to_pandas()
result = native_df.read_json(...)  # Use all parameters

Copy

Split the operation: Perform supported operations in Snowpark pandas, then use native pandas only for the unsupported functionality.

Behavioral note: P: - if ndjson files are passed - Supported parameters are compression and encoding.

This behavior may differ from native pandas. Recommended actions:

Test with a representative sample of your data
Compare results with native pandas if precision is critical
Use .to_pandas() if exact pandas behavior is required

Additional recommendations¶

Check the Snowpark pandas documentation to verify which scenarios aren’t supported for that specific element.