Reading CSV into a duckdb table will give you that, along with a table for the errors and reason for error: https://duckdb.org/docs/stable/data/csv/reading_faul

Reading CSV into a duckdb table will give you that, along with a table for the errors and reason for error: https://duckdb.org/docs/stable/data/csv/reading_faulty_csv_files.html https://duckdb.org/docs/stable/data/csv/reading_faulty_csv_f... Could definitely be done as a small little bash script