---
title: "How the numbers work"
section: "Data Source"
description: "How every number on the SmartestQA Data Source page is calculated: tab counts, Keys / No value / Environment-specific / Encrypted cards, Actions, Used by, dataset size."
url: https://docs.smartestqa.ai/en/data-source-numbers.html
audience: [customer, admin]
updated: 2026-11-08
keywords: "data source count variables datasets connections keys no value environment-specific encrypted kind used by rows columns size actions"
---
# Data Source: How the numbers work

Every count and label on the Data Source page, how it is worked out, and an example you can check against your own project.

## In short

**On this page you can**

- Understand what the counts next to Variables , Datasets and Connections include.
- Read the four summary cards and use them as filters.
- Know why Used by can say Not used while tests use a dataset.
- Check a dataset’s rows and columns before a pipeline loops over it.

**How to use it**

1. Compare a tab count with the list under it.
2. Click a summary card to list exactly the keys it counts.
3. Hover Used by to see the keys behind the number.
4. Before deleting a connection or dataset, check usage in tests as well.

## Tab counts

**Variables · Datasets · Connections** — Shown in: the tab row

```text
Variables    = number of keys in all folders           (folders are not counted)
Datasets     = number of datasets
Connections  = number of DB connections + number of Kafka connections
```

**Example:** 14 keys in 3 folders, 2 datasets, 2 databases and 1 Kafka connection show Variables 14, Datasets 2, Connections 3. Environment variants are keys too: `apiBase` and `apiBase_TEST` count as 2.

## Summary cards

**Keys · No value · Environment-specific · Encrypted** — Shown in: Variables, above the table

```text
Keys                  = all keys                 hint "{n} folders" = all folders and sub folders, top level not counted
No value              = plain keys (not encrypted, not bound) whose value is empty      amber when ≥ 1
Environment-specific  = keys whose name ends with _DEV, _TEST or _PRP
                        + keys that have at least one such variant
Encrypted             = keys of kind Encrypted
The cards always count the whole project; search and filter do not change them.
"{n} keys" above the table = the keys shown after filter and search.
```

**Example:**

| Key | Kind | Value | Counted in |
| --- | --- | --- | --- |
| `apiBase` | Plain | `https://dev…` | Environment-specific |
| `apiBase_TEST` | Plain | `https://test…` | Environment-specific |
| `loginEmail` | Plain | `qa@test.example.com` | — |
| `adminPassword` | Encrypted | set | Encrypted |
| `couponCode` | Plain | *empty* | No value |
| `newestOrder` | DB | from SQL | — |

Cards: Keys 6, No value 1 (amber), Environment-specific 2, Encrypted 1. An encrypted key without a value is not in **No value**; its value cell says “no value”.

**Why it matters:** a key in **No value** gives a run an empty text. Fill it or delete it.

## Kind and Default value

**Kind** — Shown in: Variables › Kind and Default value columns

```text
Kind = DB        if the key is bound to a DB query
     = Dataset   else if it is linked to a dataset cell
     = Encrypted else if Encrypt is on
     = Plain     otherwise (no chip)

Default value column:
  Plain      → the value, or "No value" in amber
  Encrypted  → "•••••••• set", or "no value"
  DB         → "DB Connected"
  Dataset    → the cell reference, e.g. {{excel:users_email_2}}
```

**Example:** a key linked to cell `email` of row 2 of dataset `users` shows **Dataset** and `{{excel:users_email_2}}`. Bound keys are never encrypted, so DB and Dataset always win.

## Actions

**Actions** — Shown in: Variables › Actions column (tooltip “Connected actions”)

```text
Actions = number of actions in the key’s Connected Actions List
```

**Example:** `loginEmail` connected to `Type Email` on `login` and `Type Email` on `register` shows 2. It does not count test steps that use `{{ds:loginEmail}}`. See [Connected actions](https://docs.smartestqa.ai/en/data-source-variables.html#connected-actions).

## Used by

**Used by** — Shown in: Datasets and Databases lists

```text
Dataset    Used by = keys whose value is linked to a cell of this dataset
Database   Used by = keys whose value comes from a DB query on this connection
"{n} keys"  · hover shows their names · 0 → "Not used"
Not counted: steps that write {{excel:…}}, pipelines that loop over the dataset, DB steps.
Kafka connections have no Used by value.
```

**Example:** dataset `users` drives a [pipeline](https://docs.smartestqa.ai/en/schedule-settings.html#data-loop) loop and five steps write `{{excel:users}}_email`, but no key is linked to it. It shows **Not used**. Before deleting a dataset, search your tests and pipelines for its name. For a database, the delete dialog lists the test cases with [DB steps](https://docs.smartestqa.ai/en/automate-steps-database.html); see [Delete a database connection](https://docs.smartestqa.ai/en/data-source-connections.html#delete-db).

## Dataset size and columns

**Size · Columns** — Shown in: Datasets list

```text
rows     = number of stored rows (blank lines of an uploaded file are skipped)
columns  = number of column names in the first row, without the row number #
Size     = "{rows} rows × {columns} columns"
Columns  = the column names, comma-separated
```

**Example:** a CSV with a header line `Login Email,Password`, 20 data lines and 2 empty lines, uploaded with **Header** ticked, shows 20 rows × 2 columns and `loginEmail, password`. A [pipeline](https://docs.smartestqa.ai/en/schedule-settings.html#data-loop) looping with `{{excel:users}}_#` runs 20 times.

## Database column

**Database** — Shown in: Connections › Databases

```text
engine  = the word after "jdbc:"                  (postgresql, mysql, oracle …)
target  = the rest of the URL without user:password@ and without ?… or ;… options
```

**Example:** `jdbc:postgresql://db.test.example.com:5432/shop?sslmode=require` shows the chip **postgresql** and `db.test.example.com:5432/shop`. The **User** column shows the connection’s user name; the password is never shown.

## Updated

The **Updated** column shows the day, month and time of the key’s last save (for example `07/11 14:32`). **Created by** and **Updated by** in the key panel add the user and the full date.
