When you run a mapping in SQL ELT mode to write data of the Decimal data type to a Snowflake target from an Amazon S3 or Microsoft Azure Data Lake Storage Gen2 source, the mapping writes the Decimal data type with a default scale of 0. (July 2025)

A mapping fails without an error message in the session log and continues to run post-SQL statements specified for the target.

Although you change the metadata of source fields using the

Edit Metadata

option in the

Fields

tab, the mapping task that is based on a mapping in SQL ELT mode ignores metadata changes and recreates the table with its original metadata when all the following scenarios are true:

The task is enabled with the dynamic schema handling options.
The task reads from the Amazon S3 or Microsoft Azure Data Lake Storage Gen2 source.
The task writes to an existing Snowflake target.

When you run a mapping in advanced mode to write data to an Apache Iceberg target table that is enabled with the

Truncate Target Table

option in the Target transformation, the mapping fails.