Spice.ai OSS Quickstart Tutorials

Quickstarts for Spice OSS (github.com/spiceai/spiceai).

Quickstarts are designed to quickly try Spice OSS on your laptop with existing infrastructure in just 1-5 mins each.

For complete end-to-end projects that use Spice OSS, see Spice OSS Samples.

Core scenarios

• Federated SQL Query - Query data from S3, PostgreSQL, and Dremio in a single query.

Data Acceleration - Materializing & accelerating data locally with Data Accelerators

• DuckDB Data Accelerator
• PostgreSQL Data Accelerator
• SQLite Data Accelerator

Consuming and visualizing data with clients

• Apache Superset

Connecting to Data Sources with Data Connectors

• AWS RDS Aurora (MySQL Compatible) Data Connector
• AWS RDS PostgreSQL Data Connector
• Clickhouse Data Connector
• Databricks Delta Lake Data Connector
• Dremio Data Connector
• DuckDB Data Connector - Use a DuckDB database with sample TPCH data.
• GitHub Data Connector
• GraphQL Data Connector
• MySQL Data Connector
• S3 Data Connector
• SharePoint/OneDrive for Business Data Connector
• Snowflake Data Connector
• Spice.ai Cloud Platform Data Connector
• Supabase Data Connector Data Connector

Connecting to Data Sources with Catalog Connectors

• Spice.ai Cloud Platform Catalog Connector
• Databricks Unity Catalog Connector
• Unity Catalog Connector

Deployment and Installation

• Deploying to Kubernetes

Performance

• TPC-H Benchmarking
• Results Caching
• Indexes on Accelerated Data

Data Management

• Data Retention Policy
• Refresh Data Window
• Advanced Data Refresh

Security

• Securing data in transit via TLS