Query Wizards

We just made data testing REALLY EASY!
See our robust solution for testing
Data Warehouses & Big Data without
needing advanced technical expertise.

Fast and easy. No Programming needed.

The latest QuerySurge release introduces the new Query Wizards. The Wizards allow both novice and experienced team members to validate their organization's data quickly with no SQL programming required.

The Wizards provide an immediate ROI through their ease-of-use and ensure that minimal time and effort are required for developing tests and obtaining results. Even novice testers are productive as soon as they start using the Wizards!

From a recent poll1 of:

  • Big Data Experts
  • Data Warehouse Architects
  • Solution Architects
  • ETL Architects

Our Question: What % of columns in your Data Warehouse have no transformations at all?

Consensus Answer:
80% of data columns have no transformation at all

1Poll conducted by RTTS on targeted LinkedIn groups

Why is this important to you?

The fact that 80% of columns have no transformations means the Query Wizards can test approximately 80% of your data without you needing to write any SQL code2

The Wizards also:

  • provide novices and non-technical team members with a fast & easy way to be productive immediately
  • speed up testing for team members skilled in SQL

2The percent of data the Query Wizards can test depends on the percent of columns that have no transformation in your data.

3 Types of Data Comparisons:

Column-Level Comparison:
This is great for Big Data stores and Data Warehouses where tables will have some columns containing transformations and some columns with no transformations.

This comparison is for the specific columns with no transformation, which on average make up about 80% of your data.  Columns containing transformations will require SQL coding. Many columns and tables can be compared simultaneously and quickly.

Table-Level Comparison:
This comparator is great for Data Migrations and Database Upgrades with no transformations at all. Many tables can be compared simultaneously and quickly.

Row Count Comparison:
Great for all - Big Data stores, Data Warehouses, Data Migrations and Database Upgrades. Many tables can be compared simultaneously and quickly.

The Query Wizards also provide you with automated features for:

  • filtering (‘Where’ clause) and
  • sorting (‘Order By’ clause).

The Query Wizards will dramatically change the way you test data.

But don’t take our word for it (or our clients). Try it for yourself.

Our 3-day Trial in the Cloud includes a self-learning tutorial that works with our sample data.

Our 15-day downloaded Trial includes a self-learning tutorial with sample data and also allows you to test against your data.

Our 30-day Proof of Concept (POC) includes a kickoff & setup meeting and weekly meetings with our team of experts to ensure your success with your data.

Need help deciding? Compare your trial options here.

Video Overview:

The Query Wizards

See a brief video overview explaining how the QuerySurge Query Wizards work.