Spice AI: Real Time Analytics Without ETL

The story

What the video said

Spice AI, an open source data engine, turns your slow database queries into fast answers. It connects to your data and serves it over SQL, so you don’t have to build a pipeline.

You want to run analytics on your live database without slowing it down, but copying all that data into a separate warehouse takes time and effort you don’t have.

Spice AI is an open source project that connects to over thirty data sources like Postgres and S3. You declare your datasets in one config file, then query them all through a single SQL endpoint.

Spice can keep a local copy of your data and refresh it on a schedule. It also reads change streams from your database, so your queries always see fresh data without hitting the source.

In the demo, you run SQL queries against a federated dataset and see real result tables with totals and averages. The query returns in milliseconds, right inside your editor.

This page was generated from the Ming Dao AI publication record.