Qlik Replicate: Databricks Delta Wstring data type truncation

Alan_Wang — Mon, 03 Apr 2023 09:26:47 GMT

Databricks Delta Driver version 7.x and below uses the string data type. String data types are limited to 255 characters that Wstring data types on Replicate can not bypass. Character limits above this will lead to the remaining data being truncated when it replicates to the target.

Starting with Databricks Delta Driver version to 8.x and above, Varchar data type will be used for strings. Varchar data type is no longer limited by this character size so no truncation will occur when Wstring data type is used with limits higher than 255 characters.

Resolution

Upgrade Databricks Delta Driver version to 8.x and above.

Environment

Databricks Delta Target Driver version 7.x and below

Internal Investigation ID(s)

CC-8667

article Qlik Replicate: Databricks Delta Wstring data type truncation in Official Support Articles

Qlik Replicate: Databricks Delta Wstring data type truncation

Resolution

Environment

Internal Investigation ID(s)