Skip to content

Latest commit

 

History

History
32 lines (18 loc) · 1.64 KB

spice-firecache.md

File metadata and controls

32 lines (18 loc) · 1.64 KB
description icon
Federated SQL Query documentation
arrow-progress

Federated SQL Query

Spice supports federated queries, enabling you to join and combine data from multiple sources, including databases (PostgreSQL, MySQL), data warehouses (Databricks, Snowflake, BigQuery), and data lakes (S3, MinIO). For a full list of supported sources, see Data Connectors.

SQL Query

Playground SQL Explorer

The Playground SQL Explorer is the fastest way to get started with federated queries, debugging queries, and iterating quickly. The SQL Query Editor be accessed by clicking on the SQL Explorer tab after selecting Playground in the app navigation bar.

The Playground SQL Query Editor.

See sql-query-editor.md for further documentation on using the SQL Query Editor.

Apache Arrow Flight API

For production applications, leveraging the high-performance Apache Arrow Flight endpoint is recommended. The Spice SDKs always query using Arrow Flight.

See apache-arrow-flight-api.md for further documentation on using Apache Arrow Flight APIs.

HTTP API

SQL Query is also accessible via a standard HTTP API.

See http-api.md for further documentation on using the HTTP SQL API.