Athena Query for Carbon footprint data

[Cameron Drotsky]

Hi all, 

Struggling to get this query to run:

SELECT
line_item_product_code as serviceName,
product_region as region,
line_item_usage_type as usageType,
pricing_unit as usageUnit,
product_vcpu as vCpus
FROM <your-cost-and-usage-reports-table>
WHERE line_item_line_item_type IN ('Usage', 'DiscountedUsage', 'SavingsPlanCoveredUsage')
AND line_item_usage_start_date >= DATE('YYYY-MM-DD')
AND line_item_usage_start_date <= DATE('YYYY-MM-DD')
GROUP BY 1, 2, 3, 4, 5
Keep getting this error: INVALID_CAST_ARGUMENT: Value cannot be cast to date: YYYY-MM-DD

Please could anyone assist if they managed to figure this out?

[Cloud Carbon Footprint]

Hi Cameron,

It looks like you may have to replace the YYYY-MM-DD with the actually start dates that you need to use. We could consider updating our documentation to reflect this. Please let us know if this helps!

Thanks,
The CCF Team at Thoughtworks

[Cameron Drotsky]

Thank you for the help! 

I think that would help, but only if there is capacity to do so!

Thanks again,

Cameron