ODBC as source having special character in column name

Support Queries
1

When using the ODBC connector, the table column name contains special characters such as “$”. At runtime, the flow goes into error.

2

Here you have to make some changes when using ODBC as a source containing special characters.

Step 1: Go to the Specify Driver Attributes option.
Step 2: Checked Override default driver attributes.
Step 3: Go to the Table Name Treatment Field and select “Doublequote” from the dropdown option.

ODBC
ODBC1920×1234 134 KB

You are then good to go.
Thanks