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
SET ANSI_PADDING OFF;
Snowflake
!!!RESOLVE EWI!!! /*** SSC-EWI-TS0002 - THE ANSI_PADDING OFF IS NOT SUPPORTED IN SNOWFLAKE. ***/!!!
SET ANSI_PADDING OFF;
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 [email protected]
Last updated