One post tagged with "tableau"

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
  • Docs: spiceai.org/docs/clients/tableau
  • Open Source Repository: github.com/spiceai/tableau-connector

• 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

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\""
}

For details, see the SQL Query API and NSQL API documentation.

Contributors​

• @ewgenius
• @peasee
• @lukekim
• @phillipleblanc
• @Sevenannn
• @sgrebnov
• @kczimm

Breaking Changes​

No breaking changes in this release.

Cookbook Updates​

No major cookbook additions.

The Spice Cookbook 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

Homebrew:

brew upgrade spiceai/spiceai/spice

Docker:

Pull the spiceai/spiceai:1.1.2 image:

docker pull spiceai/spiceai:1.1.2

For available tags, see DockerHub.

Helm:

helm repo update
helm upgrade spiceai spiceai/spiceai

What's Changed​

Dependencies​

• delta_kernel: updated to v0.9.0.

Changelog​

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

Full Changelog: v1.1.1...v1.1.2