+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ Solving problems using time travel
+Beryl @ Fifty
+ +Tomas Robertson (team ACE-OL) & Simeon Simeonov (team Forecasts)
+What is time travel???
++
Time travel - our ability to look at our input data at the state it was at a specific point in time (not only at its last state).
+Time travel is achieved by adding the record_created_time column to our DB tables and storing Kafka's created_time value (converted to UTC).
++
The main concepts around how and why were presented by Peter Sandberg.
+Solving problems
++
The following spike was observed 2021-10-06 around 10:15 CET @ NO4
+
+ Solving problems (cont)
++
No spikes shown in Grafana
+
+ Solving problems with time travel
++
+
+ SELECT record_created_time, start_time, value
+ FROM misc.app_odin_ace_ol_ba_10s_avro_v01
+ WHERE bidding_area_name = 'NO4' AND start_time = '2021-10-06 08:14:10'
+ ORDER BY record_created_time;
+
+
+
+ | record_created_time | +start_time | +value | +
|---|---|---|
| 2021-10-06 08:15:52.258 | +2021-10-06 08:14:10 | +-370.37683609008127 | +
| 2021-10-06 08:19:06.222 | +2021-10-06 08:14:10 | +25.183745117193457 | +
| 2021-10-06 08:21:56.207 | +2021-10-06 08:14:10 | +34.78731922151518 | +