Blogs

DuckDB's CSV Sniffer: Automatic Detection of Types and Dialects

duckdb.org

DuckDB is primarily focused on performance, leveraging the capabilities of modern file formats. At the same time, we also pay attention to flexible, non-performance-driven formats like CSV files. To create a nice and pleasant experience when reading from CSV files, DuckDB implements a CSV sniffer that automatically detects CSV dialect options, column types, and even skips dirty data. The sniffing process allows user…

Visit Site

Blogs duckdb.org