[Yandex Cloud documentation](../../../index.md) > [Yandex SIEM](../../index.md) > [Step-by-step guides](../index.md) > [Queries](index.md) > Working with a database schema and datasets

# Working with a database schema and datasets

{% note info %}

This feature is in the [Preview](../../../overview/concepts/launch-stages.md) stage. To get access, contact [tech support](https://center.yandex.cloud/support) or your account manager.

{% endnote %}

## Working with a database schema {#database-schema}

The **Database schema** tab contains a hierarchical structure of all available fields in a database.

### Viewing fields {#view-fields}

To view fields:

{% list tabs group=instructions %}

- Cloud Center UI {#cloud-center}

  1. Open the **Query data** panel. 
  1. Navigate to the **Database schema** tab.
  1. Expand the sections by clicking the arrows.

  For each field the following is displayed:
  * Name
  * Data type

{% endlist %}

### Searching by field {#search-fields}

To find a field:

{% list tabs group=instructions %}

- Cloud Center UI {#cloud-center}

  1. Open the **Database schema** tab.
  1. Enter a name in the **Search fields** field.
  1. The results will be displayed automatically.

{% endlist %}

### Inserting a field into a query {#insert-field}

To insert a field into a query:

{% list tabs group=instructions %}

- Cloud Center UI {#cloud-center}

  1. Click the field in the database schema.
  1. Select **Insert into query**.

  The field name will be added to the query editor at the cursor position.

{% endlist %}

## Working with datasets {#datasets}

The **Datasets** tab contains a list of available datasets and lookup tables.

### Viewing datasets {#view-datasets}

To view datasets:

{% list tabs group=instructions %}

- Cloud Center UI {#cloud-center}

  1. Open the data panel.
  1. Navigate to the **Datasets** tab.
  1. Select a dataset from the list.

  For each dataset the following is displayed:
  * Name.
  * Description.
  * List of fields with data types.

{% endlist %}

### Lookup tables {#lookup-tables}

**Lookup table** are lookup tables used to enrich data. They are displayed in a separate section on the datasets tab.

To view Lookup table:

{% list tabs group=instructions %}

- Cloud Center UI {#cloud-center}

  1. Open the **Datasets** tab.
  1. Navigate to **Lookup table**.
  1. Select a table from the list.

{% endlist %}

### Inserting a dataset into a query {#insert-dataset}

To insert a dataset into a query:

{% list tabs group=instructions %}

- Cloud Center UI {#cloud-center}

  1. Find the required dataset.
  1. Click the dataset.
  1. Select **Insert into query**.

  The dataset name will be added to the query editor.

{% endlist %}

#### Useful links {#see-also}

* [Investigations](../../concepts/investigations.md)
* [Queries](../../concepts/queries.md)
* [Managing queries](manage-queries.md)
* [Working with query templates](work-with-templates.md)