HVR 5 Integrate Fails with the Error: F_JD0250: Unexpected datatype 2004 on Snowflake Targets

Issue

Following the recent Snowflake 2023_08 bundle update, Integrate fails with the following error:

F_JD0250: Unexpected datatype '2004' [XXXXX] encountered for column '12' [XXXXX] of table [COLUMNS] while describing snowflake select.

Environment

• HVR 5
• Target: Snowflake

Resolution

To resolve this issue, check if the 2023_08 Snowflake bundle is enabled on your account using the following command:

• SELECT SYSTEM$BEHAVIOR_CHANGE_BUNDLE_STATUS( '2023_08' );

If the 2023_08 bundle is enabled, disable the bundle using the following command:

• SELECT SYSTEM$DISABLE_BEHAVIOR_CHANGE_BUNDLE( '2023_08' );

We aim to release an HVR version upgrade soon to solve this issue without disabling the bundle. When you upgrade to the fixed version, you can re-enable the bundle using the following command:

• SELECT SYSTEM$ENABLE_BEHAVIOR_CHANGE_BUNDLE( '2023_08' );

Cause

The DESCRIBE_TABLE column introduced in Snowflake's 2023_08 bundle update causes this issue.