finops-toolkit
finops-toolkit copied to clipboard
[Cost Management] FOCUS datasets do not include seconds in dates
đ Problem
FOCUS date columns are formatted without seconds when they should include seconds.
Actual/Expected | Value |
---|---|
Actual | yyyy-MM-ddTHH:mmZ |
Expected | yyyy-MM-ddTHH:mm:ssZ |
This impacts the following columns:
- BillingPeriodStart/End
- ChargePeriodStart/End
- x_BillingExchangeRateDate
- x_ServicePeriodStart/End
đŖ Repro steps
- Export FOCUS cost details (any version)
- Review any of the date columns
- Note they are missing the seconds
đ¤ Expected
All dates should be formatted with seconds (yyyy-MM-ddTHH:mm:ssZ
).
âšī¸ Additional context
Wikipedia says that seconds are optional. We need to confirm with the actual ISO 8601 specification.
Regardless, we have received a report that not having seconds is breaking parsing in some database engines. Due to this, the Cost Management team is working on a fix.
đââī¸ Ask for the community
We could use your help:
- Please vote this issue up (đ) to prioritize it.
- Leave comments to help us solidify the vision.