In a groundbreaking move, QuerySurge has unveiled QuerySurge 15, the latest iteration of its platform that stands as the blueprint for automated data validation in enterprises. This launch is particularly exciting for data teams as it introduces two key features: Mapping Studio and Validation Lineage. These tools aim to revolutionize the way organizations handle data mapping and validation, bridging the traditional gaps that have long existed in data management workflows.
The Problem
Typically, in large organizations, mapping documents are handled in spreadsheets and reside in disparate locations, while validation tests are managed separately. This separation of functions creates a widening gulf between what the data is supposed to accomplish and what the actual tests confirm. Every time there is a change in requirements or a data migration, these discrepancies could lead to potential errors that affect data integrity across the board.
Enter Mapping Studio
The Mapping Studio feature introduced in QuerySurge 15 is a game-changer. It allows teams to either create new data mappings directly within the platform or import existing ones from Excel and CSV files. This flexibility is coupled with configurable Mapping Layouts that standardize the data presentation.
Furthermore, QuerySurge utilizes AI Mapping Intelligence to automatically generate validation tests that stay connected to their corresponding mappings. In the words of Bill Hayduk, CEO of QuerySurge, "When mapping documentation and validation assets live in different places, gaps accumulate. Mapping Studio brings the two together, ensuring that whether your data behaves as it should is not left to manual interpretation."
Understanding Validation Lineage
In addition to Mapping Studio, QuerySurge 15 introduces Validation Lineage, a feature designed to demystify the impact of any changes made to transformation logic. In an era when data is constantly evolving, data teams need to quickly identify which tests need to be revisited after changes are made. Validation Lineage addresses this by offering an interactive visual graph that illustrates connections among requirements and testing assets. This allows teams to trace upstream and downstream dependencies, thereby assessing the potential impact of any modifications before they proceed with updates. With coverage reports, users can also identify mappings that lack tests.
Additional Enhanced Features
QuerySurge 15 comes packed with additional features that further enhance its functionality:
- - Expanded File Connections: The platform now offers native validation support for JSON and Parquet files from local storage as well as Amazon S3 and Microsoft Azure Data Lake Storage. All this is incorporated into the same workflow used for database validation.
- - Power BI Paginated Report Testing: QuerySurge's BI Tester has been upgraded to compare data between Power BI paginated reports and trusted source or target data, ensuring that the results are in line with business parameters.
- - IBM watsonx Integration: The new version now supports integration with IBM watsonx as an AI endpoint in addition to OpenAI, thereby expanding the platform's AI capabilities.
- - New User Interface: A brand-new interface has been designed for ease of use, featuring updated icons and clearer labels to help new users get accustomed more quickly.
Availability and Conclusion
QuerySurge 15 is available for existing customers to upgrade through the usual updating process. New customers are invited to request demos at
querysurge.com/request-demo. For a comprehensive breakdown of features and capabilities, users can visit
querysurge.com.
In summary, the launch of QuerySurge 15 symbolizes a significant advancement in automated data validation. As enterprises continue to rely more on data-driven decision-making, tools like QuerySurge become indispensable in ensuring data accuracy and integrity throughout the data lifecycle.