Working with a database schema and datasets
Written by
Updated at April 3, 2026
Note
This feature is in the Preview stage. To get access, contact tech support or your account manager.
Working with a database schema
The Database schema tab contains a hierarchical structure of all available fields in a database.
Viewing fields
To view fields:
Security Deck UI
- Open the Query data panel.
- Navigate to the Database schema tab.
- Expand the sections by clicking the arrows.
For each field the following is displayed:
- Name
- Data type
Searching by field
To find a field:
Security Deck UI
- Open the Database schema tab.
- Enter a name in the Search fields field.
- The results will be displayed automatically.
Inserting a field into a query
To insert a field into a query:
Security Deck UI
- Click the field in the database schema.
- Select Insert into query.
The field name will be added to the query editor at the cursor position.
Working with datasets
The Datasets tab contains a list of available datasets and lookup tables.
Viewing datasets
To view datasets:
Security Deck UI
- Open the data panel.
- Navigate to the Datasets tab.
- Select a dataset from the list.
For each dataset the following is displayed:
- Name.
- Description.
- List of fields with data types.
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:
Security Deck UI
- Open the Datasets tab.
- Go to Lookup table.
- Select a table from the list.
Inserting a dataset into a query
To insert a dataset into a query:
Security Deck UI
- Find the required dataset.
- Click the dataset.
- Select Insert into query.
The dataset name will be added to the query editor.