I’m extracting data from mysql via

tap-mysql

(transferwise variant) and loading it into postgres via

target-postgres

(also transferwise). I’ve observed that varchar column values containing newlines get mangled, such that they’re turned into regular “\” and “n” characters. I’m guessing there’s an issue with escaping/quoting, but couldn’t find any way to control the behavior of either plugin. Has anyone experienced this before? Did you find a solution?

@burton_dewilde I don't recall what I did to solve this, unfortunately. I don't see any transforms in our pipeline or bug reports filed against the tap, though my comments in the earlier thread indicate I thought it was a tap issue. 🤔 There's a decent chance I changed the data to make the problem go away, for better or worse. Sorry!

no worries, thomas! appreciate the update.