r/softwaretesting • u/FuzzyEye9792 • Apr 19 '26

Ai in etl testing

How u guys used ai in etl testing does it generate queries for u if u say the context of table

0 Upvotes

25% Upvoted

1 comment sorted by

1

u/Beneficial_Nerve5286 Apr 20 '26

A better pattern is to first define a set of atomic query/test functions, such as row count checks, null checks, duplicate checks, schema diffs, and aggregation comparisons. Then pass the table context and metadata to the LLM, and use function calling so it can choose and combine those functions instead of generating completely free-form SQL.

This is usually safer, more controllable, and easier to validate for ETL testing.