CUR query for using split cost allocation data

Question

Hi - Can you share a CUR query for how to use tags on the scad data ? I have all my resources tagged using Cost Allocation Tags, and I would like to see how to use my tags to report on containerized application costs . There are some queries in well architected labs on how to generate amortized costs based on data in the CUR; but nothing on scad

Answer

Hi, Sara

This example assumes you want to filter and aggregate costs for a containerized application identified by a specific tag key-value pair, such as `App:ContainerizedApp`.

```sql
   SELECT
       line_item_usage_start_date,
       line_item_usage_end_date,
       product_product_name,
       SUM(line_item_blended_cost) AS total_cost
   FROM
       your_cur_table_name
   WHERE
       tags['App'] = 'ContainerizedApp'
   GROUP BY
       line_item_usage_start_date,
       line_item_usage_end_date,
       product_product_name
   ORDER BY
       line_item_usage_start_date;
   ```

> ℹ️ The example I provided is a SQL query that is specifically designed for use with Amazon Athena. SQL is the language used, and Athena is the service that allows you to run these SQL queries against data stored in Amazon S3, such as your AWS Cost and Usage Reports (CUR).

### Notes
- Make sure that the tag keys and values are correctly mentioned in the query.
- This query provides costs aggregated by service (product name) and by each billing period. You can customize it further to include other dimensions such as regions, specific services, etc.

> 💡 If you require a more detailed or customized breakdown, such as by specific resource IDs or more granular tagging, you would need to adjust the query accordingly.

---

Additional source:
- [Creating a Cost and Usage Reports status table](https://docs.aws.amazon.com/cur/latest/userguide/create-manual-cur-table.html)

Answer

Check out some sample queries from this workshop content - https://catalog.us-east-1.prod.workshops.aws/workshops/bbc63046-2f56-4d59-917b-d5ebc63bdcee/en-US/ecs-split-cost-allocation/query-ecs-data-in-cur

This was a workshop we ran at re:Invent - note that it's intended to be delivered at an AWS-hosted event, which is why at the beginning of the content it talks about the access to temporary accounts... You can skip the labs related to tagging and basic CUR setup (it seems like you have your tagging sorted, and your cost allocation tags are activated and available in CUR already).

Go to the Lab 3 that talks about SCAD for ECS. It talks a bit more about the requirements and how to query SCAD columns.
Note that this one only talks about ECS, but as you might have heard, we've just launched the same for EKS - https://aws.amazon.com/blogs/aws-cloud-financial-management/improve-cost-visibility-of-amazon-eks-with-aws-split-cost-allocation-data/ - so you can use similar queries.

Additionally, you can find information about SCAD line items and some explanation about them on the CUR documentation - https://docs.aws.amazon.com/cur/latest/userguide/split-line-item-columns.html

CUR query for using split cost allocation data

Notes

Relevant content