DuckDB is our OLAP Database solution for analytical workloads that need highly flexible read patterns. It is to be considered strongly when there are no obvious write-time aggregation opportunities.

https://duckdb.org/

Currently provided by Motherduck. We have a 1-year trial contract ending on June 2026.

• Credits for storage and compute are provided by Motherduck.
• We will negotiate the next contract based on actual usage.
• pb-etl uses DuckDB for OLAP.

👍 Best practices

• Use DuckDB for OLAP when the data size is within a few GBs per tenant.
• You can use multiple DuckDB instances (one per tenant or group of tenants) for horizontal scaling.