Forum Discussion
BUG Copy Activity Fabric UPPERCASE
Hello, everyone,
I wanted to report a bug found in the copy data of a pipeline in Fabric. In my specific case, I am reading the query from a json where I have for example a SELECT Pippo, Pluto, Paperino FROM disney.user
The output that returns me error obviously being case sensitive, is that all in uppercase. Basically it's like the query has become: SELECT PIPPO, PLUTO, PAPERINO FROM DISNEY.USER.
Obviously this gives me an error telling me that the column PIPPO does not exist.
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.
9 Replies
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 tested your problem and found no errors.
Can you provide some configuration screenshots and error messages? This helps us solve the problem.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.Hi Mattiar
Thank you for your feedback and glad to hear that you have resolved the issue.
If you have any questions, please continue to post in this forum.
Regards,
Nono Chen
