v.19.7New Features

For Tsvwithnames/csvwithnames Input File Formats, Column Order Can Now Be Determined from File Header

For TSVWithNames/CSVWithNames input file formats, column order can now be determined from file header. This is controlled by input_format_with_names_use_header parameter. #5081 (Alexander)
For TSVWithNames and CSVWithNames input file formats, the column order can now be automatically determined from the file header using a new parameter.

Why it matters

This feature addresses the limitation where users had to rely on predefined column order when importing data in TSVWithNames or CSVWithNames formats. By enabling automatic detection of column order from the file header, it simplifies data ingestion and reduces errors caused by mismatched column orders.

How to use it

Set the input_format_with_names_use_header parameter to true when importing data in TSVWithNames or CSVWithNames format to enable using the file header for column order determination.