Hello everyone, I am using pipelinewise/target-redshift, I have observed that '\' is missing in redshift (i.e. '\n' is capture as 'n', '\t' is captured as 't', '\r\n' is captured as 'rn' etc.) as it's the default escape character. Can someone please help?

I haven't used this target, but maybe you can escape that character? E.g. Convert \n into \\n before it arrives into the target?

I tried it but the hash(md5) values from source and destination aren't the same. For some reason the redshift hash value is matching with '\\t' but not to '\t'.