Forum Discussion
BUG Copy Activity Fabric UPPERCASE
Hi Mattiar
Based on the information you provided, I surmise that this is related to the case sensitivity of SQL queries in Fabric pipes.
You can try using double quotes around column names in SQL queries. This should preserve the case sensitivity.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I had tried square brackets and it did not work. I have now tried double quotes (with the escape character since I read the query from a json) and the / prefixed by escape and everything finally worked.
Great.
Of course.
I show you the result of the variable set before and the one that reads the copy data instead:
this step is correct and the source of copy data is correct too:
and now the wrong result:
If I write select * from, it obviously works.
I think you issue/bug is with the SAP Hana Connector converting the query to uppercase, can you test this by using a static query, with the lowercase column names and seeing if the connector modifies that.
Yes it is most likely related to that, but that does not detract from the fact that it is an infrastructure bug. I wanted to expose the problem so that someone who can edit that, knows the bug and fixes it.
Hi Mattiar,
I am simply trying to highlight for Anonymous, that the behaviour is likely related to the source type, as they are trying to replicate your issue using a lakehouse source.
