Can you please check this similar type of issue to get an idea, here they are not using copy activity but error is similar which may help
Error: Copy Multiple Parquet Files from ADLS2 to Synapse
Hi, I have the scenario to copy multiple Parquet files from ADLS2 to Synapse ,Here I'm using wildcard path as *.parquet but im getting following error .so how to fix 'txn' data type issue in ADF copy activity.
Thanks & Regards
Prapul Kumar
3 answers
Sort by: Newest
-
-
Prapul Kumar Dongari 116 Reputation points
2022-05-02T06:11:13.733+00:00 Hi PratikSomaiya thanks for your valuable reply, synapse is not supporting 'txn' datatype is there any way we can ignore this error in Copy activity .
Thanks & Regards
PrapulKumar -
Pratik Somaiya 4,201 Reputation points
2022-05-02T06:03:56.137+00:00 Hello @Prapul Kumar Dongari
Can you check the data type of column txn, if might be an unsupported type
You can also compare the data type of this column between parquet file and synapse