Lightup Community

Ask a Question

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?

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?

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?
ANSWERED
ANSWERED