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

If there is any EFS cost that isn't assigned to a hub, that should also be reported.

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 'Elastic File System' in 'Cost Explorer' under 'Billing' in the AWS console.

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.