Question

A SysOps administrator needs to provide the finance team with the ability to run ad-hoc SQL queries that break down AWS spend by specific resource tags, individual line items, and hourly usage across all linked accounts in an organization. Cost Explorer's predefined views do not offer the granularity finance requires. Which solution provides this level of detail most effectively?

Accepted Answer

Enable the AWS Cost and Usage Report (CUR) with resource IDs and hourly granularity, deliver it to an S3 bucket, and query it with Amazon Athena.

Answer

Create multiple AWS Budgets with cost filters for each tag and monitor the budget dashboards.

Answer

Use Cost Explorer's monthly granularity reports and export the CSV files for manual analysis in a spreadsheet.

Answer

Enable detailed billing metrics in CloudWatch and build a dashboard grouped by resource tags.