Data Integration Connector Release Notes > Connector and connectivity issues > Snowflake Data Cloud Connector
  

Snowflake Data Cloud Connector

Fixed issues

The following table describes fixed issues:
Issue
Description
CCON-99102
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:
The Snowflake Connector failed to execute SQL Transformation because of the following error: java.lang.String cannot be cast to java.math.BigDecimal
(October 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 incorrect error:
Could not generate the preview results due to an internal error. If the problem persists, contact Informatica Global Customer Support.
(October 2024)

Known issues

The following table describes known issues:
Issue
Description
CLDDI-39533
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.
(April 2025)
CBDM-38002
When you run a mapping configured with SQL ELT mode that contains a Normalizer transformation connected to an Expression transformation, and the generated column ID field is used as the first operand in an expression within the transformation, the mapping fails.
Workaround: Update the expression by changing the first operand and run the mapping again.
For example, if the mapping with Generated column ID field + 100 scenario in an expression fails, update the expression to 100 + Generated column ID field.
(April 2025)