EchoSphere

EchoSphere is a fast, lightweight SQL testing framework designed to validate your data quality with simple, readable SQL files. It focuses on developer experience and velocity. Write tests as SQL, run them in parallel, and integrate the results into your CI/CD.

EchoSphere derives from the mythological nymph Echo — a symbol of reflection and resonance. Your tests “echo” the health of your data systems.

Supported Connectors 🔬

     

Why EchoSphere? ⚡

• Simple: Tests are plain SQL (.es.sql) files
• Fast: Concurrent execution for quick feedback
• CI-ready: JUnit output and machine-readable results
• Visibility: Export data issues into Excel files

Quick Links 🔗

• Getting Started: installation, first setup, and a 5‑minute quickstart
• User Guide: workflows, environment management, and writing effective tests
• Command Reference: full CLI documentation for es
• Advanced Topics: CI/CD, performance, and extensions
• Troubleshooting: common issues and debugging tips

What a Test Looks Like 🧪

EchoSphere considers a test successful if it returns zero rows. That is the only requirement. Everything else is up to you. If the query returns one or more rows, the test fails and the rows explain what went wrong.

-- file: tests/orders_total.es.sql
SELECT *
FROM (
  SELECT SUM(O_TOTALPRICE) AS total
  FROM ORDERS
  WHERE O_ORDERDATE = '1995-02-19'
)
WHERE total <> 944870465.07;