1. Docs
  2. Resources
  3. Data Source
  4. How the numbers work

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.

4 min read Updated CustomersAdmins

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 · ConnectionsShown in: the tab row
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 · EncryptedShown in: Variables, above the table
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:

KeyKindValueCounted in
apiBasePlainhttps://dev…Environment-specific
apiBase_TESTPlainhttps://test…Environment-specific
loginEmailPlainqa@test.example.com—
adminPasswordEncryptedsetEncrypted
couponCodePlainemptyNo value
newestOrderDBfrom 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#

KindShown in: Variables › Kind and Default value columns
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#

ActionsShown in: Variables › Actions column (tooltip “Connected actions”)
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.

Used by#

Used byShown in: Datasets and Databases lists
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 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; see Delete a database connection.

Dataset size and columns#

Size · ColumnsShown in: Datasets list
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 looping with {{excel:users}}_# runs 20 times.

Database column#

DatabaseShown in: Connections › Databases
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.

Didn’t find your answer?Write to support with your project name and what you see on screen.

info@smartestqa.ai