Skip to main content

Expectation implementations by backend

Because Great Expectations can run against different platforms, not all Expectations have been implemented for all platforms. This table details which are implemented. Note we love pull-requests to help us fill out the missing implementations!

ExpectationsPandasSQLSpark
expect_column_to_existYYY
expect_table_columns_to_match_ordered_listYYY
expect_table_columns_to_match_setYYY
expect_table_row_count_to_be_betweenYYY
expect_table_row_count_to_equalYYY
expect_table_row_count_to_equal_other_tableNYN
expect_column_values_to_be_uniqueYYY
expect_column_values_to_not_be_nullYYY
expect_column_values_to_be_nullYYY
expect_column_values_to_be_of_typeYYY
expect_column_values_to_be_in_type_listYYY
expect_column_values_to_be_in_setYYY
expect_column_values_to_not_be_in_setYYY
expect_column_values_to_be_betweenYYY
expect_column_values_to_be_increasingYNY
expect_column_values_to_be_decreasingYNY
expect_column_value_lengths_to_be_betweenYYY
expect_column_value_lengths_to_equalYYY
expect_column_values_to_match_regexYYY
expect_column_values_to_not_match_regexYYY
expect_column_values_to_match_regex_listYYY
expect_column_values_to_not_match_regex_listYYY
expect_column_values_to_match_like_patternNYN
expect_column_values_to_not_match_like_patternNYN
expect_column_values_to_match_like_pattern_listNYN
expect_column_values_to_not_match_like_pattern_listNYN
expect_column_values_to_match_strftime_formatYNY
expect_column_values_to_be_dateutil_parseableYNN
expect_column_values_to_be_json_parseableYNY
expect_column_values_to_match_json_schemaYNY
expect_column_parameterized_distribution_ks_test_p_value_to_be_greater_than *YNN
expect_column_distinct_values_to_equal_setYYY
expect_column_distinct_values_to_contain_setYYY
expect_column_mean_to_be_betweenYYY
expect_column_median_to_be_betweenYYY
expect_column_stdev_to_be_betweenYNY
expect_column_unique_value_count_to_be_betweenYYY
expect_column_proportion_of_unique_values_to_be_betweenYYY
expect_column_most_common_value_to_be_in_setYYY
expect_column_sum_to_be_betweenYYY
expect_column_min_to_be_betweenYYY
expect_column_max_to_be_betweenYYY
expect_column_chisquare_test_p_value_to_be_greater_than *YYY
expect_column_bootstrapped_ks_test_p_value_to_be_greater_than *YNN
expect_column_kl_divergence_to_be_less_thanYYY
expect_column_pair_values_to_be_equalYYY
expect_column_pair_values_A_to_be_greater_than_BYYY
expect_column_pair_values_to_be_in_setYYY
expect_select_column_values_to_be_unique_within_recordYNY
expect_compound_columns_to_be_unique *YNY
expect_column_pair_cramers_phi_value_to_be_less_than *YNN
expect_multicolumn_sum_to_equalYYY

* This Expectation has not yet been migrated to the v3 (Batch Request) API.