Cloud intelligence dashboards are not showing data for all accounts.
Hi,
I have followed the documentation as mentioned in link. But I'm not getting all accounts data in dashboard, its showing data only for destination account. As i can't use/access management account so I'm getting all my individual accounts data(creating cur and storing into s3) and storing to one destination account like below.
s3://cur-buck****/account/SourceAccount1/cur/cur/year=2023/month=3/0001.snappy.parquet
s3://cur-buck****/account/SourceAccount2/cur/cur/year=2023/month=3/0001.snappy.parquet
s3://cur-buck****/account/SourceAccount3/cur/cur/year=2023/month=3/0001.snappy.parquet
s3://cur-buck****/account/DestinationAccount1/cur/cur/year=2023/month=3/0001.snappy.parquet
I'm crawling location s3://cur-buck****/account/ in crawler s3. My dashboards were deployed successfully and working well but i'm getting only data for destination account. Account_map view is also giving 1 entry of destination account. I'm unable to get other accounts data even in athena query.
Please help , I still not able to get this CURBucketPath path when we have multiple accounts. May be i have added wrong prefix while creating stack via CFN.
Thanks!
- Newest
- Most votes
- Most comments
Hello, is your CURBucketPath = s3://cur-buck****/account/ ? was it like that from the first installation? As it is mentioned in the doc:
Please note that CURBucketPath parameter currently cannot be updated once the stack is created. If you need to change it you can delete and re-create the stack.
So i would recommend to delete and re-create the stack with the parameter CURBucketPath = s3://cur-buck****/account/
Hello,
I understand that you have followed the document https://wellarchitectedlabs.com/cost/200_labs/200_cloud_intelligence/cost-usage-report-dashboards/dashboards/deploy_dashboards/ to configure the Cloud intelligence dashboards but the data is not showing up for all the accounts but only showing up for the destination account.
Since there is no visibility to the resource this issue might occur if the partitions are not loaded correctly after the crawler ran or as you mentioned if you have added wrong prefix while creating stack via CFN.
Fo partitioned table you can check if the partitions are loaded successfully by running the “SHOW PARTITIONS table_name” query in Athena or can run the “SHOW CREATE TABLE table_name” query in Athena to check the location where the table is pointing to get the results and see if its pointing to the right location path.
You can also try Alternative Methods for Deploying the CUR-based Cloud Intelligence Dashboards using CLI or manual deployment by following the steps as mentioned in the below: https://wellarchitectedlabs.com/cost/200_labs/200_cloud_intelligence/cost-usage-report-dashboards/dashboards/alternative_deployments/
Relevant content
- asked a year ago
AWS OFFICIALUpdated 5 months ago- AWS OFFICIALUpdated 9 months ago
- AWS OFFICIALUpdated 10 months ago
- AWS OFFICIALUpdated a year ago
Thanks Iakov, delete and recreate stack picked new other accounts data. Data is showing in account_map view also. But how can i update account names ? It's only showing account id. Do i need to update it manually ? If i need to add new account directory in s3 account in future will it be mapped automatically and data will be there in dashboard or i need to again recreate stack ? Please suggest. Thanks again.
Hey, thanks for update.
Today Account Names are not in CUR there are several ways how you can populate Account map automatically https://wellarchitectedlabs.com/cost/200_labs/200_cloud_intelligence/cost-usage-report-dashboards/dashboards/post_deployment_steps/#add-your-account-names-to-your-dashboard
If you have a big org with dynamically created accounts i would suggest you follow option 3 to set up automatic data collection across all payer accounts. This lab will also help you collecting TA and Compute Optimizer data across all payers.