If your account is managed by an MSP and you don’t have access to the billing file, the MSP must complete the procedure in this article in order to retrieve the billing information. This procedure enables Eco to access your billing file and provide you with visibility into your cloud expenditures.
Cost and Usage Report Extraction Setup
There are three major steps to configuring the CUR Extraction:
Step 1. Set up Cost and Usage Reports: This should be done from a root user account.
Step 2. Link your Cost and Usage Report with Athena.
Step 3. Set up the Cost and Usage Extractor.
All actions in this procedure should be made in the US-East-1 (Northern Virginia) AWS region.
The IAM role should be the one of the end-customer master payer account.
Step 1: Set up Cost And Usage Reports
1. Log in to your root AWS account, then click here.
2. Click Create Report.
3. Under the first menu, Report Content, do the following:
i. For the report name, enter (i.e., paste) the following: “spotinst-cur-report”. You must use the same name for the S3 bucket name.
ii. Check the box that says “Include resource IDs”.
iii. Click Next.
4. Under the second menu, Delivery Options, do the following:
i. Under S3 Bucket, click Configure, then do the following:
a. For the name for the S3 bucket that CUR reports will be dumped into, paste in the following: “spotinst-cur-report”. This name must be the same as the report name that you entered previously.
b. Only change the bucket’s region if necessary.
c. Click Next.
d. Check the box that says “I have confirmed that this policy is correct”.
e. Click Save.
ii. Under Report Path Prefix, enter “spotinst_eco”.
iii. Under Time Granularity, enter Hourly.
iii. Under Enable report data integration for, check the box that says “Amazon Athena”.
iv. Click “next”.
v. The review screen should appear as shown below.
vi. Scroll all the way down and click Review and Complete.
Step 2: Link your Cost And Usage Report With Athena
It will take 24 hours for AWS to start dropping reports into the S3 bucket you chose. Before proceeding with this step, click here and make sure that “Data last refreshed” has a date and doesn’t say “N/A”. Here’s what it should look like:
1. Click here, go to the S3 bucket you chose and navigate to: spotinst_eco/spotinst-cur-report
2. Click on the file called “crawler-cfn.yml”.
3. Download the file and contact your Spotinst sales representative. (If you do not have a sales representative, contact Spotinst Support.) Please include the following in your email:
- The crawler file
- AWS account number of MSP
- Account ID of the customer’s master payer account
- CUR bucket name
- Stack name
- The customer’s Spotinst OrgIDs
Continue with the steps below.
4. Copy the “Object Url” at the bottom as shown in the image below.
5. Click here and paste that object url into the field “Amazon S3 URL” as shown in the image below.
6. Click Next.
7. Enter “Spotinst Eco Stack” and click Next.
8. Scroll all the way down and click Next again.
9. Scroll all the way down, and under the Capabilities section, mark the box that says “I acknowledge that AWS CloudFormation might create IAM resources.”
10. Click Create Stack.
11. Click here, and find the crawler you just created. The name will appear as follows: AWSCURCrawler-[name of your cur report]. Click on the crawler to bring up its properties.
12. Click Edit.
13. On the left side of the screen, click Schedule.
14. In the Frequency dropdown box, choose Daily.
15. For Start Hour (UTC), choose 00, and for Start Minute, choose 00.
16. Click Next, click Next again, scroll down, and click Finish.
Once you have sent the crawler.yml file, it may take up to 48 hours before you receive the link you need for Step 3.
Step 3: Set up Cost And Usage Extractor
1. Log into your AWS account, then click on the link provided by Spotinst.
2. On the CloudFormation page, click Next at the bottom right.
3. Some of the parameters have been filled in already. Do not change them. Fill in the following parameters:
i. Account List: You may leave this blank, but if you would like to send Cost and Usage reports only for certain account numbers, enter them into this field separated by commas. Do not add spaces.
ii. Stack Name: You can set this to a name you like.
iii. CURBucketName: Set this to the name of the S3 bucket that you chose in the previous steps for Cost and Usage Reports to write to.
4. Click Next. Scroll all the way down and click Next again.
5. Scroll all the way down and under the Capabilities section, check the box that says “I acknowledge that AWS CloudFormation might create IAM resources.”
6. The Review screen should appear as follows:
7. Click Create Stack.