Skip to content
SPECIFICTION
Get listed

Amazon Deequ vs tSQLt

Amazon Deequ

github.com

tSQLt

tsqlt.org

Side by side

FigureAmazon DeequtSQLt
Price fromFreeFree
Free planYesYes
Free trial——
Open source——
WindowsYes—
macOSYes—
LinuxYes—
APIYes—
Self-hostedYesYes
Plans published11
Spec score · Database Testing Tools8.7 (#3)7.8 (#14)
InstallationThe README provides Maven and sbt dependency examples and directs users to select a release matching their Spark version.Installation uses the included tSQLt.class.sql script in a development database.
IntegrationsDeequ is built on Apache Spark, is distributed through Maven artifacts, and has a Python interface called PyDeequ.The site identifies Redgate SQL Test as its preferred commercial SSMS extension and the official SSMS plug-in for tSQLt.
LicenseThe library is licensed under the Apache 2.0 License.The official repository identifies the license as Apache 2.0.
PurposeDeequ is an Apache Spark library for defining unit tests that measure data quality in large datasets.tSQLt is an open source framework for unit testing SQL Server databases with tests written in T-SQL.

Plans

Amazon Deequ

  • Apache 2.0 open-source libraryFree

Amazon Deequ pricing →

tSQLt

  • tSQLtFree

tSQLt pricing →

In their own words

Amazon Deequ

Amazon Deequ is an Apache Spark library for writing data unit tests that measure quality in large datasets, including datasets with billions of rows. Its checks cover row counts, completeness, uniqueness, allowed values, nonnegative values, patterns, and approximate quantiles. Deequ also supports data profiling, stored and queryable metrics, anomaly detection over time, automatic constraint suggestions, and incremental metric computation. Its declarative Data Quality Definition Language includes rules for counts, completeness, uniqueness, statistics, schema matching, freshness, and custom SQL. Row-level evaluation can identify records that pass or fail supported rules, while dataset-level rules such as RowCount and Mean are skipped in that mode. Deequ targets specific Apache Spark versions, so the release must match the Spark version; versions 2.1.0 and later require Java 11. The project provides Maven and sbt dependency examples. It is licensed under Apache 2.0, and Python users can use the PyDeequ interface.

Visit github.com

tSQLt

tSQLt is an open-source unit testing framework for Microsoft SQL Server. Developers write tests in T-SQL, organize them in schemas, and define shared setup methods there. Tests run automatically inside transactions to remain independent and reduce cleanup work. For isolation, tSQLt can fake tables and views and create stored procedure spies. Assertions include AssertEquals and AssertEqualsTable, while results can be generated as plain text or XML for continuous integration tools. The project says it works with SQL Server editions from SQL Server 2005 Service Pack 2 onward. tSQLt is self-hosted, released under the Apache 2.0 license, and the listed plan costs nothing. Installation requires running PrepareServer.sql once per server with SA permission, then installing the framework in a development database. The quick start explicitly says never to install tSQLt in production. Redgate SQL Test is named as its preferred SSMS plug-in.

Visit tsqlt.org