-
Notifications
You must be signed in to change notification settings - Fork 0
/
jobs.txt
70 lines (68 loc) · 3.51 KB
/
jobs.txt
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
# Define jobs with their respective table names, composite key columns, and columns requiring Decimal conversion
#jobs_am
{"jobs": {
"a7f41b3e-2b81-488d-8ed0-1f8c236e1a54": {
"table_name": "channel_basic_a2",
"composite_key_cols": ["date", "channel_id", "video_id", "live_or_on_demand", "subscribed_status", "country_code"],
"decimal_cols": ["watch_time_minutes", "average_view_duration_seconds", "average_view_duration_percentage",
"red_watch_time_minutes"]
},
"4a7e6f19-e49f-4418-9800-f0ba979a8437": {
"table_name": "channel_demographics_a1",
"composite_key_cols": ["date", "channel_id", "video_id", "live_or_on_demand",
"subscribed_status", "country_code", "age_group", "gender"],
"decimal_cols": ["views_percentage"]
},
"bff80780-0f0f-4caa-af3e-de968ec64e9e": {
"table_name": "channel_sharing_service_a1",
"composite_key_cols": ["date", "channel_id", "video_id", "live_or_on_demand",
"subscribed_status", "country_code", "sharing_service"],
"decimal_cols": ["shares"]
},
"82bc9b78-afbf-470e-8c1f-e9a7d2fe280d": {
"table_name": "channel_combined_a2",
"composite_key_cols": ["date", "channel_id", "video_id", "live_or_on_demand",
"subscribed_status", "country_code", "playback_location_type",
"traffic_source_type", "device_type", "operating_system"],
"decimal_cols": ["views", "watch_time_minutes", "average_view_duration_seconds",
"average_view_duration_percentage", "red_views", "red_watch_time_minutes"]
}
},
"aws_region": "eu-central-1",
"secret_name": "YouTubeTokenInfo"
}
#FD
{"jobs": {
"ed9aa6dd-4917-49b1-9f1e-a18abb39a1a3": {
"table_name": "channel_basic_a2",
"composite_key_cols": ["date", "channel_id", "video_id", "live_or_on_demand", "subscribed_status", "country_code"],
"decimal_cols": ["watch_time_minutes", "average_view_duration_seconds", "average_view_duration_percentage",
"red_watch_time_minutes"]
},
"45c78df0-c439-4cb2-9000-290c63a7ffb1": {
"table_name": "channel_demographics_a1",
"composite_key_cols": ["date", "channel_id", "video_id", "live_or_on_demand",
"subscribed_status", "country_code", "age_group", "gender"],
"decimal_cols": ["views_percentage"]
},
"6db402c2-bd12-484e-b681-5b2c366a567e": {
"table_name": "channel_sharing_service_a1",
"composite_key_cols": ["date", "channel_id", "video_id", "live_or_on_demand",
"subscribed_status", "country_code", "sharing_service"],
"decimal_cols": ["shares"]
},
"aebc0c29-d56c-4ccb-85f1-63a9898f752c": {
"table_name": "channel_combined_a2",
"composite_key_cols": ["date", "channel_id", "video_id", "live_or_on_demand",
"subscribed_status", "country_code", "playback_location_type",
"traffic_source_type", "device_type", "operating_system"],
"decimal_cols": ["views", "watch_time_minutes", "average_view_duration_seconds",
"average_view_duration_percentage", "red_views", "red_watch_time_minutes"]
}
},
"aws_region": "eu-central-1",
"secret_name": "FD_TokenInfo"
}
# clean-up
{"tables": ["channel_basic_a2", "channel_demographics_a1",
"channel_sharing_service_a1", "channel_combined_a2"]}