Forum Discussion
Dataflow Gen2 Copy data csv to snowflake
I have a dataframe loading data into CSV ( few columns contain JSON structure data), Now trying to load the CSV to Snowflake tables using Copy data activity in Fabric dataflow activity. Getting ...
Hi shivaazure ,
The error message says that bad data was found when parsing line 82 of the CSV file.
I have some suggestions:
1. Open the CSV file and check the data format of line 82 to make sure that line 82 contains all expected columns and there are no extra delimiters or special characters.
2. Set the BadDataFound option in the Advance editor of Dataflow Gen2. The code is as follows:
let
Source = Csv.Document(File.Contents("path/to/your/file.csv"), [Delimiter=",", Columns=140, Encoding=65001, QuoteStyle=QuoteStyle.Csv, BadDataFound = null]),
PromotedHeaders = Table.PromoteHeaders(Source, [PromoteAllScalars=true])
in
PromotedHeaders
If you have any other questions please feel free to contact me.
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!