Forum Discussion

Rbakker888's avatar
Rbakker888
Helper II
1 year ago
Solved

Invalid column name, synapse pipeline

Operation on target ForEachCopyData failed: Activity failed because an inner activity failed; Inner activity name: Execute CopyData, Error: Operation on target CopyData failed: ErrorCode=ParquetInval...
data pipeline
  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    1 year ago

    Hi Rbakker888  ,
    Thanks for reaching out to the Microsoft fabric community forum.

    In addition to whitespaces, column names should not include special characters like
    [,;{}()\n\t=] as well as these are invalid.
    Please modify and check if you are able to bypass the error now.

    Source: Troubleshoot the Parquet format connector - Microsoft Fabric | Microsoft Learn

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly and consider giving a KUDOS. Feel free to reach out if you need further assistance.
    Thank you

Rbakker888's avatar
Rbakker888
Helper II
1 year ago

I believe I found the issue myself, after doing some research it turns out parquet cant have whitepaces in column names. Currently waiting on the dbowner to change the names, will mark as solution if it works after that.

 

Srisakthi's avatar
Srisakthi
Super User
1 year ago

Hi Rbakker888 ,

 

You are right. Fabric doesnt allow spaces in column names. You can create table in Fabric with proper naming and data type and then use that table in your pipeline instead of changing the source.

 

Regards,

Srisakthi