Problem with Azure Data Factory copying data with a special character "$" in column name Oracle

Diego Elias 1 Reputation point
2022-07-04T16:30:24.333+00:00

Hi, I have been caught a few days with this issue, I would like some help, I have a copy data activity and I´m trying to make a copy from one table to another one in Oracle, like this:

217474-anotacion-2022-07-04-101804.png

On the sink side, the column has the name: GNSAF$, I tried some changes like put the letter "S" instead "$" and works fine, but on the result with the sink side I can´t make changes, I have to leave the character "$" in the name, but in Azure I received this error:
217408-anotacion-2022-07-04-101905.png

I would appreciate any advice.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,067 questions
{count} votes