Cost Allocation Score

-- Finitizer: one month of AWS CUR 2.0, summed by day, for the
-- billing tools on tools.finitizer.com. Run it in Amazon Athena, then
-- "Download results" (CSV). Usually a few MB instead of the raw export.
-- Resource IDs and the billing entity are kept: the allocation score needs them.
-- If the table is partitioned by billing_period, also add
--   AND billing_period = '2026-09'
-- to the WHERE clause: Athena then reads only that month.
SELECT
  date_format(date_trunc('day', line_item_usage_start_date), '%Y-%m-%dT00:00:00Z') AS line_item_usage_start_date,
  line_item_line_item_type,
  bill_billing_entity,
  line_item_usage_account_id,
  line_item_product_code,
  product_servicecode,
  line_item_usage_type,
  line_item_operation,
  product_region_code,
  line_item_resource_id,
  pricing_term,
  pricing_unit,
  line_item_currency_code,
  json_format(CAST(resource_tags AS JSON))                  AS resource_tags,
  savings_plan_savings_plan_a_r_n,
  savings_plan_offering_type,
  savings_plan_end_time,
  reservation_reservation_a_r_n,
  reservation_end_time,
  date_format(max(line_item_usage_end_date), '%Y-%m-%dT%H:%i:%sZ') AS line_item_usage_end_date,
  sum(line_item_usage_amount)                               AS line_item_usage_amount,
  sum(line_item_unblended_cost)                             AS line_item_unblended_cost,
  sum(pricing_public_on_demand_cost)                        AS pricing_public_on_demand_cost,
  sum(savings_plan_savings_plan_effective_cost)             AS savings_plan_savings_plan_effective_cost,
  sum(savings_plan_total_commitment_to_date)                AS savings_plan_total_commitment_to_date,
  sum(savings_plan_used_commitment)                         AS savings_plan_used_commitment,
  sum(reservation_effective_cost)                           AS reservation_effective_cost,
  sum(reservation_unused_amortized_upfront_fee_for_billing_period) AS reservation_unused_amortized_upfront_fee_for_billing_period,
  sum(reservation_unused_recurring_fee)                     AS reservation_unused_recurring_fee
FROM cur_database.cur2_table
WHERE line_item_usage_start_date >= TIMESTAMP '2026-09-01 00:00:00'
  AND line_item_usage_start_date <  TIMESTAMP '2026-10-01 00:00:00'
GROUP BY 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19
ORDER BY 1;