[Blocked] Write an Athena Query to split out per-hub 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
• hub_name
• cost

The hub name should count EC2 costs tagged with 2i2c:hub-name

What goes into this query should be guided by item 2 of definition of done below.

Definition of done

1. SQL query when executed provides information for all 3 hubs on the openscapes cluster
2. If you add the cost values for all the hubs, they must add up to what shows up under 'EC2' in 'Cost Explorer' under 'Billing' in the AWS console, minus EC2 costs for core nodes (determined by filtering out tags 2i2c:node-purpose core).

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.