Disclaimer: DuckDB Labs employee here. What does your 'serious analytics' entail? Using the full text search extension's macros (stemming, using match_bm25, ..

Disclaimer: DuckDB Labs employee here. What does your 'serious analytics' entail? Using the full text search extension's macros (stemming, using match_bm25, ...), running regexes, computing aggregates? Are you doing highly-selective lookups based on some columns that you'd like to index on? What would be your partitioning key? > There are so many ways to import -- which is the fastest? Loading from Parquet is great if you have Parquet file... but for use case, CSV import is the best bet. It is also very fast (>1GB/s on uncompressed CSVs) and works fine if the CSVs are reasonably well-formatted.