With the current implementation of Azure RHEL/SWATCH, we will always miss data for the last-of-the-moth day.

The problem seems to be that when determining end_date for subs. processing for a given month, we identify the last day for which we have data in Trino and push this date one day back to prevent processing of days with incomplete data:

Provider.PROVIDER_AZURE: " SELECT coalesce(NULLIF(resourceid, ''), instanceid), date_add('day', -1, max(coalesce(date, usagedatetime))) ",  

Thus, the last day of the month will never be processed, because this day is the max possible date in Trino -> thus the max. possible end_date for subs. processing will always be last-day-of-the-month - 1