Hello Elementary team! Can anyone help me understa...
# community-supportl
Larissa Mendes Hermogenes Rocha
06/18/2024, 5:17 PMHello Elementary team! Can anyone help me understand the freshness dashboard for the table bellow, the freshness metric for today bucket is equal 3,070, but I can't figure out where does this number come from, I expected the freshness to be "the expected time between data updates" , however the last update is "2024-06-17 064507.672000" but I have rows from today 2024-06-18 in my table, how does Elementary gets last update? thanks 🥺
Larissa Mendes Hermogenes Rocha
06/18/2024, 5:18 PM Copy code
- elementary.freshness_anomalies:
severity: warn
timestamp_column: "__source_ts_ms"Larissa Mendes Hermogenes Rocha
06/18/2024, 5:18 PM Copy code
time_bucket:
period: day
count: 1Larissa Mendes Hermogenes Rocha
06/21/2024, 2:22 PMHi everyone! about this, just figured it out, the freshness metric displayed on the chart (in my example 3,070) is the highest freshness value of the bucket (day), which is calculated as the seconds passed between two consecutive values of the timestamp column. The value presented as last updated is not the "last updated" really, it's the anomaloys timestamp, it is, the point in time when the bucket highest freshness was reported. I found a bit confusing calling it "last update" in the screen...
Larissa Mendes Hermogenes Rocha
06/21/2024, 2:22 PMI hope it helps anyone else facing the same questions
10 Views