Comment
Author: Admin | 2025-04-28
To 24 hours for AWS to deliver the first report to your Amazon S3 bucket as shown below. Also, raise a support ticket in Service=Billing and category=Invoices and Reporting, requesting a backfill of your CUR (name=cid) with 12 months of data as that will help to show cost reports with historic and last 30 days data. Like the content ? Configure Athena If this is the first time you will be using Athena, then you need to configure an S3 bucket for storing the query results before you can start to make use of Athena service. Otherwise, please skip this section. Navigate to Athena service and configure the query result location in S3 as shown in the prompt below: Also, navigate to Workgroups and configure Query result location for your primary workgroup which will be used by Quicksight later. CUR & Athena Integration In step 1, when we had specified Amazon Athena as the Report data integration the CUR extract would automatically generate crawler-cfn.yml file in your CUR S3 bucket. This CF template file can be used load the CUR data to Athena for querying purposes. Upload crawler-cfn.yml to CloudFormation service and create the stack resources. This creates the following services: S3 event notification for the CUR S3 bucket Lambda service which kickstarts Glue crawler whenever new CUR data is available IAM roles with needed permissions Glue database Glue crawler to load the data to Athena Below you can see the CUR crawler lambda function which listens for events from your CUR S3 bucket. In Glue, you will see a crawler which will be invoked by above lambda and loads the data to Athena. Once your CUR extract is available in S3, the glue crawler loads the data and it will be available for query in Athena. You can see below the Athena data source, database and the tables. Like the content ? Enable Quicksight If you haven’t used Quicksight before in your account, you need to sign-up for Quicksight first. Please check for Quicksight pricing and Sign up for Quicksight by navigating to the Quicksight service. As part of
Add Comment