Open source data quality for Azure Synapse

Azure Synapse data quality, without writing tests.

Point TestGen at Azure Synapse Analytics. It profiles every table, generates thousands of tests, and watches freshness, volume, and schema. Read-only access. Free and open source.

TestGen monitors: freshness, volume, schema, and metric anomalies by table Take the product tour
Start here

Install TestGen

Pick your platform. Free and open source.

$ Select a platform above to get started.
TestGen monitors: freshness, volume, schema, and metric anomalies by table Take the product tour
  • 55data profiling column characteristics
  • 32data hygiene detectors
  • 34test types auto-generated from the profile
  • 19business rule and custom SQL test types

Connect TestGen to Azure Synapse

TestGen pushes read-only queries into Synapse and stores only results: statistics, scores, and test outcomes. Moving to Fabric later? TestGen connects to Fabric too.

Sign-in
SQL login, Azure Managed Identity, or an Entra ID service principal.
Permissions
SELECT on the tables you want tested. information_schema and sys.partitions are readable by default, and sys.objects shows the tables you can already select.
Where TestGen runs
An Azure VM, a container, or any machine that can reach the workspace.
Next stop: Fabric
The same tests carry over when you move to Microsoft Fabric.
Read more

Azure Synapse data problems TestGen catches

What breaks in a warehouse fed from files and many sources. Each card lists the TestGen checks that find it.

What TestGen does on Azure Synapse

Everything below is in the open source release, and all of it works on Azure Synapse. Enterprise adds team access, security, Commercial Pharma tests, and support.

From DataKitchen on Synapse and Azure

Why teams choose TestGen

  • You Don't Have Time to Write Tests. TestGen Does It Automatically.

    You're buried in customer requests. You have no time to write tests, let alone innovate. TestGen scans your data and generates the tests and anomaly detectors for you. No coding, no massive YAML configuration.

  • A warehouse this big needs more tests than anyone will write.

    TestGen profiles every column and generates the tests, then monitors each table for freshness, volume, and schema changes.

    See how TestGen works →

  • Runs inside Synapse

    Tests run as read-only SQL where the data sits. Nothing is copied out, and nothing is written back.

  • Apache 2.0, core engine free

    Every detector, every characteristic, and every test type but the 12 Commercial Pharma types. In the open source.

  • Self-hosted

    Your data never leaves your environment.

  • Bootstrapped since 2013

    Profitable, independent, and not pivoting next quarter.

Open Source with Reasonable Enterprise Pricing

Open source TestGen is free for one user, one project, and one database connection. Enterprise is a flat $100 per month per user and database connection, with unlimited tables and data volume. No per-table tax. A year of enterprise data quality costs roughly one data engineer's monthly salary.

See pricing
Enterprise, per user and database connection$100/mo
Open source: one user, one project, one connectionFree

TestGen versus the competition

Head-to-head comparisons with every major data quality and observability tool. Search for the one you are evaluating.

58
See all comparisons →
Trusted by data teams at
  • Bristol Myers Squibb
  • Eisai
  • Catholic Relief Services
  • Progeny Health
  • X4
  • KOA
  • CNH

Questions

How does TestGen sign in to Azure Synapse?

With a SQL login, an Azure Managed Identity, or an Entra ID service principal. The account needs SELECT on the tables you want tested.

We are moving from Synapse to Fabric. Does that matter?

TestGen connects to both, so you can run the same profiling and tests on Synapse before the move and on Fabric after it, and compare the results.

Does TestGen change anything in my database?

No. TestGen runs read-only SELECT queries to profile data, run tests and collect monitor metrics. It never runs INSERT, UPDATE, DELETE, CREATE, ALTER or DROP, and it stores only computed results (statistics, scores and test outcomes) in its own application database.

Does TestGen work on very large Synapse tables?

Yes. TestGen runs its queries inside Synapse, and sample-based data profiling uses database-native sampling on Synapse, so it doesn’t pull the table out to profile it.

Can TestGen run after a Synapse pipeline?

Yes. Schedule test runs in TestGen or trigger them through its CLI or API as the last step of a pipeline, so each load gets tested before anyone reads it.

Is TestGen free?

The open source edition is free under Apache 2.0, for one user, one project and one connection, with every detector and test type except the Commercial Pharma tests. Enterprise is $100 per user per month plus $100 per database connection per month, with no per-table fees. See pricing.

The DataOps Way to Data Quality and Data Observability cover

Free book

Not ready to try it out now? Read the free book.

The DataOps Way to Data Quality and Data Observability covers why data quality keeps failing and what to do about it: culture, testing strategy, monitoring, and the seven deadly sins of AI-generated pipelines.

  • 620 pages
  • 63 chapters
  • Updated September 2026
  • By Chris Bergh, Chip Bloche, and Gil Benghiat
Get the free PDF → Ready to install? Back to the installer ↑