spiceai/docs

date: 2025-04-15 title: 'Spice v1.1.2 (Apr 14, 2025)' type: blog authors: [phillipleblanc] tags: [release, delta, tableau, snowflake, sql, nsql]

Announcing the release of Spice v1.1.2! 🔗

Spice v1.1.2 improves Delta Lake Data Connector performance, introduces new Accept headers for the /v1/sql and /v1/nsql endpoints to include query metadata with results, and resolves an issue with the Snowflake Data Connector when handling wide tables (>600 columns).

The official Tableau Connector for Spice.ai v0.1 has been released, making it easy to connect to both self-hosted Spice.ai and Spice Cloud instances using Tableau.

What's New in v1.1.2

Tableau Connector for Spice.ai: Released the initial version (v0.1) of the official Tableau Taco Connector (fully open-source), enabling data visualization and analytics in Tableau with self-hosted Spice.ai and Spice Cloud deployments.
- Official Release: github.com/spicehq/tableau-connector/releases/tag/v0.1.0 (opens in a new tab)
- Docs: spiceai.org/docs/clients/tableau (opens in a new tab)
- Open Source Repository: github.com/spiceai/tableau-connector (opens in a new tab)

Query Spice.ai using Tableau

Delta Lake Data Connector: Upgraded delta_kernel to v0.9, and optimized scan operations, reducing query execution time by up to 20% on large datasets.
Snowflake Data Connector: Fixed a bug that caused failures when loading tables with more than 600 columns.
Query Metadata (SQL and NSQL): Added support for the application/vnd.spiceai.sql.v1+json Accept header on the /v1/sql endpoint, and the application/vnd.spiceai.nsql.v1+json Accept header on the /v1/nsql endpoint, enabling responses to include metadata such as the executed SQL query and schema alongside results.

Example:

curl -XPOST "http://localhost:8090/v1/nsql" \
  -H "Content-Type: application/json" \
  -H "Accept: application/vnd.spiceai.nsql.v1+json" \
  -d '{
    "query": "What’s the highest tip any passenger gave?"
  }' | jq

curl -XPOST "http://localhost:8090/v1/nsql" \
  -H "Content-Type: application/json" \
  -H "Accept: application/vnd.spiceai.nsql.v1+json" \
  -d '{
    "query": "What’s the highest tip any passenger gave?"
  }' | jq

Example response:

{
  "row_count": 1,
  "schema": {
    "fields": [
      {
        "name": "highest_tip",
        "data_type": "Float64",
        "nullable": true,
        "dict_id": 0,
        "dict_is_ordered": false,
        "metadata": {}
      }
    ],
    "metadata": {}
  },
  "data": [
    {
      "highest_tip": 428.0
    }
  ],
  "sql": "SELECT MAX(\"tip_amount\") AS \"highest_tip\"\nFROM \"spice\".\"public\".\"taxi_trips\""
}

{
  "row_count": 1,
  "schema": {
    "fields": [
      {
        "name": "highest_tip",
        "data_type": "Float64",
        "nullable": true,
        "dict_id": 0,
        "dict_is_ordered": false,
        "metadata": {}
      }
    ],
    "metadata": {}
  },
  "data": [
    {
      "highest_tip": 428.0
    }
  ],
  "sql": "SELECT MAX(\"tip_amount\") AS \"highest_tip\"\nFROM \"spice\".\"public\".\"taxi_trips\""
}

For details, see the SQL Query API (opens in a new tab) and NSQL API (opens in a new tab) documentation.

Contributors

Breaking Changes

No breaking changes in this release.

Cookbook Updates

No major cookbook additions.

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

Upgrading

To upgrade to v1.1.2, 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.1.2 image:

docker pull spiceai/spiceai:1.1.2

docker pull spiceai/spiceai:1.1.2

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

delta_kernel (opens in a new tab): updated to v0.9.0.

Changelog

Backport - Fix schema inference for Snowflake tables with large number of columns #5348 by @ewgenius (opens in a new tab) in #5350 (opens in a new tab)
Upgrade delta_kernel to 0.9 (#5343) by @phillipleblanc (opens in a new tab) in #5356 (opens in a new tab)
Add basic support for application/vnd.spiceai.sql.v1+json format (#5333) by @sgrebnov (opens in a new tab) in #5333 (opens in a new tab)
Convert DataFusion filters to Delta Kernel predicates by @phillipleblanc (opens in a new tab) in #5362 (opens in a new tab)
revert to previous pdf-extract; remove test for encrypted pdf support by @kczimm (opens in a new tab) in #5355 (opens in a new tab)
Turn off delta_kernel::log_segment logging and refactor log filtering by @phillipleblanc (opens in a new tab) in #5367 (opens in a new tab)
Extend application/vnd.spiceai.sql.v1+json with schema and row_count fields by @sgrebnov (opens in a new tab) in #5365 (opens in a new tab)
Make separate vnd.spiceai.sql.v1+json and vnd.spiceai.nsql.v1+json MIME types by @sgrebnov (opens in a new tab) in #5382 (opens in a new tab)

Full Changelog: v1.1.1...v1.1.2 (opens in a new tab)

spiceai/docs/README.md