My source fields have special characters and need to be enclosed with backticks.
Ex:
Source - ahj@#
Target - ` ahj@# `
How do I implement this in StreamSets - enclosing the column names?
Special characters handling with backticks/backquotes in StreamSets Data Collector
Viewed 163
1 Answers
I assume you're trying to write to MySQL. The correct way to do this is to enable Enclose Object Names in the JDBC tab and append ?sessionVariables=sql_mode=ANSI_QUOTES to the JDBC URL.
Related