Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

Great Expectations

greatexpectations.io

  • Free plan
  • macOS
  • Linux
  • Web
  • API
  • Self-hosted

What Great Expectations is

Great Expectations (GX) is a framework for defining tests and checking whether data meets their criteria. GX Core is a Python library for building and running data-validation workflows, and it requires Python versions 3.10 through 3.13. Data Docs converts Expectations, validation results, and related metadata into human-readable static web pages. GX lists data-source integrations including Databricks, BigQuery, Pandas, PostgreSQL, Snowflake, Spark, Redshift, cloud storage, and multiple database options. Notification integrations include Slack, Email, PagerDuty, OpsGenie, and Microsoft Teams; orchestration integrations include Apache Airflow, Dagster, and Prefect. Users can define custom rules with SQL in GX Cloud or through GX Core. GX Cloud runs tests where connected data is located and uses read-only connections. Its metadata is encrypted at rest with AES-256 and in transit with TLS 1.2, with tenant isolation using Postgres Row Level Security. GX Cloud serves data teams with an interface for technical and nontechnical stakeholders. The free Developer plan costs nothing and allows up to five data assets under test per month and three users, with unlimited rows per data asset.

Who it suits

GX suits data teams that need programmatic or cloud-based validation workflows and readable documentation for technical and nontechnical stakeholders. The free Developer plan is for teams that fit its five-assets-per-month and three-user limits.

Good to know, and what to watch

  • GX Core supports Python 3.10 through 3.13.
  • Data Docs publish validation metadata as static web pages.
  • GX Cloud tests data in its environment using read-only connections.
  • Integrates with listed notification and orchestration tools.
  • Free Developer plan allows unlimited rows per data asset.
  • Developer plan is limited to five data assets under test monthly.
  • Developer plan supports up to three users.
  • GX Core requires Python 3.10 through 3.13.

Enterprise

—

Team

—

Developer

Free

Free plan

Getting started

  1. Open the Great Expectations website
  2. Choose GX Core or GX Cloud
  3. For GX Core, use Python 3.10 through 3.13
  4. Connect a supported data source
  5. Define expectations and validation tests
  6. Use Data Docs, notifications, or orchestration integrations as needed

Limits to check

The free Developer plan covers up to five data assets under test per month and three users, with unlimited rows per asset. Team and Enterprise plans provide custom data-asset limits.

The Club's review

Great Expectations (GX) is a data-validation framework for teams that need repeatable, explicit checks on data quality and structure. It suits engineers working in Python as well as mixed data teams that need SQL rules and shareable results. Its main advantage is the combination of programmable validation, broad data-source coverage and a cloud option; the free tier is practical for small workloads but tightly capped.

Overview

GX describes expected data behaviour with tests, then validates whether real data meets those criteria. GX Core is a Python library for building and running validation workflows, while GX Cloud adds a web interface for data teams and nontechnical stakeholders. The product covers data-quality checks, database testing and schema-migration tests, with test languages spanning Python, SQL and Spark SQL and support for both execution modes.

Founded in 2018 and headquartered in Cottonwood Heights, Utah, Great Expectations is offered on a freemium basis. It runs through an API, Linux, macOS, self-hosted deployments and the web.

Key features

Validation and custom rules

GX Core requires Python 3.10 through 3.13 and gives developers a programmatic way to assemble and run checks. GX Cloud lets users write custom rules in SQL from its interface, and custom rules are also supported in Core. This split works well when engineers need versionable code but analysts and other stakeholders need a less code-dependent entry point. Core is less suitable for teams that want an entirely visual workflow.

Documentation and connectivity

Data Docs convert Expectations, Validation Results and associated metadata into human-readable static web pages. They provide a clear artefact for reviewing validation outcomes and communicating them beyond the engineering team, but they are static pages rather than a live reporting surface.

Data-source integrations include Databricks, BigQuery, Pandas, PostgreSQL, Snowflake, Spark, Redshift, Neon, Citus, Amazon Aurora, Amazon S3, Azure Blob Storage, Google Cloud Storage and AlloyDB. Database support also covers Microsoft SQL Server, Oracle, SQLite and Trino. That breadth is valuable for organisations with mixed estates, although each additional system still needs appropriate configuration and ownership.

Operations, security and deployment

GX connects read-only to data with secure, encrypted methods and executes Cloud tests in the environment where the connected data resides. Cloud metadata is encrypted at rest with AES-256 and in transit with TLS 1.2, with tenant isolation provided by Postgres Row Level Security. Integrations for Slack, Email, PagerDuty, OpsGenie and Microsoft Teams support operational notifications; Apache Airflow, Dagster and Prefect cover orchestration.

GX Cloud combines a web interface, API and backend, with alternate deployments that keep orchestration in an organisation's or local environment. Great Expectations states that it has SOC 2 Type II certification, and Enterprise customers can obtain a HIPAA business associate agreement. Enterprise support includes a 99.5% SLA and response times as fast as one hour during business hours, depending on severity.

Pricing

The Developer plan costs free and allows up to five data assets under test per month, three users and unlimited rows per data asset. It is a sensible starting point for an individual or a small team proving a validation workflow, but the five-asset and three-user ceilings make it unsuitable for a growing production programme.

Team has custom pricing, custom data-asset limits, up to 10 users, unlimited expectations and unlimited rows per data asset. It fits a departmental data team that needs more users and tests, while the undisclosed asset limit means buyers must confirm capacity before committing. Enterprise also uses custom pricing and removes the user ceiling, with custom data-asset limits, unlimited expectations and unlimited rows per asset. Its support and HIPAA terms make it the plan for larger or regulated deployments.

Platforms

Great Expectations is available through API, Linux, macOS, self-hosted and web deployments. Its database coverage includes AlloyDB, Amazon Aurora PostgreSQL, Citus, Databricks SQL, Microsoft SQL Server, Neon, Oracle, PostgreSQL, Redshift, Snowflake, SQLite and Trino.

Who it's for

GX is a strong fit for data engineering and platform teams that want validation embedded in Python, SQL or Spark SQL pipelines, especially when data is spread across several warehouses and databases. Its Cloud interface and Data Docs also help nontechnical stakeholders review results. Small teams can start free, but organisations with more than five monthly assets or three users will need a paid tier; teams seeking only lightweight database change management should look elsewhere.

Pros and cons

Pros

  • Python, SQL and Spark SQL support accommodates both code-first and SQL-oriented validation work.
  • Data Docs turn validation output into static, human-readable pages that are easier to share.
  • Wide source, notification and orchestration integrations reduce the need to build surrounding connectors.
  • Read-only encrypted connections and documented Cloud security controls suit governed environments.
  • Enterprise adds a 99.5% SLA and an available HIPAA agreement for regulated customers.

Cons

  • The free Developer tier permits only five data assets per month and three users, limiting sustained production use.
  • Core is Python-centric, so teams without Python capability may prefer the Cloud SQL interface or another tool.
  • Data Docs are static pages, not a live analytics dashboard.
  • Team and Enterprise pricing and asset limits require a sales conversation, complicating upfront cost comparison.

Alternatives

For database-focused options, see Database Testing Tools. Choose Atlas when an open-core database schema and migration engine is the priority. Bytebase Enterprise is better when database change management with user-based Pro pricing and instance limits is central. Pick Amazon Deequ for a free Apache 2.0 library built around Spark. DataKitchen TestGen suits teams wanting an open-source option with one user, one connection and one project at no cost. Sqitch is a free database change-management application. Soda is an alternative for pipeline testing, observability and alerting integrations. HammerDB focuses on free, open-source database benchmarking. pgroll is a free cross-platform binary for PostgreSQL 14 or later.

Verdict

Choose Great Expectations if your team needs expressive, repeatable data checks across varied systems, with Python control and a Cloud interface for wider participation. Its integrations, documentation and enterprise controls are the main reasons to adopt it. Look elsewhere if your scope is limited to database migrations or benchmarking, or if the Developer tier's five-asset and three-user limits cannot accommodate your workload.

The verdict

GX offers a Python library and a cloud interface for defining and running data-validation checks.

Questions people ask

Is Great Expectations free?

Yes. Great Expectations offers a free Developer plan with up to five data assets under test per month and up to three users.

Which platforms does it support?

It is available through API, Linux, macOS, self-hosted, and web platforms.

Which Python versions does GX Core require?

GX Core requires Python 3.10 through 3.13.

What data sources can it connect to?

Listed integrations include Databricks, BigQuery, Pandas, PostgreSQL, Snowflake, Spark, Redshift, Amazon S3, Azure Blob Storage, Google Cloud Storage, and AlloyDB.

Can it send alerts and run with orchestrators?

Notifications integrate with Slack, Email, PagerDuty, OpsGenie, and Microsoft Teams. Orchestration integrations include Apache Airflow, Dagster, and Prefect.

Is Great Expectations open source?

The listed facts describe GX Core as a Python library and GX Cloud as a service, but do not identify an open-source license.

What the maker publishes

Compliance
Great Expectations states that it has SOC 2 Type II certification, and a HIPAA business associate agreement is available for Enterprise customers. source
Custom rules
GX Cloud lets users create custom rules with SQL in its user interface and also supports custom rules through GX Core. source
Data Docs
Data Docs translate Expectations, Validation Results, and other metadata into human-readable documentation saved as static web pages. source
Data integrations
GX lists Databricks, BigQuery, Pandas, PostgreSQL, Snowflake, Spark, Redshift, Neon, Citus, Amazon Aurora, Amazon S3, Azure Blob Storage, Google Cloud Storage, and AlloyDB as data-source integrations. source
Data validation
GX is a framework for describing data with expressive tests and validating that data meets test criteria. source
Deployment architecture
GX Cloud consists of a web-based user interface, an API, and a backend, with alternate deployments available that host orchestration in an organizational or local environment. source
Enterprise support
Enterprise customers receive a 99.5% SLA and support response times as soon as one hour during business hours depending on issue severity. source
Founded
2018 source
GX Core
GX Core is a Python library that provides a programmatic interface for building and running data-validation workflows. source
Headquarters
Cottonwood Heights, Utah, United States source
Notifications
GX lists Slack, Email, PagerDuty, OpsGenie, and Microsoft Teams as notification-action integrations. source
Orchestration
GX lists Apache Airflow, Dagster, and Prefect as orchestration integrations. source
Processing location
GX Cloud executes tests in the environment where the connected data is located and connects to data read-only using secure, encrypted methods. source
Security
GX Cloud metadata is encrypted at rest with AES-256 and in transit with TLS 1.2, and tenant isolation uses Postgres Row Level Security. source
Supported Python
GX Core requires Python versions 3.10 through 3.13. source
Target users
GX Cloud is designed for data teams and provides an interface accessible to both technical and nontechnical stakeholders. source

Checked against the maker's pages on 30 Sept 2026.