Snowflake Data Cloud Connector

CCORE-4370

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

CCON-97090

When you test a Snowflake Data Cloud connection, the connection might fail intermittently with the following error:

CCON-95744

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)

CCON-62833

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)

CLDDI-31168

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

CCORE-6509

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. (July 2024)

CCORE-6353

When the Snowflake target field contains the Datetime data type, and you pass arguments that contain the ANY data type for the NVL or NVL2 function in a mapping in SQL ELT mode and the first argument contains the NULL value, the mapping returns incorrect output. (July 2024)

CCORE-6352

When the Snowflake target field contains the Binary data type, and you pass arguments that contain the ANY data type for the NVL or NVL2 function in a mapping in SQL ELT mode and the first argument contains the NULL value, the expression validates the argument even though the mapping fails at run time. (July 2024)

CCORE-6179

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)

CBDM-34468

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 error:

CBDM-33564

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)