Level 300: Organization Data CUR Connection

Last Updated

December 2020


  • Stephanie Gooch, Commercial Architect (AWS)


If you wish to provide feedback on this lab, there is an error, or you want to make a suggestion, please email: costoptimization@amazon.com


This lab will show you how to combine your organizations information with your AWS Cost & Usage Report, this will enable you to view cost & usage in a way that is more relevant to your organization. It will guide you through the process of setting up an AWS Lambda function to extract the data from AWS Organizations, such as account ID and name, and place it into Amazon S3. From there, Amazon Athena will be able to read this data to produce a table that can be connected to your AWS Cost & Usage Report to enrich it. There is also a Bonus part to the lab where you can pull organization tags that are on account into the data set.




  • Combine your AWS Organizations information with your CUR
  • Allows you to view costs against accounts with names you provide enriching the data


Permissions required

Be able to create the below in the management account:

  • IAM role and policy

Be able to create the below in a sub account where your CUR data is accessible:

  • Amazon S3 Bucket
  • AWS Lambda function
  • IAM role and policy
  • Amazon CloudWatch trigger
  • Amazon Athena Table



Time to complete

  • 30 minutes


If you wish to deploy this in your AWS Management Account instead of a Member Account then there is a seporate code version which can do this. You do not have to make the IAM Role and Policy made in the Managment account in the next step.