# SQL console

The SQL console is the embedded SQL interface available within Foundry applications, providing contextual SQL access to the resource you are currently viewing. The SQL console is targeted for quick queries in the context of a specific resource (such as a dataset or object type). For a dedicated, full-screen SQL application, see [SQL Studio](../sql-studio/index.md).

## Accessing SQL console

You can access the SQL console in the bottom panel of supported applications:

| Application | Resources queryable |
|---|---|
| [Dataset Preview](../../dataset-preview/overview/index.md) | Tabular data |
| [Data Lineage](../../data-lineage/overview/index.md) | Tabular data |
| [Ontology Manager](../../ontology-manager/overview/index.md) | Ontology object types and backing tabular data |

The starter query is prepopulated based on the resource you are currently viewing.

![SQL console docked in the bottom panel of Dataset Preview, with a starter query prepopulated for the open dataset.](../../../assets/51f5797471147fc16658fc2a76da072d7938f647e3ba851c32a73de72c0e9058.webp)

## Using SQL console

The SQL console provides core SQL editing and execution functionality, including running queries, autocomplete for tables and columns, an inline results panel, and the ability to save queries as [SQL worksheets](../worksheets/index.md). The SQL console uses Foundry's [Spark SQL dialect](../sql-dialect/index.md).

For full details on SQL Studio features, including AI-assisted query generation and result visualization, see the [SQL Studio documentation](../sql-studio/index.md).

### Modes

In [Ontology Manager](../../ontology-manager/overview/index.md), the SQL console supports two modes:

* **Data mode** for querying tabular data using [Furnace](../furnace/index.md).
* **Object mode** for querying ontology object types using [Ontology SQL](../ontology-sql/index.md).

When viewing an object type in Ontology Manager, you can select between modes from the mode dropdown in the SQL console toolbar. The object type's backing dataset is suggested as the default resource in data mode.

![Object mode and data mode in SQL console.](../../../assets/d1f87620beec38f97d1e7b918245f52f01099bf348fba5ef76653addb02d1f7b.webp)

In other applications, only data mode is available.

### Expanding to SQL Studio

To open the current query in a dedicated, full-screen application, select the expand option in the SQL console toolbar. This launches [SQL Studio](../sql-studio/index.md), which provides a full SQL application with a resource browser, version history, AI-assisted query generation, and additional capabilities not available in the embedded console.

:::callout{theme="neutral"}
A standalone full-screen view of the SQL console is temporarily available in environments where SQL Studio is not yet enabled. This standalone view will be replaced by the SQL Studio application.
:::

## Roles and permissions

Access to the SQL console is governed by the same SQL and download control roles that apply across Foundry. For details on the available roles and how they interact with SQL access, see [SQL permissions](../sql-permissions/index.md).