Cost and Usage Report

# CUR S3 path structure
# s3://{bucket}/{prefix}/{report-name}/{date-range}/{assemblyId}/{report-name}-{number}.csv.gz

# Example with Parquet format and Athena integration
s3://my-billing-bucket/cur/MyReport/20240501-20240601/
  ├── 01/
  │   └── MyReport-00001.snappy.parquet
  ├── MyReport-Manifest.json     # describes the files in this delivery
  └── crawler-cfn.yml            # optional CloudFormation for Glue crawler

# The manifest JSON tells downstream tools what files are in this report period
# Always use the manifest to discover CUR files programmatically

-- Total cost by service for the current month
SELECT
  line_item_product_code AS service,
  SUM(line_item_unblended_cost) AS total_cost
FROM cur_database.cur_table
WHERE
  line_item_usage_start_date >= DATE_TRUNC('month', CURRENT_DATE)
  AND line_item_line_item_type NOT IN ('Tax', 'Credit', 'Refund', 'SavingsPlanNegation')
GROUP BY 1
ORDER BY 2 DESC;

-- Cost per resource for EC2, with tags
SELECT
  line_item_resource_id AS resource_id,
  resource_tags_user_environment AS environment,
  resource_tags_user_team AS team,
  SUM(line_item_unblended_cost) AS monthly_cost
FROM cur_database.cur_table
WHERE
  line_item_product_code = 'AmazonEC2'
  AND year = '2024'
  AND month = '5'
  AND line_item_line_item_type = 'Usage'
GROUP BY 1, 2, 3
ORDER BY 4 DESC
LIMIT 100;

-- Daily cost trend for the last 30 days
SELECT
  DATE_TRUNC('day', line_item_usage_start_date) AS usage_date,
  SUM(line_item_unblended_cost) AS daily_cost
FROM cur_database.cur_table
WHERE
  line_item_usage_start_date >= CURRENT_DATE - INTERVAL '30' DAY
  AND line_item_line_item_type NOT IN ('Tax', 'Credit')
GROUP BY 1
ORDER BY 1;

# CUR is configured in AWS Billing console or via API
# aws cur put-report-definition (must run in us-east-1)

aws cur put-report-definition \
  --region us-east-1 \
  --report-definition \
  "ReportName=my-cur-report,
   TimeUnit=HOURLY,
   Format=Parquet,
   Compression=Parquet,
   AdditionalSchemaElements=[RESOURCES,SPLIT_COST_ALLOCATION_DATA],
   S3Bucket=my-billing-bucket,
   S3Prefix=cur,
   S3Region=us-east-1,
   AdditionalArtifacts=[ATHENA],
   RefreshClosedReports=true,
   ReportVersioning=OVERWRITE_REPORT"