# Great Expectations Data Quality

> Open-source Python data quality framework, stewarded by Fivetran, with 50+ declarative expectations to validate files, SQL databases, warehouses, and DataFrames.

Source: https://toolsfordata.com/tools/great-expectations/ · Updated 2026-11-13

[Website](https://greatexpectations.io/) · [Docs](https://docs.greatexpectations.io/docs/core/introduction/) · [GitHub](https://github.com/fivetran/great_expectations) (11.9k stars)

Best for: Python data engineers who want a free, code-first testing library and don't need a managed UI, since GX Cloud is no longer available.

## What it's used for

Great Expectations is used to validate data in Python: you group Expectations into suites, run them with Checkpoints on tables, files or Spark DataFrames, and share the results as Data Docs.

## Pricing

Great Expectations (GX Core) is free under Apache 2.0. GX Cloud, the paid managed version, is no longer available.

## Deployment

Great Expectations is a Python library: you install it with pip and run it wherever your pipelines run, such as Airflow, Dagster or a CI job.

## Review

Strengths:
- Free under Apache 2.0, with 50+ built-in Expectations.
- Runs on SQL databases, warehouses, files, and Spark or pandas DataFrames.
- Data Docs turn results into HTML reports anyone can read.

Caveats:
- No managed UI or alerting service: GX Cloud is no longer available.
- Python setup with its own concepts (data sources, suites, Checkpoints) to learn.
- No anomaly detection, lineage or incident management.

Recommendation: If your tests live in dbt, dbt tests are simpler. For checks in readable YAML, consider Soda Core; for DataFrame schemas in code, Pandera; for Spark at scale, Deequ.

## Pricing

- Open source: OSS library (GX Core)
- Source: https://github.com/fivetran/great_expectations (checked 2026-11-02)

## Where it fits

- data testing (core): Open-source Python data quality framework where data tests are Expectations grouped in suites and run by Checkpoints against SQL tables, files, and Spark DataFrames, with Slack or email actions and Data Docs reports.
- open source (core): Open-source Python data quality framework under Apache 2.0, stewarded by Fivetran, with Expectations, Checkpoints, and Data Docs; GX Cloud is no longer available, so GX Core is the whole product.

## Integrations

35 integrations, each sourced from the vendor docs.

- Data Orchestration: Apache Airflow, Dagster, Prefect
- Data Platform: Microsoft Fabric
- Data Storage: Amazon S3, Azure Blob Storage, Azure Data Lake Storage, Google Cloud Storage
- Data Transformation: Apache Spark, Pandas, dbt
- Data Warehouse: Amazon Redshift, ClickHouse, Databricks SQL, Dremio, Google BigQuery, OpenText Analytics Database (Vertica), Snowflake, Teradata
- Databases: AlloyDB, Amazon Aurora, Citus, Microsoft SQL Server, MySQL, Neon, PostgreSQL, SQLite
- Incident Management: Jira
- LLM Providers: OpenAI
- Notifications: Microsoft Teams, Opsgenie, PagerDuty, Slack
- Query Engine: Amazon Athena, Trino

## Alternatives

- [Soda Core](https://toolsfordata.com/tools/soda-core/): The most common alternative: YAML instead of Python, with a paid cloud version if you outgrow it.
- [dbt tests](https://toolsfordata.com/tools/dbt-tests/): Consider dbt tests if your transformations are in dbt: checks live next to the models and run in the same CI/CD.
- [Pandera](https://toolsfordata.com/tools/pandera/): Consider Pandera if your checks should live in Python code, next to the DataFrame transformations.
- [Deequ](https://toolsfordata.com/tools/deequ/): Consider Deequ if your data is large and processed in Spark.
- [Elementary OSS](https://toolsfordata.com/tools/elementary-oss/): Consider Elementary OSS if you run dbt and want anomaly detection, not only rule checks.
- [Soda Cloud](https://toolsfordata.com/tools/soda-cloud/): The managed option now that GX Cloud is gone: data contracts with a UI and AI agents that explain issues.
