Snowpark Migration Accelerator: SparkSQL

Issues Codes

All of the warnings, parsing errors, and conversion exceptions generated by the SMA when SparkSQL is selected as the Database language to migrate SQL statements will appear below. If you have any concerns or see something that is not right, please reach out to the SMA support team at sma-support@snowflake.com.

Code

Description

Category

Deprecated

SPRKSQPQL1001

Unrecognized token

Parsing Error

SPRKSPSQL1002

Unsupported statement in Snowflake

Conversion Error

SPRKSPSQL1003

The name expression is currently not supported in Snowflake.

Conversion Error

SPRKSPSQL1005

TblProperties is not supported in Snowflake

Conversion Error

Language: English