Spice.ai OSS Reference Docs

🗃️ Spicepod specification

4 items

🗃️ SQL Reference

1 item

📄️ Data Types

Spice adheres to Apache Arrow data types. Data accelerators do not support all Arrow data types. The table below outlines the data type compatibility for each accelerator, and datatype used within the accelerator.

📄️ Query History

The Spice runtime stores information about completed queries in the spice.runtime.query_history table. Each query executed has a row in this table, and the data is retained for one day. Use a SELECT query to return information about each query as shown in this example:

📄️ Duration

Durations are represented as integers with a time unit suffix.

📄️ Timestamps

In Spice all timestamps are represented as an integer value denoting the number of seconds that have passed since the Unix epoch in UTC time. The Unix epoch is defined as 1970-01-01T0000Z.

📄️ File Formats

Spice currently supports CSV and Parquet data file-formats. Support for Iceberg and other file-formats are on the roadmap.