View 1 - Summary View

This view is the main dataset used in the your dashboards and is the foundation view for your dashboard page. Use one of the following queries depending on whether you have Reserved Instances, or Savings Plans.

Create View

We recommend large customers with over 500 linked accounts or more than $10M a month in invoiced cost update the usage date field in the query from ‘day’ to ‘month’ for improved performance

This view is dependent on having or historically having an RDS database instance run in your organization. If you get the error that the column ‘product_database_engine’ or product_deployment_option does not exist, then you do not have any RDS database instances running. To make this column show up in the CUR spin up a database in the RDS service, let it run for a couple of minutes and in the next integration of the crawler the column will appear. You can verify this by running the Athena query: SHOW COLUMNS FROM tablename - and replace the tablename accordingly after selecting the correct CUR database in the dropdown on the left side in the Athena 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

Adding Cost Allocation Tags

Cost Allocation tags can be added to any views. We recommend adding while creating the dashboard to eliminate rework.

Click here - to add your cost allocation tags

Validate View

  • Confirm the view is working, run the following Athena query and substitute (database) for your CUR database and you should receive 10 rows of data:

     select * from (database).summary_view
     limit 10