Enhancement: support Clickhouse as an accelerator engine

[tekumara]

Goal-State/What/Result

Clickhouse as an accelerator engine.

Why/Purpose

We’ve found Clickhouse to be more performant than duckdb for our workload.

By When

A target date for done-done completion of the entire enhancement.

Issue/Spec written and reviewed: Done-Done:

Done-Done

• [ ] First Principles Driven
• [ ] The Algorithm
• [ ] PM/Design Review
• [ ] UX Review
• [ ] Threat Model / Security Review
• [ ] Tests
• [ ] Documentation
• [ ] Samples/Quickstarts/Tutorials
• [ ] Release Notes

The Algorithm

• [ ] Every requirement questioned?
• [ ] Delete (Scope) any part you can.
• [ ] Simplify.
• [ ] Break down into smaller iterations/milestones.
• [ ] Opportunities for automation.

Spec

Basic specification of the enhancement.

How/MAP

A clear and concise plan of how this should be implemented.

Implementation (issues)

QA

[phillipleblanc]

@tekumara - We already support Clickhouse as a connector: https://docs.spiceai.org/components/data-connectors/clickhouse - Do you mean you want to be able to use Clickhouse as an accelerator engine?

[tekumara]

Yes as an accelerator engine, to cache data in s3 🙏

[lukekim]

@tekumara thanks for the suggestion!

[lukekim]

@tekumara also left you a DM on X.