# Federated SQL Query

<figure><img src="/files/dj6QucLNRfZYuFSWTEAa" alt=""><figcaption></figcaption></figure>

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](https://docs.spiceai.org/components/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.

<figure><img src="/files/S82Az9LOLwYbin84ibNh" alt=""><figcaption><p>The Playground SQL Query Editor.</p></figcaption></figure>

See [https://github.com/spicehq/docs/blob/trunk/portal/playground/sql-query-editor.md](https://github.com/spicehq/docs/blob/trunk/portal/playground/sql-query-editor.md "mention") for further documentation on using the SQL Query Editor.

### Apache Arrow Flight API

For production applications, leveraging the high-performance [Apache Arrow Flight](https://github.com/spicehq/docs/blob/trunk/api/sql-query/apache-arrow-flight-api.md) endpoint is recommended. The Spice SDKs always query using Arrow Flight.

See [https://github.com/spicehq/docs/blob/trunk/api/sql-query/apache-arrow-flight-api.md](https://github.com/spicehq/docs/blob/trunk/api/sql-query/apache-arrow-flight-api.md "mention") for further documentation on using Apache Arrow Flight APIs.

### HTTP API

SQL Query is also accessible via a standard HTTP API.

See [https://github.com/spicehq/docs/blob/trunk/api/sql-query/http-api.md](https://github.com/spicehq/docs/blob/trunk/api/sql-query/http-api.md "mention") for further documentation on using the HTTP SQL API.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.spice.ai/features/federated-sql-query.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.