Forum Discussion

Mattiar's avatar
Mattiar
Icon for Resolver I rankResolver I
1 year ago
Solved

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, Pape...
Pipeline
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

  • Mattiar's avatar
    Mattiar
    1 year ago

    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.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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.