Amazon Deequ vs tSQLt
Amazon Deequ
github.comtSQLt
tsqlt.orgSide by side
| Figure | Amazon Deequ | tSQLt |
|---|---|---|
| Price from | Free | Free |
| Free plan | Yes | Yes |
| Free trial | — | — |
| Open source | — | — |
| Windows | Yes | — |
| macOS | Yes | — |
| Linux | Yes | — |
| API | Yes | — |
| Self-hosted | Yes | Yes |
| Plans published | 1 | 1 |
| Spec score · Database Testing Tools | 8.7 (#3) | 7.8 (#14) |
| Installation | The 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. |
| Integrations | Deequ 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. |
| License | The library is licensed under the Apache 2.0 License. | The official repository identifies the license as Apache 2.0. |
| Purpose | Deequ 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
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.
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.