QuerySurge 15 connects data mappings to tests and change-impact analysis
Founder Bill Hayduk is extending RTTS's testing business with tools that link spreadsheet requirements to generated tests and show what a data change may affect.
By RuntimeWire Staff · Published
Primary source: PR Newswire
Why it matters
QuerySurge is linking data mappings to maintained testing assets. If those links and generated tests hold up in day-to-day change management, data teams could see coverage gaps sooner. The company has not yet quantified test accuracy or review effort.
QuerySurge has tied data-mapping documents to automated validation tests in version 15. The release addresses a persistent enterprise problem: requirements change, while the tests meant to enforce them can fall behind. QuerySurge announced the release on October 6th, though its version 15 release notes date the software release to September 10th.
For Bill Hayduk, founder and CEO of QuerySurge's parent, RTTS, the product extends a testing business he started in New York in 1996. A company biography says Hayduk spent nine years in foreign exchange, rising to chief operating officer of a trading firm, before moving into consulting and software testing. In a 2016 account of RTTS's early years, he said he saw a gap in test automation: business users could not maintain code-heavy tests, while programmers disliked testing. The latest release tackles a related handoff, this time between the people documenting data transformations and those responsible for proving the transformations work.
From spreadsheet to test
QuerySurge's new Mapping Studio lets teams create mappings in the product or import Excel and CSV files, then standardize them using configurable layouts. Its AI feature, Mapping Intelligence, can generate validation tests from those mappings. QuerySurge says the mapping and its linked tests remain connected as either changes.
In many data projects, a mapping document describes what a transformation should do, while validation logic lives elsewhere. The longer those assets are maintained separately, the harder it can be to tell whether a test still reflects the requirement. QuerySurge CEO Hayduk described the risk in the announcement: "Requirements change, and tests don't." Mapping Studio is designed to make that drift more visible and make test creation part of the documented workflow.
QuerySurge already sells data validation across pipelines, warehouses and BI reports, and had introduced AI-assisted mapping-to-test creation before version 15, according to its version 14 product information. The new release brings mapping documents into the same working environment as testing assets, keeping them connected to the tests generated from them over time.
A view of what changes
A second feature, Validation Lineage, displays relationships among requirements and testing assets in an interactive graph. Users can trace upstream and downstream dependencies, assess which tests may need attention after a transformation changes, and use coverage reports to find mappings without associated tests, according to QuerySurge.
Validation Lineage shows the validation assets QuerySurge knows about. Based on the release description, it does not replace a broader enterprise data catalog or lineage system. Its value depends on teams maintaining the relationships between mappings and tests, and on the graph accurately reflecting how their assets are used. The release announcement describes the feature's intended workflow but provides no independent measures of impact-analysis accuracy or time saved.
Teams deciding whether to rely on AI-generated tests will still need to assess how often generated validation logic needs correction and what review is required before it runs against production data. QuerySurge's announcement describes test generation but does not quantify those measures.
More places to validate
Version 15 also adds native validation for JSON and Parquet files stored locally, in Amazon S3 and in Microsoft Azure Data Lake Storage. QuerySurge says teams can compare those files with supported source or target systems within the same workflow as database validation. Its BI Tester now supports Power BI paginated reports and can compare report data with a trusted source or target using report parameters.
For AI-enabled test creation, QuerySurge added IBM watsonx as an endpoint alongside OpenAI. Customers that have selected watsonx can use it as another supported option for the product's AI features. The integration's availability does not establish that watsonx produces more accurate tests or that customers are using it at scale. The release also refreshes the interface, including navigation and labels.
The product is available, and existing customers can upgrade through QuerySurge's standard update process, the company says. QuerySurge calls the combined mapping-and-validation environment the industry's first. The release's value will depend on whether teams can keep requirements and executable checks aligned through routine changes without adding documentation that also requires maintenance.