Mappings with SQL transformation calling Snowflake stored procedure may fail after Snowflake Bundle release

Mappings with SQL transformations that call Snowflake stored procedures are now working as expected following the fix applied by Informatica to the Snowflake connector on July 7, 2025. This update accommodates recent Snowflake changes related to stored procedure metadata.

Additionally, Snowflake has rolled back the recent change (BCR-1944) from the 2025_03 bundles, which affected commands retrieving metadata about functions and procedures. Snowflake communicated this behavior change directly to their customers.

For more information, please refer to the Snowflake change log:
https://docs.snowflake.com/en/release-notes/bcr-bundles/2025_03_bundle#label-behavior-change-bundle-2025-03-status

Informatica will deploy a patch to the Data Integration service which resolves an issue initializing a mapping with a SQL Transformation utilizing a Snowflake stored procedure. This is a zero downtime deployment which will not impact running jobs or services. the activity is planned from 3.30 AM PDT to 6.30 AM PDT.
Attention: A new Data Integration service will be initialized. Tasks affected by this issue will have a fresh metadata fetch, after deployment of the patch.

Informatica is working closely with Snowflake on the set of assets impacted by the bundle release. We will keep the status page updated on the progress.

Workaround:
1. Users can disable the 2025_03 bundle by running the following command to restore the previously working behavior -
SELECT SYSTEM$DISABLE_BEHAVIOR_CHANGE_BUNDLE('2025_03');

2. If there are any concerns with disabling the 2025_03 bundle, you can also reach out to Snowflake support. Snowflake can selectively disable the change bcr-1944 from the 2025_03 bundle which is causing this issue.

More details of this issue are available here: https://knowledge.informatica.com/s/article/Tasks-using-SQL-transformation-calling-Snowflake-Stored-Procedure-are-failing-in-Cloud-Data-Integration

Informatica is working closely with Snowflake on the set of assets impacted by the bundle release. We continue to track this for a solution and will keep the status page updated on the progress.

We have identified an issue after Snowflake bundle (2025_03) release where Mappings with SQL transformation calling Snowflake stored procedures may fail with error like: "java.lang.ArrayIndexOutOfBoundsException" or "Partition Driver level [Name of SQL Transformation]: CT failed in init()"

More details on the change are available here: https://docs.snowflake.com/en/release-notes/bcr-bundles/2025_03/bcr-1944

Mappings without Snowflake related SQL transformation are not impacted by this change.

Users can resolve this issue by disabling this bundle by running the following command on Snowflake:
SELECT SYSTEM$DISABLE_BEHAVIOR_CHANGE_BUNDLE('2025_03');{}

Informatica is working with Snowflake on a resolution for this issue.

More details of this issue are available here: https://knowledge.informatica.com/s/article/Tasks-using-SQL-transformation-calling-Snowflake-Stored-Procedure-are-failing-in-Cloud-Data-Integration?language=en_US