HVR 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 6
• Target: Snowflake

Resolution

To resolve this issue, upgrade HVR to version 6.1.0/43 or higher on the HUB or Target where applicable. To download version 6.1.0/43 or higher, see our downloads page.

To upgrade only the Target or HUB, do the following:

1. Upgrade the Target or HUB to version 6.1.0/43 or higher
2. Start Integrate.

To upgrade both the Source and the Target or HUB, do the following:

1. Suspend Capture.
2. Upgrade the Target or HUB to version 6.1.0/43 or higher.
3. Start Integrate and let the messages drain.
4. Upgrade the Source to version 6.1.0/43 or higher.
5. Start Capture.

If you can't upgrade to version 6.1.0/43 or higher, check if the 2023_08 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' );

When you have successfully upgraded to version 6.1.0/43 or higher, 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.