Datagaps is the only company to be listed in Gartner® DataOps Tools & Data Observability market guides

DataOps Suite Update Spring 2025: Product Boost and New Features

DataOps Suite Update Spring 2025 Product & Features

The Spring 2025 release introduces major product innovations across the DataOps Suite, enhancing productivity for data engineers, QA teams, and analysts alike. This update focuses on intelligent automation, expanded BI platform coverage, and improved data quality monitoring. 

Let’s take a closer look at the enhancements we bring in ETL Validator, BI Validator, and Data Quality Monitoring. 

Key Takeaways

  • Plain-English SQL generation eliminates manual scripting — the embedded LLM (supporting both OpenAI and Azure AI) converts natural-language prompts into SQL queries securely within the user’s environment.
  • Databricks Unity Catalog integration enables cloud-native profiling — connecting and profiling structured datasets directly while maintaining consistent governance and oversight.
  • New lineage and profiling features improve root-cause analysis — table/column-level lineage visualizes data flow across systems, while the Profiling segment detects anomalies like missing values, distribution changes, and cardinality issues.
  • Quick Flow Pipelines cut setup time — enabling rapid pipeline creation without complex dependency mapping, alongside AI-assisted validation for schema mismatches and business rule enforcement.

1. ETL Validator: Smarter Testing Starts Here

AI-Generated Queries with Embedded LLMs 

Eliminate the complexities of SQL scripting with our feature that intelligently generates SQL queries from plain English prompts, delivered securely within your environment using an embedded LLM. This accelerates workflow creation, enhances productivity with contextual AI support, and maintains data security supporting both OpenAI and Azure AI. 

eries with Embed LLMs
Auto-Generated Descriptions for Tables & Columns 

Make your data models self-explanatory. Automatically enrich tables and columns with meaningful descriptions, which is great for documentation, governance, and smoother onboarding.  

Auto-Generate Descriptions for Tables & Columns
SQL Formatter 

This feature makes the written SQL query more structured and readable. Just one click allows users to clean up queries, reduce review overhead, and standardize development practices across teams.

SQL Formatter

2. BI Validator: Robust Testing for Modern BI

Stress Testing for Power BI & Tableau 

The updated Stress Test Plan for Tableau and Power BI, now fully integrated into the Datagaps DataOps Suite, simulates high-load scenarios to ensure reports perform reliably under heavy user activity. This feature allows teams to benchmark report performance at scale.

Stress Testing for Power BI and Tableau
Filter Dataset Testing (Enhanced) 

This feature enables thorough validation of business logic across different user views, increasing regression testing coverage and reducing filter-related issues. 

Filter Dataset Testing
BI Analyzer for Tableau

The BI Analyzer provides in-depth insights into Tableau reports and metrics, helping to identify inefficiencies such as unused fields, design flaws, and other issues. This enables users to discover opportunities for optimization and make precise improvements by setting user-defined thresholds. 

BI Analyzer for Tableau

3. Data Quality: Lineage Meets Intelligence

Unity Catalog Support (Databricks)

Datagaps DataOps Suite now directly integrates with DatabricksUnityCatalog, enabling seamless connection and profiling of cloud-native structured datasets. By leveraging Unity Catalog, teams can efficiently track and manage data quality, ensuring consistent governance and improved oversight of their cloud data environment. 

DQ Lineage Meets Intelligence - Databricks
Data Lineage Visualization

This Lineage capability helps teams to understand the flow of data across systems. Visualizing transformations at both table and column level, this feature supports root-cause analysis and improves governance transparency

Data Lineage Visualization
Profiling for Data Model Tables 

The new Profiling segment analyzes the structure and content of data models to detect anomalies, trends, and quality gaps, such as missing values, distribution changes, and cardinality issues.  

Data Profile

Coming Soon: What’s Next in Product Excellence

Quick Flow Pipelines 

Quick Flow Pipelines enable the rapid creation of streamlined data pipelines without the need for complex dependency mapping, significantly reducing setup time. This feature allows users to build fully functional pipelines in minutes, making it ideal for test runs and supporting agile development cycles with greater speed and flexibility. 

Stress Test Plan for Oracle Analytics 

Validate Oracle Analytics dashboards under heavy loads, ensuring scalability, reliability, and optimal performance in large-scale enterprise environments.

Cognos & Sigma Computing Support

The new BI integrations expand your testing universe by increasing compatibility across various analytics platforms. This facilitates broader test coverage and seamless integration with additional BI solutions, enhancing enterprise value by supporting a wider range of use cases. 

AI - Driven Mapping Manager 

Mapping Manager streamlines the management of field-level mappings across datasets by intelligently extracting mappings from ETL documentation and automatically generating validation logic and test cases 

Why It Matters?

This release marks a turning point for enterprises demanding intelligent, scalable, and AI-augmented testing. Whether you’re building a new data model or validating performance under heavy loads, these tools are designed to move you from “good enough” to “excellence by default. 

Want to see how it works?

Try our product today and experience the difference firsthand.

Frequently Asked Questions

1) What’s new in the DataOps Suite Spring 2025 feature update?

It adds plain-English-to-SQL generation via embedded LLM, Databricks Unity Catalog integration, table/column-level data lineage visualization, a new Data Profiling segment, and Quick Flow Pipelines for faster pipeline setup.

2) How does the natural-language SQL generation feature work?

It uses an embedded LLM (supporting OpenAI or Azure AI) to convert plain-English prompts into SQL queries securely within the user’s own environment, removing the need for manual SQL scripting.

3) Does DataOps Suite integrate with Databricks Unity Catalog?

Yes. This release adds direct integration with Databricks Unity Catalog, allowing teams to connect and profile cloud-native structured datasets while maintaining consistent governance.

4) What does the new Data Profiling segment in DataOps Suite detect?

It analyzes data model structure and content to detect anomalies, trends, and quality gaps such as missing values, distribution changes, and cardinality issues.

Anshul Agarwal
Anshul Agarwal

Director, Marketing, Datagaps

Director of Marketing at Datagaps. Brings hands-on experience across the data industry and data products to how Datagaps positions DataOps and validation.

Established in the year 2010 with the mission of building trust in enterprise data & reports. Datagaps provides software for ETL Data Automation, Data Synchronization, Data Quality, Data Transformation, Test Data Generation, & BI Test Automation. An innovative company focused on providing the highest customer satisfaction. We are passionate about data-driven test automation. Our flagship solutions, ETL ValidatorDataFlow, and BI Validator are designed to help customers automate the testing of ETL, BI, Database, Data Lake, Flat File, & XML Data Sources. Our tools support Snowflake, Tableau, Amazon Redshift, Oracle Analytics, Salesforce, Microsoft Power BI, Azure Synapse, SAP BusinessObjects, IBM Cognos, etc., data warehousing projects, and BI platforms.  Datagaps

Related Posts:

Leave a Reply

Your email address will not be published. Required fields are marked *

Download Datasheet
Download Datasheet
Download Datasheet
Download Datasheet
Download Datasheet

Data Quality Monitor

Continuously assess, score, and improve your enterprise data quality using rule-based and AI-powered validation
Automated Data Quality Checks at Scale

Validate uniqueness, completeness, domain accuracy, and detect orphan records.

AI-Driven Anomaly Detection and Alerts

Identify data drift and outliers using ML-based statistical methods and IQR-based profiling.

Low-Code Rule Configuration with Data Rule Wizard

Create and deploy validation rules quickly without coding, even across large datasets.

Graphical Scoring and Monitoring Dashboard

Visualize data quality trends across models, tables, and records with actionable insights.

CI/CD and Cloud Integration Ready

Enable continuous validation across pipelines using integrated APIs and DevOps compatibility.

Test Data Manager

Generate high-quality synthetic test data securely while maintaining regulatory compliance with HIPAA, GDPR, and CCPA
AI-Powered Synthetic Test Data Generation

Automatically create realistic data based on patterns in production while masking PII/PHI.

Reduced Cost and Time for Test Data Preparation

Eliminate manual rule-writing and speed up test readiness for complex use cases.

Support for Diverse Data Formats and Models

Generate millions of records in JSON, XML, CSV, relational, or hierarchical formats.

Secure, Policy-Driven Data Masking

Ensure sensitive fields are protected using deterministic, reversible, or random masking.

Flexible Deployment Across Cloud or On-Prem

Deploy within your secure environment and integrate into automated pipelines seamlessly.

ETL Testing

Maximize the efficiency, quality, and reliability of your data pipelines through intelligent automation, validation, and scalability.
100% Data Validation Across Pipelines

Validate billions of records using Spark-powered parallel execution across on-prem and cloud sources.

Accelerated Migration and QA Cycles

Reduce migration testing time by up to 60% and QA costs by 30% with automated workflows.

Automated Metadata and Transformation Testing

Detect schema mismatches and ensure business rules are correctly applied via AI-assisted validation.

Seamless Collaboration and Governance

Enable role-based access, ALM integration, and shareable web reports to unify cross-team efforts.

Low-Code/No-Code Test Creation with AI

Empower both technical and business users to build, schedule, and execute validations using prompt-based automation.

BI Validator

Ensure accuracy, performance, and security of your Business Intelligence dashboards and reports across platforms like Tableau, Power BI, and Oracle Analytics
Automated Regression Testing Across BI Reports

Detect broken visuals or logic changes post-upgrade and data refreshes.

Cross-Platform Validation of Reports and Dashboards

Compare visuals and data across environments and BI tools with zero manual effort.

Performance and Load Testing for BI Assets

Simulate concurrent user access to measure response times and report load failures.

Access and Security Validation

Ensure only authorized groups have access to the correct records and reports.

Aesthetic and Metadata Change Detection

Identify formatting inconsistencies, filter changes, and layout drift with each release.

Products

product_menu_icon01

DataOps Suite

Intelligent Data Validation and Analytics Testing Platform with Agentic AI.

ETL Validator automated ETL testing tool

ETL Validator

Automated Data Validation and ETL Testing with Agentic AI.

BI Validator automated BI testing tool

BI Validator

Smarter BI Validation For Power BI, Tableau, Oracle Analytics – Accelerated by AI Agents.

Data Quality Monitor software

DQ Monitor

Proactive Data Quality with Agentic AI – Predict, Prevent, Govern.

Test Data Manager software

Test Data Manager

Generate compliant and realistic test data for all your testing needs, enabled by Agentic AI.

×