Forum Discussion

jochenj's avatar
jochenj
Icon for Advocate III rankAdvocate III
2 years ago
Solved

Data Pipeline Error (Parquet File > FabricDWH) TypeConversion is not supported by the external cmd

Situation: i struggle to load a parquet file to DWH. The Parquet File has a column "Info" which is nvarchar(max) FabricDWH does only support a max of varchar(8000) I would be fine if the column-d...
Need Help
pipelines
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi  jochenj,
    Thanks for using the Fabric community,

     

    Data truncate is not a supported feature in DWH. Thus Data pipeline cannot support truncate for Parquet -> DWH. However Data pipeline can support skip incompatibly rows and output incompatibly rows by 'Settings'->'Fault Tolerance'.

     

    Hope this is helpful. Incase of any further queries do let us know.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi  jochenj,
Thanks for using the Fabric community,

 

Data truncate is not a supported feature in DWH. Thus Data pipeline cannot support truncate for Parquet -> DWH. However Data pipeline can support skip incompatibly rows and output incompatibly rows by 'Settings'->'Fault Tolerance'.

 

Hope this is helpful. Incase of any further queries do let us know.

  • jochenj's avatar
    jochenj
    Icon for Advocate III rankAdvocate III
    2 years ago

    thanks for the insights. Can you confirm that even "renaming" of columns with a dynamic TabularTranslator expression should work? Or is this also not implemented yet?

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi jochenj ,

      Dynamic TabularTranslator should be supported.

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hello jochenj ,

        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.