When you select Enable window properties in the Expression transformation and pass arguments for non-window functions in SQL ELT mode, the expression fails to validate the arguments of non-window functions. (Aug 2024)

When you pass NULL values in functions in mappings in SQL ELT mode, the mapping fails with the following error:

When you pass an argument with the Number data type or configure an output field with the Number data type in an SQL transformation to call overloaded stored procedures in Snowflake, the mapping fails with the following warning:

When you run a mapping task that reads from Snowflake, the Secure Agent does not delete the temporary files and folders even after you terminate the execution process for the task. (May 2024)

A mapping in advanced mode enabled for SQL ELT optimization that updates or upserts data to the target writes NULL values for the fields that are not mapped in the field mapping. (April 2024)

When you configure an Expression transformation in a mapping in SQL ELT mode and the precision of incoming fields exceeds the precision of target fields, the data preview fails with the following incorrect error:

When you configure a transformation to process binary data type in a mapping in SQL ELT mode, the data preview fails. (April 2024)

When you run a mapping configured with the Lookup transformation where you set the default column value as 0 or 1 for a Boolean lookup field, the mapping generates the value 0 or 1 for the lookup field instead of false or true. (April 2024)

When you run a mapping task that is based on a mapping in SQL ELT mode with multiple target objects, the job details page displays target names as Target1, Target2..., Target(n) instead of the actual target object names in the

Individual Source/Target Results

section. (April 2024)