SnowConvert AI - Understanding Converted Code¶

定义

SnowConvert AI produces messages in the converted code that highlight areas requiring additional work to ensure the code functions correctly in Snowflake.

EWI（错误、警告和问题）¶

When SnowConvert AI cannot completely convert a code segment, it generates an Error, Warning, and Issue (EWI) message. Each EWI negatively affects the conversion rate of a code unit. Here are the common reasons why SnowConvert AI might not fully convert code:

• 尚未创建所需转换规则
• 缺少保证转换规则生效所需的依赖代码
• Snowflake 中没有等效语句，或者尚未开发用户定义函数 (UDF) 来提供所需功能

SnowConvert AI adds a !!!RESOLVE EWI!!! marker before each EWI (Error, Warning, and Issue) message. This marker causes compilation to fail, ensuring that developers address these issues before deploying the converted code.

The SnowConvert AI team categorizes EWIs (Errors, Warnings, and Issues) into four severity levels based on the average effort required to fix the code:

• 低
• 中
• 高
• 关键

FDM（功能差异消息）¶

将代码从传统平台（例如 Teradata、Oracle 或 SQL Server）转换到 Snowflake 时，必须了解这些系统具有不同的特性和功能。由于这些差异，自动转换可能无法提供完全等效的功能，通常需要手动干预来弥合这些差距。

A Functional Difference Message (FDM) appears when SnowConvert AI successfully converts code that compiles correctly but may not function exactly like the original source code. This can happen when Snowflake doesn’t support certain features from the source platform. Resolving these differences often requires business decisions or architectural changes beyond simple code conversion. Since FDMs are added as comments to working code, they don’t affect the code’s ability to compile.

PRF（性能审查）¶

这些警告消息会添加到转换后代码中，以告知用户尽管代码已正确转换，但在某些情况下可能无法达到最佳性能。为了在 Snowflake 中获得最佳性能，可能需要作出部分代码修改。

OOS（超出范围）¶

As explained in the conversion scope page and the out of scope messages section, certain code units cannot be automatically converted. SnowConvert AI will generate messages to inform users when a code unit has not been converted.

新代码格式

We have updated the format of Error, Warning, and Issue (EWI) messages to be more user-friendly. The new format makes it easier to identify both the message type and the programming language it relates to. Below, we’ll explain these changes with examples.

通用

General Errors, Warnings, and Issues (EWIs) that do not correspond to any specific programming language supported by SnowConvert AI will no longer use the code 1000. Instead, these EWIs will be identified by the absence of a language-specific abbreviation.

示例

Teradata¶

Teradata Errors, Warnings, and Issues (EWIs) previously used codes starting with 2000. Now, these codes will begin with ‘TD’ followed by the numeric portion.

示例

Oracle¶

Oracle Errors, Warnings, and Issues (EWIs) previously used codes starting with 3000. Now, these codes will begin with ‘OR’ followed by the numeric portion of the code.

示例

SQL Server¶

SQL Server Errors, Warnings, and Issues (EWIs) codes have been updated. Previously, these codes started with 2000. Now, they begin with ‘TS’ followed by a numeric value.

示例

类别已更改为 FDM¶

类别已更改为 PRF¶

已弃用 EWIs¶