Spice.ai OSS Quickstart Tutorials

Quickstarts for github.com/spiceai/spiceai. Designed to take 1-5 mins each!

Core scenarios

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

Materializing & accelerating data locally with Data Accelerators

• PostgreSQL Data Accelerator

Consuming and visualizing data with clients

• Apache Superset

Connecting to Data Sources with Data Connectors

• S3 Data Connector
• Databricks Delta Lake Data Connector
• Supabase Data Connector Data Connector
• AWS RDS PostgreSQL Data Connector
• AWS RDS Aurora (MySQL Compatible) Data Connector
• Dremio Data Connector
• Spice.ai Cloud Platform Data Connector
• MySQL Data Connector
• DuckDB Data Connector - Use a DuckDB database with sample TPCH data.
• Clickhouse Data Connector
• Snowflake Data Connector
• GraphQL 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