Add Timezone Parameter for Slack Report Summary

[Raghul-sys]

Is your feature request related to a problem? Please describe.
Currently, we send the run results at the end of a dbt run, using the -days-back 1 filter to select data from the last day. Our pipeline starts at 1:30 AM CEST. Before daylight saving time (DST) adjustments, this worked fine because all test runs fell within the new day. However, after DST, tests that run at 1:30 AM local time are still considered part of "yesterday" in UTC. As a result, when the Slack summary is sent, tests that ran before 2:00 AM local time do not appear in the report.

Describe the solution you'd like
Add a timezone parameter to adjust the reporting window dynamically based on the local timezone. For example:
edr send-report -ch <slack_channel> -st <slack_token> -timezone <timezone>
This would allow us to select the report summary for the correct time window, ensuring all test runs are included, even after DST changes.

Describe alternatives you've considered
Before the DST change, this issue did not exist, so we do not have a viable workaround at the moment.

Additional context
If there's already a hack or temporary fix available, please let me know. However, we prefer not to modify the timestamps of our elementary tables (loading timestamps), as our data is currently loaded in UTC by default.

Would you be willing to contribute this feature?
Yes, I would be happy to contribute!

[NoyaOffer]

Hey @Raghul-sys !
Happy to let you know that this already exists.
See the CLI docs and the timestamp config. Let me know if you think anything is missing.

[Raghul-sys]

Hi @NoyaOffer,

I can see that this is only available for alerts and not report summary, can you please confirm if that is the case?

Thank you!

[NoyaOffer]

You're right, this is the case. Let me check how much of an effort it would be to add this 🙂

[Raghul-sys]

Thank you, I would be interested to work in this feature. Let me know.

[NoyaOffer]

Thank you!
send-report includes both the summary and the report, and we don't currently support the timezone option for the report. Trying to think of a workaround - would an option to set --hours-back work better?

[Raghul-sys]

Got it. @NoyaOffer is it supported for summary? I am specifically looking for summary.

we don't currently support the timestamp option for the report.

My use case is, we are sending summary after our pipeline run (after 12 am). Due to day light saving change this is now impacted. I think --hours-back would not also help in this case since, it will pick up some test results from previous day/ or exclude it after day light saving change.

Thank you!

[Raghul-sys]

@NoyaOffer any thoughts on my previous message?

Thank you!