AWS Cost and Usage Report (CUR) Setup

Set up the Cost and Usage Report (CUR) to an S3 bucket for detailed billing. FCAI ingests CUR for precise insights and commitment planning.

Create an S3 bucket for CUR

• Dedicated bucket, versioning on, default encryption enabled.
• Block public access; lifecycle to expire old manifests if needed.

Enable CUR

1. Billing Console → Cost & Usage Reports → Create report.
2. Time granularity: Hourly. Report versioning: Overwrite or Create new.
3. Compression: Parquet recommended. S3 path: s3://<bucket>/cur/.
4. Include resource IDs; enable Split cost allocation data if using cost categories.

Query CUR with Athena

1. In the billing console, create the Athena table from your CUR.
2. Set workgroup with query result encryption and limits.
3. Example query: Monthly cost by service and account.

SELECT
  bill_payer_account_id,
  line_item_usage_start_date::date AS day,
  product_product_name AS service,
  SUM(line_item_blended_cost) AS blended_cost
FROM cur
WHERE year = '2025' AND month = '10'
GROUP BY 1,2,3
ORDER BY 2,3;

Visualize with QuickSight

• Connect QuickSight to Athena. Create dashboards for cost, usage, and unit metrics.
• Use parameters for account, env, and application tags.

FCAI integration

• FCAI can read CUR securely from your S3 and surface:
  • Idle/underutilized resources
  • Savings Plans and RI coverage and utilization
  • Anomaly context and owners (via tags)

Need help automating CUR ingestion? Contact FCAI Support.