Federated SQL Query
Federated SQL Query documentation
Last updated
Was this helpful?
Federated SQL Query documentation
Last updated
Was this helpful?
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 .
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.
See SQL Query for further documentation on using the SQL Query Editor.
See Apache Arrow Flight API for further documentation on using Apache Arrow Flight APIs.
SQL Query is also accessible via a standard HTTP API.
See HTTP API for further documentation on using the HTTP SQL API.
For production applications, leveraging the high-performance endpoint is recommended. The Spice SDKs always query using Arrow Flight.