Cost intelligence dashboard does not reflect the usage data of newly added child account

Question

We had deployed a CID for one of our customer. The setup is 1 management account and it has 3 child accounts.

The data was reflecting fine until recently we onboarded a new child account under the same management account. Now the customer is unable to see the data of the usage of the recently added account in CID.

The account is seen in the drop down but all the other fields in CID is blank. We tried to refresh the data from datasets in Quicksight, we also checked if the usage in cost explorer, the usage is reflecting fine in cost explorer/billing dashboard.

How can we check where is the problem? 
Account is reflecting in CID but no data
the usage is reflecting in Cost explorer without issues
All 3 accounts which were there when the CID was deployed are working fine..

Is there any process to onboard a new account to reflect the data in CID?

Answer

Since you mentioned you already refreshed the dataset in QuickSight, I would rule out it being a data refresh issue. What if you run a query in Athena to see if there is any data for the new account? You can just use this query as an example

https://www.wellarchitectedlabs.com/cost/300_labs/300_cur_queries/queries/global/#service

Answer

I suggest to check:
1. If the data for that account in customer_all table:

```
select * from customer_all
where line_item_account_id = {account id}
limit 100
```
2. If data is there, check the same for summary_view
3. If data is not in the customer_all table. Check that recent months among the partitions in the Glue table called cid (might have different name).

Answer

Need to find out whether is a data issue or presentation issue within the CID dashboard, which is why I recommended to directly query the data to see if any CUR data exists for the newly added account. Do you recall which option was used for Account Map mentioned here https://wellarchitectedlabs.com/cost/200_labs/200_cloud_intelligence/cost-usage-report-dashboards/dashboards/code/0_view0/? You mentioned you see the new account under the drop down. Are you seeing the account ID or the account name?

Answer

Hi We tried to run the query in Athena to check if the account has data. we got the data But to query the summary table he is missing some permission.

What could be the next step?

Cost intelligence dashboard does not reflect the usage data of newly added child account

Relevant content