forked from GoogleCloudPlatform/cortex-dag-generator
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathcdc_settings.yaml
executable file
·314 lines (313 loc) · 8.6 KB
/
cdc_settings.yaml
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
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
# Copyright 2022 Google LLC
#
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#
# https://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.
data_to_replicate:
{% if sql_flavour.upper() == 'S4' %}
- base_table: acdoca
load_frequency: "@hourly"
cluster_details: {columns: ["rclnt", "rbukrs"]}
- base_table: finsc_ld_cmp
load_frequency: "@daily"
- base_table: finsc_ledger_rep
load_frequency: "@daily"
- base_table: matdoc
load_frequency: "@hourly"
- base_table: prcd_elements
load_frequency: "@hourly"
- base_table: ckmlhd
load_frequency: "@daily"
- base_table: ckmlcr
load_frequency: "@daily"
- base_table: hrrp_node
load_frequency: "@monthly"
- base_table: hrrp_directory
load_frequency: "@monthly"
- base_table: hrrp_nodet
load_frequency: "@monthly"
- base_table: sethanahier0101
load_frequency: "@monthly"
- base_table: sethanahier0106
load_frequency: "@monthly"
- base_table: finsc_ledger
load_frequency: "@yearly"
- base_table: finsc_ledger_t
load_frequency: "@yearly"
{% endif %}
{% if sql_flavour.upper() == 'ECC' %}
- base_table: anla
load_frequency: "@hourly"
- base_table: ankt
load_frequency: "@hourly"
- base_table: faglflexa
load_frequency: "@hourly"
- base_table: konv
load_frequency: "@daily"
partition_details: {
column: "kdatu", partition_type: "time", time_grain: "day"
}
cluster_details: {columns: ["stunr"]}
- base_table: mseg
load_frequency: "@hourly"
- base_table: prps
load_frequency: "@hourly"
- base_table: vbuk
load_frequency: "@hourly"
- base_table: vbup
load_frequency: "@hourly"
- base_table: msfd
load_frequency: "@weekly"
- base_table: fagl_011pc
load_frequency: "@monthly"
- base_table: fagl_011qt
load_frequency: "@monthly"
- base_table: fagl_011zc
load_frequency: "@monthly"
{% endif %}
- base_table: adr6
load_frequency: "@daily"
- base_table: adrc
load_frequency: "@daily"
- base_table: adrct
load_frequency: "@daily"
- base_table: bkpf
load_frequency: "@hourly"
partition_details: {
column: "budat", partition_type: "time", time_grain: "day"
}
cluster_details: {columns: ["bukrs", "gjahr"]}
- base_table: afko
load_frequency: "@hourly"
- base_table: afpo
load_frequency: "@hourly"
- base_table: aufk
load_frequency: "@hourly"
- base_table: bseg
load_frequency: "@hourly"
cluster_details: {columns: ["mandt", "bukrs", "gjahr"]}
- base_table: but000
load_frequency: "@daily"
- base_table: but020
load_frequency: "@daily"
- base_table: cepc
load_frequency: "@daily"
- base_table: cepct
load_frequency: "@daily"
- base_table: csks
load_frequency: "@daily"
- base_table: cskt
load_frequency: "@daily"
- base_table: ekbe
load_frequency: "@hourly"
partition_details: {
column: "budat", partition_type: "time", time_grain: "day"
}
cluster_details: {columns: ["mandt", "vgabe", "ebeln", "bwart"]}
- base_table: ekes
load_frequency: "@hourly"
- base_table: eket
load_frequency: "@hourly"
partition_details: {
column: "eindt", partition_type: "time", time_grain: "day"
}
cluster_details: {columns: ["mandt", "ebeln"]}
- base_table: ekkn
load_frequency: "@hourly"
- base_table: ekko
load_frequency: "@hourly"
partition_details: {
column: "bedat", partition_type: "time", time_grain: "day"
}
cluster_details: {columns: ["mandt", "ebeln"]}
- base_table: ekpo
load_frequency: "@hourly"
partition_details: {
column: "aedat", partition_type: "time", time_grain: "day"
}
cluster_details: {columns: ["mandt", "ebeln"]}
- base_table: jest
load_frequency: "@daily"
- base_table: kna1
load_frequency: "@daily"
- base_table: lfa1
load_frequency: "@daily"
- base_table: likp
load_frequency: "@hourly"
partition_details: {
column: "erdat", partition_type: "time", time_grain: "month"
}
cluster_details: {columns: ["vkorg"]}
- base_table: lips
load_frequency: "@hourly"
partition_details: {
column: "erdat", partition_type: "time", time_grain: "month"
}
- base_table: makt
load_frequency: "@daily"
cluster_details: {columns: ["spras"]}
- base_table: mara
load_frequency: "@daily"
- base_table: marc
load_frequency: "@hourly"
- base_table: mard
load_frequency: "@hourly"
- base_table: mast
load_frequency: "@monthly"
- base_table: mbew
load_frequency: "@daily"
- base_table: mbewh
load_frequency: "@daily"
- base_table: mcha
load_frequency: "@daily"
- base_table: rbco
load_frequency: "@hourly"
- base_table: rbkp
load_frequency: "@hourly"
- base_table: rseg
load_frequency: "@hourly"
- base_table: setleaf
load_frequency: "@monthly"
- base_table: setnode
load_frequency: "@monthly"
- base_table: setheadert
load_frequency: "@monthly"
- base_table: setheader
load_frequency: "@monthly"
- base_table: ska1
load_frequency: "@daily"
- base_table: skat
load_frequency: "@daily"
- base_table: stas
load_frequency: "@monthly"
- base_table: stko
load_frequency: "@monthly"
- base_table: stpo
load_frequency: "@monthly"
- base_table: t001
load_frequency: "@once"
- base_table: t001k
load_frequency: "@once"
- base_table: t001l
load_frequency: "@once"
- base_table: t001w
load_frequency: "@once"
- base_table: t002
load_frequency: "@once"
- base_table: t005
load_frequency: "@yearly"
- base_table: t005k
load_frequency: "@yearly"
- base_table: t005s
load_frequency: "@yearly"
- base_table: t005t
load_frequency: "@yearly"
- base_table: t006
load_frequency: "@yearly"
- base_table: t006a
load_frequency: "@once"
- base_table: t006t
load_frequency: "@once"
- base_table: t009
load_frequency: "@once"
- base_table: t009b
load_frequency: "@once"
- base_table: t023
load_frequency: "@once"
- base_table: t023t
load_frequency: "@once"
- base_table: t024
load_frequency: "@once"
- base_table: t024e
load_frequency: "@once"
- base_table: t134
load_frequency: "@once"
- base_table: t134t
load_frequency: "@once"
- base_table: t148t
load_frequency: "@once"
- base_table: t156t
load_frequency: "@once"
- base_table: t157e
load_frequency: "@once"
- base_table: t161
load_frequency: "@once"
- base_table: t161t
load_frequency: "@once"
- base_table: t179
load_frequency: "@once"
- base_table: t179t
load_frequency: "@once"
- base_table: t881
load_frequency: "@once"
- base_table: t881t
load_frequency: "@once"
- base_table: tcurc
load_frequency: "@once"
- base_table: tcurf
load_frequency: "@once"
- base_table: tcurr
load_frequency: "@daily"
- base_table: tcurt
load_frequency: "@daily"
- base_table: tcurx
load_frequency: "@daily"
- base_table: tspa
load_frequency: "@yearly"
- base_table: tspat
load_frequency: "@yearly"
- base_table: tj02t
load_frequency: "@yearly"
- base_table: tka02
load_frequency: "@yearly"
- base_table: tvarvc
load_frequency: "@daily"
- base_table: tvfst
load_frequency: "@yearly"
- base_table: tvko
load_frequency: "@yearly"
- base_table: tvkot
load_frequency: "@yearly"
- base_table: tvlst
load_frequency: "@yearly"
- base_table: tvtw
load_frequency: "@yearly"
- base_table: tvtwt
load_frequency: "@yearly"
- base_table: vbak
load_frequency: "@hourly"
partition_details: {
column: "audat", partition_type: "time", time_grain: "day"
}
cluster_details: {columns: ["vkorg"]}
- base_table: vbap
load_frequency: "@hourly"
cluster_details: {columns: ["werks", "lgort"]}
- base_table: vbep
load_frequency: "@hourly"
- base_table: vbfa
load_frequency: "@hourly"
- base_table: vbpa
load_frequency: "@hourly"
- base_table: vbrk
load_frequency: "@hourly"
- base_table: vbrp
load_frequency: "@hourly"
- base_table: mch1
load_frequency: "@daily"
- base_table: mska
load_frequency: "@weekly"
- base_table: mslb
load_frequency: "@weekly"
- base_table: msku
load_frequency: "@weekly"
- base_table: mkol
load_frequency: "@weekly"