Table of 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!

Expectations

Pandas

SQL

Spark

expect_column_to_exist

True

True

True

expect_table_columns_to_match_ordered_list

True

True

True

expect_table_row_count_to_be_between

True

True

True

expect_table_row_count_to_equal

True

True

True

expect_column_values_to_be_unique

True

True

True

expect_column_values_to_not_be_null

True

True

True

expect_column_values_to_be_null

True

True

True

expect_column_values_to_be_of_type

True

True

True

expect_column_values_to_be_in_type_list

True

True

True

expect_column_values_to_be_in_set

True

True

True

expect_column_values_to_not_be_in_set

True

True

True

expect_column_values_to_be_between

True

True

True

expect_column_values_to_be_increasing

True

False

False

expect_column_values_to_be_decreasing

True

False

False

expect_column_value_lengths_to_be_between

True

True

True

expect_column_value_lengths_to_equal

True

True

True

expect_column_values_to_match_regex

True

True

True

expect_column_values_to_not_match_regex

True

True

True

expect_column_values_to_match_regex_list

True

True

False

expect_column_values_to_not_match_regex_list

True

True

False

expect_column_values_to_match_strftime_format

True

False

False

expect_column_values_to_be_dateutil_parseable

True

False

False

expect_column_values_to_be_json_parseable

True

False

False

expect_column_values_to_match_json_schema

True

False

False

expect_column_parameterized_distribution_ks_test_p_value_to_be_greater_than

True

False

False

expect_column_distinct_values_to_equal_set

True

True

True

expect_column_distinct_values_to_contain_set

True

True

True

expect_column_mean_to_be_between

True

True

True

expect_column_median_to_be_between

True

True

True

expect_column_stdev_to_be_between

True

False

True

expect_column_unique_value_count_to_be_between

True

True

True

expect_column_proportion_of_unique_values_to_be_between

True

True

True

expect_column_most_common_value_to_be_in_set

True

False

True

expect_column_sum_to_be_between

True

True

True

expect_column_min_to_be_between

True

True

True

expect_column_max_to_be_between

True

True

True

expect_column_chisquare_test_p_value_to_be_greater_than

True

True

True

expect_column_bootstrapped_ks_test_p_value_to_be_greater_than

True

False

False

expect_column_kl_divergence_to_be_less_than

True

True

True

expect_column_pair_values_to_be_equal

True

False

False

expect_column_pair_values_A_to_be_greater_than_B

True

False

False

expect_column_pair_values_to_be_in_set

True

False

False

expect_multicolumn_values_to_be_unique

True

False

False