duckdb-for-local-analytics
Answers an analytical question with SQL over the Parquet or delimited tables that were already persisted, instead of another pass of row-by-row code over the source. Use when a question asks for revenue, counts or averages per group, a ranking of segments or channels, or one period compared with the period before it, when an analysis is being written as iteration over rows, when a file is larger than the memory available to load it, or when the same source is re-read and re-cleaned for every new question.
Pinned to revision 7ff6aeac96ad, so it is the text this page describes rather than whatever the author pushed since.
Files
Every link opens the file at its source, pinned to the revision this page describes.