Analyze a Parquet file with DuckDB and SQL
Go from a local file to a useful analytical query without standing up a database server.
The knowledge library.
Practical answers. Deeper understanding. Find your next database breakthrough.
OLTP and OLAP: two workloads, different priorities
Understand why checking out a shopping basket and analyzing a year of sales ask very different things of a database.
BigQuery: scan less data before adding more compute
Use explicit columns and partition filters to reduce unnecessary work, then validate the bytes your query will process.