Implemented ExpectationsΒΆ

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

False

True

expect_column_values_to_not_match_regex

True

False

True

expect_column_values_to_match_regex_list

True

False

False

expect_column_values_to_not_match_regex_list

True

False

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