A data lake is rarely one file. Once you archive or publish data by period, you get a tree of files — and the trick is querying the whole thing as one table while only reading the parts a query needs. pg_duckdb does both: globs read many files as one, and Hive-style partitioning turns the folde...

Source: [Dev.to](https://dev.to/franckpachot/query-a-partitioned-data-lake-in-azure-blob-with-pgduckdb-31pc)

Sponsored