View 5 - RI SP Mapping

This view will be used to create the RI SP Mapping dashboard page. Use one of the following queries depending on whether you have Reserved Instances, or Savings Plans.

Create View

  • Click here - if you have both Savings Plans and Reserved Instances
  • Click here - if you have Savings Plans, but do not have Reserved Instances
  • Click here - if you have Reserved Instances, but do not have Savings Plans
  • Click here - if you do not have Reserved Instances, and do not have Savings Plans

Validate View

  • Confirm the view is working, run the following Athena query and you should receive 10 rows of data:

      select * from costmaster.ri_sp_mapping
      limit 10