SSC-EWI-TS0002
The ANSI_PADDING OFF is not supported in Snowflake.
Severity
Low
Description
In Transact-SQL, the statement SET ANSI_PADDING OFF
removes the trailing spaces in the insertion of char Data types. Since SET ANSI_PADDING OFF
is not a directly configurable setting in Snowflake; SnowConvert will generate this EWI.
Example Code
SQL Server
Snowflake
Recommendations
Add
RTRIM
to allCHAR()
data type insertions to remove this issue, including ETL code.If you need more support, you can email us at snowconvert-support@snowflake.com
Last updated