📖 Keywords

Keywords are special test conditions executed under the hood by X-AutoMate.
They act as assertions that evaluate whether the data returned by your SQL queries meets the expected criteria.

💡 What Are Keywords?

For example, if your test query is:

SELECT * FROM table WHERE id IS NULL

You might attach the keyword:

✅ Row Count Is 0

This keyword will fail the test if any rows are returned (i.e., if null values exist in the id column).

X-AutoMate supports a wide range of keywords to enable flexible, data-driven, and context-aware testing.

📋 List of Supported Keywords

Keyword	Description
Check If Exists In Database	Verifies if a specific row or value exists in the database.
Check If Not Exists In Database	Verifies that a specific row or value does not exist in the database.
Description	Adds a human-readable description or comment.
Query	Executes a SQL query and optionally stores the result.
Row Count Is 0	Asserts that a query result returns zero rows.
Row Count Is Equal To X	Passes if row count equals X.
Row Count Is Greater Than X	Passes if row count is greater than X.
Row Count Is Less Than X	Passes if row count is less than X.
Row Count Is At Least X	Passes if row count is greater than or equal to X.
Row Count Is At Most X	Passes if row count is less than or equal to X.
Data Quality Check	Runs a predefined data quality validation.
Data Quality Custom Check	Executes a user-defined DQ check via SQL.
Data Quality Check Whether Value Is Close	Checks if a numeric value is close to expected (within tolerance).
Result Is At Most X	Passes if query result is ≤ X.
Result Is At Least X	Passes if query result is ≥ X.
Result Is Less Than X	Passes if query result is < X.
Result Is Greater Than X	Passes if query result is > X.
Result Is Equal To X	Passes if query result is = X.
Result Is 0	Passes if query result is exactly 0.
Key Value In Variable Should Be Equal To X	Checks if a variable’s key equals X.
Key Value In Variable Should Be Greater Than X	Checks if a variable’s key > X.
Key Value In Variable Should Be Lesser Than X	Checks if a variable’s key < X.
Key Value In Variable Should Be At Most X	Checks if a variable’s key ≤ X.
Key Value In Variable Should Be At Least X	Checks if a variable’s key ≥ X.
Key Value In Variable Should Not Be X	Checks if a variable’s key ≠ X.
Key in Dictionaries Is Not Equal	Fails if keys in two dictionaries match.
Key in Dictionaries Is Equal	Passes if keys in two dictionaries match.
Query To Variable	Executes a query and stores its result in a variable.
Data Quality Simple Check	Runs a built-in DQ validation (e.g., null count, regex, range).

🧪 Where Are Keywords Used?

Keywords are used in all major test types in X-AutoMate:

• 🏗️ ETL Tests
• 🧼 Data Quality Checks (DQ)
• 🔁 Reconciliation Tests

Some keywords are specific to certain test types. For example:

• Data Quality Custom Check is only used in Custom DQ tests
• Several reconciliation keywords are auto-selected by X-AutoMate

🤖 X-AutoMate will automatically choose the most suitable keyword based on your query and configuration — no need to worry about hidden/internal ones.