date: 2025-05-26 title: 'Spice v1.3.1 (May 26, 2025)' type: blog authors: [lukekim] tags: [release, sql, databricks, parameterized queries]

Announcing the release of Spice v1.3.1! 🛡️

Spice v1.3.1 includes improvements to Databricks SQL Warehouse support and parameterized query handling, along with several bugfixes.

What's New in v1.3.1

• Databricks SQL Warehouse Added support for the STRUCT type, enabled join pushdown for queries within the same SQL Warehouse and added projection to logical plans to force federation with correct SQL dialect.

• SQL Improvements: Fixed an issue where ILike was incorrectly optimized to string equality in DataFusion/Arrow and aliased the random() function to rand() for better compatibility.

• Parameterized Queries: Fixed parameter schema ordering for queries with more than 10 parameters and resolved placeholder inference issues in CASE expressions.

Contributors

• @phillipleblanc (opens in a new tab)
• @lukekim (opens in a new tab)
• @kczimm (opens in a new tab)
• @sgrebnov (opens in a new tab)

Breaking Changes

No breaking changes.

Cookbook Updates

No new cookbook recipes.

The Spice Cookbook (opens in a new tab) now includes 67 recipes to help you get started with Spice quickly and easily.

Upgrading

To upgrade to v1.3.1, use one of the following methods:

CLI:

spice upgrade

spice upgrade

Homebrew:

brew upgrade spiceai/spiceai/spice

brew upgrade spiceai/spiceai/spice

Docker:

Pull the spiceai/spiceai:1.3.1 image:

docker pull spiceai/spiceai:1.3.1

docker pull spiceai/spiceai:1.3.1

For available tags, see DockerHub (opens in a new tab).

Helm:

helm repo update
helm upgrade spiceai spiceai/spiceai

helm repo update
helm upgrade spiceai spiceai/spiceai

What's Changed

Dependencies

No major dependency changes.

Changelog

• Bump Helm chart to 1.3.0 by @phillipleblanc (opens in a new tab) in #5925 (opens in a new tab)
• Fix Databricks SQL Warehouse benchmark test by @phillipleblanc (opens in a new tab), @lukekim (opens in a new tab), @kczimm (opens in a new tab), [@Spice Benchmark Snapshot Update Bot](https://github.com/Spice (opens in a new tab) Benchmark Snapshot Update Bot) in #5924 (opens in a new tab)
• Add support for STRUCT type in Databricks SQL Warehouse by @kczimm (opens in a new tab), @lukekim (opens in a new tab) in #5936 (opens in a new tab)
• Add projection to logical plan to force federation and correct dialect by @kczimm (opens in a new tab), @lukekim (opens in a new tab) in #5946 (opens in a new tab)
• Allow join push down for same SQL Warehouse by @kczimm (opens in a new tab), @lukekim (opens in a new tab) in #5947 (opens in a new tab)
• Avoid mistaken ILike to string equality optimization (DataFusion / Arrow) by @sgrebnov (opens in a new tab), @lukekim (opens in a new tab) in #5939 (opens in a new tab)
• Make spill_to_disk_and_rehydration test more robust by @sgrebnov (opens in a new tab), @lukekim (opens in a new tab) in #5929 (opens in a new tab)
• Alias the random() function to rand() by @phillipleblanc (opens in a new tab), @lukekim (opens in a new tab) in #5967 (opens in a new tab)
• Fix parameter schema ordering with > 10 parameters for parameterized queries by @phillipleblanc (opens in a new tab), @lukekim (opens in a new tab) in #5962 (opens in a new tab)
• Rev version to v1.3.1 by @lukekim (opens in a new tab) in #5975 (opens in a new tab)
• Fix placeholder inference in CASE expressions by @phillipleblanc (opens in a new tab), @lukekim (opens in a new tab) in #5968 (opens in a new tab)

Full Changelog: github.com/spiceai/spiceai/compare/v1.3.0...v1.3.1 (opens in a new tab)