Querying Files with DuckDB

DuckDB 61,228 needs no load step: a file name in FROM is a table. This section queries the files of JSON, Columnar and Binary Formats (orders as Parquet 129 , CSV and JSON Lines, and the order events) where they lie.

Subsections

• Querying Parquet Directly
• Querying CSV and JSON
• Inference vs Explicit Types
• Globs and Hive Partitioning
• Exporting to Parquet
• Analyzing Raw Order Files