TAO Dashboard deployment failed (table `ta_organizational_view_reports` doesn't exist)

Question

I'm trying to create a TAO Dashboard following the steps in [TAO DASHBOARD DEPLOYMENT - Option 3: CloudFormation Deployment](https://wellarchitectedlabs.com/cost/200_labs/200_cloud_intelligence/trusted-advisor-dashboards/dashboards/3_deployment/#option-3-cloudformation-deployment).

I'm executing the CloudFormation template from Terraform, and I get the following error:
```
"The following resource(s) failed to create: [taoQuickSightDataSet]. Rollback requested by user." 
"Resource handler returned message: \"SYNTAX_ERROR: line 3:6: Table awsdatacatalog.athenacurcfn_billing_cur_report_definition.ta_organizational_view_reports does not exist [Execution ID:..."
```

The DB `athenacurcfn_billing_cur_report_definition` already exists (it was created some time ago, during the deployment of CID & CUDOS dashboards).

The table `ta_organizational_view_reports` **does not exist**. However, in the lab instructions it's stated:  
> 6. Update your Athena Database Name with the name of the CUR Athena Database where you want to deploy table for TA reports. Leave default if you are not sure which database name provide

I understand the table will be created by the CloudFormation template ([tao.cfn.yml](https://aws-well-architected-labs.s3.us-west-2.amazonaws.com/Cost/Labs/200-cloud-intelligence-dashboards/tao.cfn.yml)).

Is my understanding wrong?

Accepted Answer

Problem turned out to be in the template itself. I've been using the template found in:  
https://aws-well-architected-labs.s3.us-west-2.amazonaws.com/Cost/Labs/200-cloud-intelligence-dashboards/tao.cfn.yml  
As indicated in lab:  
https://wellarchitectedlabs.com/cost/200_labs/200_cloud_intelligence/trusted-advisor-dashboards/dashboards/3_deployment/#option-3-cloudformation-deployment

Later I used the template located in GitHub repository:  
https://github.com/aws-samples/aws-cudos-framework-deployment/ 
Specifically, the release `0.2.3`.

This template is exactly the same than the other one, but it changes the table name:  
Old: `Name: ta_organizational_view_reports`.   
New: `Name: !Join [ '' , [ !FindInMap [ "Definitions", "taoAthenaTable", "Value" ] ,  !Ref taoSuffix ] ]`.

With this template, TAO dashboard was deployed successfully.

Answer

Hello,

Currently the TA Orginizational view is only supported in the Manual report generation method, as mentioned in the previous step for Create and uploading  the [Trusted Advisor Report](https://wellarchitectedlabs.com/cost/200_labs/200_cloud_intelligence/trusted-advisor-dashboards/dashboards/2_create-upload-ta-report/  
) under the " Trusted Advisor Organizational View" dropdown

Please attempt to re-deploy your TA Orginizational report by using the [manual deployment ](https://wellarchitectedlabs.com/cost/200_labs/200_cloud_intelligence/trusted-advisor-dashboards/dashboards/3_deployment/#option-1-manual-deployment)method.

TAO Dashboard deployment failed (table `ta_organizational_view_reports` doesn't exist)

関連するコンテンツ