Forum Discussion

amaaiia's avatar
amaaiia
Icon for Skilled Sharer rankSkilled Sharer
2 years ago
Solved

Data pipeline COPY activity vs Dataflow Gen2 text ingest with lowercase

I've ingested one table with DFg2 and the same table with COPY activity. I've realised that one column is in uppercase when DFg2 is used, and in lowercase when COPY is used. In source (SQL Server on ...
data engineering
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi amaaiia 
    Apologies for the issue you have been facing. The internal team has confirmed that this is a bug. I have created a bug for the same. The team is working on this to fix the issue. I will keep you posted regarding the updates.
    Appreciate your patience.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi amaaiia 
Thanks for using Fabric Community.
I tried to repro the above scenario, but did not face any issue as mentioned above. Are you facing this issue with all the tables and columns?
Please try again and let me know if the issue persists.
Thanks

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi amaaiia 
    We haven’t heard from you on the last response and was just checking back to see if your query got resolved. Otherwise, will respond back with the more details and we will try to help.
    Thanks

    • amaaiia's avatar
      amaaiia
      Icon for Skilled Sharer rankSkilled Sharer
      2 years ago

      No. I've checked the query executed at source. If I run this query directly at source I get the results in uppercase. However, when running from COPY activity, I get it in lowercase.

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi amaaiia 
        Apologies for the issue you have been facing. The internal team has confirmed that this is a bug. I have created a bug for the same. The team is working on this to fix the issue. I will keep you posted regarding the updates.
        Appreciate your patience.