How to read historical data in CSV format from AWS Cost and Usage Report using Cloud Carbon Footprint?

[nosiop]

Description: I have some historical data(the amount of data is relatively large) that was generated without selecting Amazon Athena in the Report data integration option. I would like to know how to let CCF read the historical data in CSV format from AWS Cost and Usage Report using Cloud Carbon Footprint. Could someone please guide me on this issue? Or is this goal achievable?

[ericksod]

Hi @nosiop! Great question! You could definitely do this by writing a script to parse the csv and feed it into the AWS package. If you go this route, we would strongly recommend that you make a pr and we can help get this approved to be a new feature of CCF! For reference, it could likely look something like how we handle on-prem. The data for on-prem is put into a csv, consumed by ccf and run through the methodology for estimations. https://www.cloudcarbonfootprint.org/docs/on-premise

Another option could be to leverage the lookup table approach if you don't require a UI https://www.cloudcarbonfootprint.org/docs/creating-a-lookup-table

Let us know!