[Blocked] Write an Athena Query to split out 'fixed' compute cost

[yuvipanda]

Based on #4465, we're going to be using AWS Athena to query billing data

For this task, we need to write an SQL query that provides these 4 columns as output

• start_time
• end_time
• cost

This should count:

• EC2 costs with 2i2c:node-purpose set to core
• EKS master server costs (filtered by EKS cluster name)
• Disks in our support namespace (tagged by kubernetes.io/created-for/pvc/namespace (support) and kubernetes.io/cluster/openscapeshub set to owned)

Definition of done

1. SQL query when executed provides information for all 3 hubs on the openscapes cluster
2. The total cost is reasonably flat through time

Resources

• Query Editor
• Workshop with example Athena SQL queries against billing data - https://wellarchitectedlabs.com/cost-optimization/cur_queries/
• Data dictionary for columns in billing export

[consideRatio]

Preliminary closed, but can be reopened if Athena becomes relevant.