oso icon indicating copy to clipboard operation
oso copied to clipboard
verified publisher icon opensource-observer

Consider DuckDB / Motherduck for frontend OLAP database

Open ryscheng opened this issue 1 year ago • 1 comments

What is it?

Currently we use Clickhouse for both sqlmesh + frontend API.

Since we are moving to Trino for sqlmesh, we might want to consider duckdb for frontend. Hasura3 has support for it, so that shouldn't be an issue.

ryscheng avatar Oct 02 '24 21:10 ryscheng

We'd have to connect duckdb to our Iceberg tables somehow as a pre-requisite

ryscheng avatar Oct 02 '24 21:10 ryscheng

Filed issues #2347 and #2348 as followon work for this.

ryscheng avatar Oct 16 '24 21:10 ryscheng