Qlik Replicate: Databricks Delta Wstring data type truncation

[Alan_Wang]

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

Qlik Replicate 
Databricks Delta Target Driver version 7.x and below

Internal Investigation ID(s) 

CC-8667