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

v-nmadadi-msft's avatar
v-nmadadi-msft
Community Support
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