ValidateX/user_data_suite.yaml at main · kaviarasanmani/ValidateX · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
suite_name: user_data_quality
meta: {}
expectations:
- expectation_type: expect_table_row_count_to_be_between
  kwargs:
    min_value: 50
    max_value: 500
- expectation_type: expect_table_column_count_to_equal
  kwargs:
    value: 7
- expectation_type: expect_column_to_exist
  column: user_id
- expectation_type: expect_column_to_exist
  column: email
- expectation_type: expect_column_to_not_be_null
  column: user_id
- expectation_type: expect_column_to_not_be_null
  column: username
- expectation_type: expect_column_to_not_be_null
  column: email
- expectation_type: expect_column_values_to_be_unique
  column: user_id
- expectation_type: expect_column_values_to_be_unique
  column: email
- expectation_type: expect_column_values_to_be_between
  column: age
  kwargs:
    min_value: 0
    max_value: 150
- expectation_type: expect_column_values_to_be_between
  column: balance
  kwargs:
    min_value: 0
    max_value: 10000
- expectation_type: expect_column_values_to_be_in_set
  column: status
  kwargs:
    value_set:
    - active
    - inactive
    - pending
- expectation_type: expect_column_values_to_match_regex
  column: email
  kwargs:
    regex: ^[\w.]+@[\w]+\.\w+$
- expectation_type: expect_column_mean_to_be_between
  column: age
  kwargs:
    min_value: 20
    max_value: 80
- expectation_type: expect_column_mean_to_be_between
  column: balance
  kwargs:
    min_value: 0
    max_value: 2000