date: 2026-01-28 title: 'Spice v1.11.0 (Jan 28, 2026)' type: blog authors: [peasee] tags: [release, cayenne, acceleration, datafusion, iceberg, arrow, snapshots, scylladb, data-connector, distributed-query, caching, dynamodb, llm-tool]
Announcing the release of Spice v1.11.0-stable! ⚡
In Spice v1.11.0, Spice Cayenne reaches Beta status with acceleration snapshots, Key-based deletion vectors, and Amazon S3 Express One Zone support. DataFusion has been upgraded to v51 along with Arrow v57.2, and iceberg-rust v0.8.0. v1.11 adds several DynamoDB & DynamoDB Streams improvements such as JSON nesting, and adds significant improvements to Distributed Query with active-active schedulers and mTLS for enterprise-grade high-availability and secure cluster communication.
This release also adds new SMB, NFS, and ScyllaDB Data Connectors (Alpha), Prepared Statements with full SDK support (gospice, spice-rs, spice-dotnet, spice-java, spice.js, and spicepy), Google LLM Support for expanded AI inference capabilities, and significant improvements to caching, observability, and Hash Indexing for Arrow Acceleration.
Spice Cayenne has been promoted to Beta status with acceleration snapshots support and numerous performance and stability improvements.
Key Enhancements:
Improved Reliability:
FuturesUnordered reentrant drop crashescayenne_file_path locationFor more details, refer to the Cayenne Documentation.
Apache DataFusion has been upgraded to v51, bringing significant performance improvements, new SQL features, and enhanced observability.

Performance Improvements:
CASE Expression Evaluation: Expressions now short-circuit earlier, reuse partial results, and avoid unnecessary scattering, speeding up common ETL patternsNew SQL Features:
|> syntax for inline transformsDESCRIBE <query>: Returns the schema of any query without executing itparam => value syntax for scalar, aggregate, and window functionsSUM, AVG, and MIN/MAXExample pipe operator:
Improved Observability:
EXPLAIN ANALYZE Metrics: New metrics including output_bytes, selectivity for filters, reduction_factor for aggregates, and detailed timing breakdownsApache Arrow has been upgraded to v57.2, bringing major performance improvements and new capabilities.

Key Features:
GEOMETRY and GEOGRAPHY) with GeospatialStatisticsarrow-avro Crate: Efficient conversion between Apache Avro and Arrow RecordBatches with projection pushdown and vectorized execution supportHigh Availability Clusters: Spice now supports running multiple active schedulers in an active/active configuration for production deployments. This eliminates the scheduler as a single point of failure and enables graceful handling of node failures.
Example HA configuration:
mTLS Verification: Cluster communication between scheduler and executors now supports mutual TLS verification for enhanced security.
Credential Propagation: S3, ABFS, and GCS credentials are now automatically propagated to executors in cluster mode, enabling access to cloud storage across the distributed query cluster.
Improved Resilience:
--scheduler-address is providedFor more details, refer to the Distributed Query Documentation.
Spice has been upgraded to iceberg-rust v0.8.0, bringing improved Iceberg table support.
Key Features:
INSERT INTO Partitioned Tables: DataFusion integration now supports inserting data into partitioned Iceberg tablesupdate_table and register_table for SQL catalogupdate_table for S3 Tables catalog_file column support, and Date32 type supportAcceleration snapshots enable point-in-time recovery and data versioning for accelerated datasets. Snapshots capture the state of accelerated data at specific points, allowing for fast bootstrap recovery and rollback capabilities.
Key Features:
Example configuration:
Snapshots API and CLI: New API endpoints and CLI commands for managing snapshots programmatically.
CLI Commands:
HTTP API Endpoints:
| Method | Endpoint | Description |
|---|---|---|
| GET | /v1/datasets/{dataset}/acceleration/snapshots | List all snapshots for a dataset |
| GET | /v1/datasets/{dataset}/acceleration/snapshots/{id} | Get details of a specific snapshot |
| POST | /v1/datasets/{dataset}/acceleration/snapshots/current | Set the current snapshot for rollback |
For more details, refer to the Acceleration Snapshots Documentation.
The Caching Acceleration Mode introduced in v1.10.0 has received significant performance optimizations and reliability fixes in this release.
Performance Optimizations:
Reliability Fixes:
fetched_at in their projection would always result in cache misses, even when cached data was available.SELECT * queries without filters now return cached data directly without unnecessary filtering overhead.For more details, refer to the Caching Acceleration Mode Documentation.
Improved Query Performance and Security: Spice now supports prepared statements, enabling parameterized queries that improve both performance through query plan caching and security by preventing SQL injection attacks.
Key Features:
SDK Support:
| SDK | Support | Min Version | Method |
|---|---|---|---|
| gospice (Go) | ✅ Full | v8.0.0+ | SqlWithParams() with typed constructors (Int32Param, StringParam, TimestampParam, etc.) |
| spice-rs (Rust) | ✅ Full | v3.0.0+ | query_with_params() with RecordBatch parameters |
| spice-dotnet (.NET) | ✅ Full | v0.3.0+ | QueryWithParams() with typed parameter builders |
| spice-java (Java) | ✅ Full | v0.5.0+ | queryWithParams() with typed Param constructors (Param.int64(), Param.string(), etc.) |
| spice.js (JavaScript) |
Example (Go):
Example (Java):
For more details, refer to the Parameterized Queries Documentation.
Parameterized Query Support for Java: The Spice Java SDK v0.5.0 introduces parameterized queries using ADBC (Arrow Database Connectivity), providing a safer and more efficient way to execute queries with dynamic parameters.
Key Features:
double → Float64, String → Utf8)Param class with typed factory methods (Param.int64(), Param.string(), Param.decimal128(), etc.) for precise control over Arrow typesExample:
Maven:
For more details, refer to the Spice Java SDK Repository.
Expanded AI Provider Support: Spice now supports Google embedding and chat models via the Google AI provider, expanding the available LLM options for AI inference workloads alongside existing providers like OpenAI, Anthropic, and AWS Bedrock.
Key Features:
Example spicepod.yaml configuration:
For more details, refer to the Google LLM Documentation (see docs PR #1286).
Query data sources directly via URL in SQL without prior dataset registration. Supports S3, Azure Blob Storage, and HTTP/HTTPS URLs with automatic format detection and partition inference.
Supported Patterns:
SELECT * FROM 's3://bucket/data.parquet'SELECT * FROM 's3://bucket/data/'SELECT * FROM 's3://bucket/year=*/month=*/data.parquet'Key Features:
Example with hive partitioning:
Enable via spicepod.yml:
New asynchronous query APIs for long-running queries in cluster mode:
/v1/queries endpoint: Submit queries and retrieve results asynchronouslyUnified Telemetry Endpoint: OTel metrics ingestion has been consolidated to the Flight port (50051), simplifying deployment by removing the separate OTel port (50052). The push-based metrics exporter continues to support integration with OpenTelemetry collectors.
Note: This is a breaking change. Update your configurations if you were using the dedicated OTel port 50052. Internal cluster communication now uses port 50052 exclusively.
Enhanced Dashboards: Updated Grafana and Datadog example dashboards with:
Additional Histogram Buckets: Added more buckets to histogram metrics for better latency distribution visibility.
For more details, refer to the Monitoring Documentation.
Arrow-based accelerations now support hash indexing for faster point lookups on equality predicates. Hash indexes provide O(1) average-case lookup performance for columns with high cardinality.
Features:
Example configuration:
For more details, refer to the Hash Index Documentation.
Network-Attached Storage Connectors: New data connectors for SMB (Server Message Block) and NFS (Network File System) protocols enable direct federated queries against network-attached storage without requiring data movement to cloud object stores.
Key Features:
Example spicepod.yaml configuration:
For more details, refer to the Data Connectors Documentation.
A new data connector for ScyllaDB, the high-performance NoSQL database compatible with Apache Cassandra. Query ScyllaDB tables directly or accelerate them for faster analytics.
Example configuration:
For more details, refer to the ScyllaDB Data Connector Documentation.
TLS Connection Support: Fixed TLS connection issues when using grpc+tls:// scheme with Flight SQL endpoints. Added support for custom CA certificate files via the new flightsql_tls_ca_certificate_file parameter.
spice cloud CLI commands for cloud deployment managementsnapshots_create_interval for periodic acceleration snapshots independent of refresh cyclescaching refresh mode, enabling multi-layer acceleration where a persistent cache feeds a fast in-memory cacheon_refresh_sort_columns parameter for DuckDB enables data ordering after writesdynamodb_auth: iam_role parametertemp_directory parameter for shuffle filesDistributeFileScanOptimizer plansmax_message_size configuration for Flight serviceOTel ingestion has been moved to the Flight port (50051), removing the separate OTel port 50052. Port 50052 is now used exclusively for internal cluster communication. Update your configurations if you were using the dedicated OTel port.
Distributed query cluster mode now requires mTLS for secure communication between cluster nodes. This is a security enhancement to prevent unauthorized nodes from joining the cluster and accessing secrets.
Migration Steps:
spice cluster tls init and spice cluster tls add--node-mtls-* arguments--allow-insecure-connections to opt out of mTLSRenamed CLI Arguments:
| Old Name | New Name |
|---|---|
--cluster-mode | --role |
--cluster-ca-certificate-file | --node-mtls-ca-certificate-file |
--cluster-certificate-file | --node-mtls-certificate-file |
--cluster-key-file | --node-mtls-key-file |
--cluster-address | --node-bind-address |
--cluster-advertise-address | --node-advertise-address |
--cluster-scheduler-url | --scheduler-address |
Removed CLI Arguments:
--cluster-api-key: Replaced by mTLS authenticationNew ScyllaDB Data Connector Recipe: New recipe demonstrating how to use the ScyllaDB Data Connector. See ScyllaDB Data Connector Recipe for details.
New SMB Data Connector Recipe: New recipe demonstrating how to use the SMB Data Connector. See SMB Data Connector Recipe for details.
The Spice Cookbook includes 86 recipes to help you get started with Spice quickly and easily.
To upgrade to v1.11.0, use one of the following methods:
CLI:
Homebrew:
Docker:
Pull the spiceai/spiceai:1.11.0 image:
For available tags, see DockerHub.
Helm:
AWS Marketplace:
Spice is available in the AWS Marketplace.
chunking crate. by @Jeadie in #8431| ✅ Full |
| v3.1.0+ |
query() with parameterized query support |
| spicepy (Python) | ✅ Full | v3.1.0+ | query() with parameterized query support |
captured_plan outputs to be captured even if they would be filtered out otherwise by @phillipleblanc in #8501clippy::too_many_lines lint by @phillipleblanc in #8549spice cluster tls commands by @phillipleblanc in #8550spice cluster tls add certificates by @phillipleblanc in #8554DistributeFileScanOptimizer plans by @mach-kernel in #8581UnionProjectionPushdownOptimizer - Schema change during transform_down breaks parent nodes by @phillipleblanc in #8831data_components arrow::indexed::test_primary_key_value_matches_batch by @Jeadie in #8962on_refresh_sort_columns for post-write data ordering (initial version) by @sgrebnov in #8964time_interval and fix snapshots_creation_policy: on_change by @sgrebnov in #9026spice query command for async queries REPL by @phillipleblanc in #9057DistributeFileScanOptimizer and UnionProjectionPushdownOptimizer & set target_partitions dynamically based on cluster capacity by @phillipleblanc in #9100