Qlik Replicate is missing carriage returns in Snowflake
Resolution
To keep the Carriage Return (CR), please add the following internal parameter on your Snowflake endpoint:
replaceChars
The default value is 0x0D,0x which means that CR (0x0D) is replaced by 0x(nothing)
To keep all CR, delete the default value. Then Save.
Cause
This is by design in Replicate because Snowflake targets are loaded with a CSV file where rows are delimited by carriage returns and embedded carriage returns can cause loading issues.
Environment
Qlik Replicate
Snowflake Endpoint
