-
Notifications
You must be signed in to change notification settings - Fork 518
/
Copy pathschema.yml
174 lines (145 loc) · 3.87 KB
/
schema.yml
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
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
version: 2
models:
- name: test_generate_series
tests:
- dbt_utils.equality:
compare_model: ref('data_generate_series')
- name: test_get_column_values
columns:
- name: count_a
tests:
- accepted_values:
values:
- '1'
- name: count_b
tests:
- accepted_values:
values:
- '1'
- name: count_c
tests:
- accepted_values:
values:
- '1'
- name: count_d
tests:
- accepted_values:
values:
- '1'
- name: count_e
tests:
- accepted_values:
values:
- '1'
- name: count_f
tests:
- accepted_values:
values:
- '1'
- name: count_g
tests:
- accepted_values:
values:
- '5'
- name: test_get_column_values_where
tests:
- dbt_utils.equality:
compare_model: ref('data_get_column_values_where_expected')
- name: test_get_filtered_columns_in_relation
tests:
- dbt_utils.equality:
compare_model: ref('data_filtered_columns_in_relation_expected')
- name: test_get_relations_by_prefix_and_union
columns:
- name: event
tests:
- not_null
- name: user_id
tests:
- dbt_utils.at_least_one
- not_null
- unique
- name: test_nullcheck_table
columns:
- name: field_1
tests:
- not_empty_string
- name: field_2
tests:
- not_empty_string
- name: field_3
tests:
- not_empty_string
- name: test_safe_add
tests:
- assert_equal:
actual: actual
expected: expected
- name: test_pivot
tests:
- dbt_utils.equality:
compare_model: ref('data_pivot_expected')
- name: test_pivot_apostrophe
tests:
- dbt_utils.equality:
compare_model: ref('data_pivot_expected_apostrophe')
- name: test_unpivot_original_api
tests:
- dbt_utils.equality:
compare_model: ref('data_unpivot_original_api_expected')
- name: test_unpivot
tests:
- dbt_utils.equality:
compare_model: ref('data_unpivot_expected')
- name: test_unpivot_bool
tests:
- dbt_utils.equality:
compare_model: ref('data_unpivot_bool_expected')
- name: test_star
tests:
- dbt_utils.equality:
compare_model: ref('data_star_expected')
- name: test_star_prefix_suffix
tests:
- dbt_utils.equality:
compare_model: ref('data_star_prefix_suffix_expected')
- name: test_star_aggregate
tests:
- dbt_utils.equality:
compare_model: ref('data_star_aggregate_expected')
- name: test_star_uppercase
tests:
- dbt_utils.equality:
compare_model: ref('data_star_expected')
- name: test_surrogate_key
tests:
- assert_equal:
actual: actual_column_1_only
expected: expected_column_1_only
- assert_equal:
actual: actual_all_columns_arguments
expected: expected_all_columns
- assert_equal:
actual: actual_all_columns_list
expected: expected_all_columns
- name: test_union
tests:
- dbt_utils.equality:
compare_model: ref('data_union_expected')
- name: test_union_where
columns:
- name: id
tests:
- dbt_utils.expression_is_true:
expression: "= 1"
- name: favorite_number
tests:
- dbt_utils.not_constant
- name: test_get_relations_by_pattern
tests:
- dbt_utils.equality:
compare_model: ref('data_union_events_expected')
- name: test_deduplicate
tests:
- dbt_utils.equality:
compare_model: ref('data_deduplicate_expected')