Lightup Community
Getting error for a slicing based query
I'm getting the following error when I update and restart my LightUp metric and monitor:
```
Metric collection paused due to an exception
Please review the SQL. Duplicate timestamp (epoch in seconds) in
row {"CNT_ERR": 745, "event_ts": 1706508000} and
row {"CNT_ERR": 7180, "event_ts": 1706508000}
```
Can anyone help out on how to fix the issue?
Posted by Keshav Bohra about 2 months ago
How to configure percent change thresholds for a monitor?
I'm trying to add a monitor to alert when the total count of records drops by 3% in a day - how would I configure the thresholds to accomplish this?
Posted by Claire W 6 months ago
Usage of different TIMEZONE in SQL Metric
I have 3 questions here. PFB the same:
1. What is the exact use of **AGGREGATION TIMEZONE** while creating SQL Metrics(Step 2- Configure Metric)? Actually in the data I have the timestamp in EST. How does adjusting this variable impact the final graph?
2. What is the exact use of **TIMEZONE **while creating SQL Metrics(Step 2- Configure Metric) in the Partitions Section? My partition is also in EST, so will the graph here be impacted if I set it to EST?
3. In step 3-Preview, we can select the starting and ending timestamps. Could you please confirm this will be in which timezone?
Posted by Goutam Das 11 months ago
What about the umpteen data quality dimensions?
In Lightup, there are three main data quality dimensions: Completeness, Accuracy, and Timeliness. But what about the other DQ Dimensions that exist like consistency, validity, and uniqueness?
Posted by Bryan Feuling 12 months ago