Caching

Spice.ai provides two complementary caching layers. Dataset acceleration materializes upstream data into a fast local engine. The SQL results cache stores query output in memory so that identical queries return instantly without re-executing against the accelerator. Both layers are configurable independently and work together to minimize latency and upstream load.

📄️ Write-Through Cache

Use Spice.ai as a write-through cache that writes data to both a local accelerator and the upstream data source.

📄️ Read-Through Cache

Use Spice.ai as a read-through cache with the SQL results cache for federated data sources and HTTP APIs.

📄️ SQL/Database Cache

Use Spice.ai to cache SQL database tables and query results locally for low-latency access and reduced load on upstream databases.

📄️ S3 Cache

Use Spice.ai to cache S3 and object store data locally for fast, repeatable SQL queries without re-reading from remote storage.

📄️ HTTP Cache

Use Spice.ai to cache HTTP API responses locally, reducing API call frequency and providing fast, SQL-queryable access to external API data.