Skip to main content

SQLite Data Accelerator

To use SQLite as Data Accelerator, specify sqlite as the engine for acceleration.

datasets:
- from: spiceai:path.to.my_dataset
name: my_dataset
acceleration:
engine: sqlite

Configuration

The connection to SQLite can be configured by providing the following params:

  • sqlite_file: The filename for the file to back the SQLite database. Only applies if mode is file.

Configuration params are provided in the acceleration section of a dataset. Other common acceleration fields can be configured for sqlite, see see datasets.

datasets:
- from: spiceai:path.to.my_dataset
name: my_dataset
acceleration:
engine: sqlite
params:
sqlite_file: /my/chosen/location/sqlite.db