내용으로 건너뛰기

Error when deploying AWS Health Events Dashboard

0

Hi,

We are deploying AWS health events dashboard in our payer account. Followed the pre-requisites in https://catalog.workshops.aws/awscid/en-US/dashboards/advanced/health-events/prerequisites

In step 2 Data Collection, we run the Management Stack on our payer account/management account. Did not run the Data Collection Stack.

Athena is configured with workgroup name and enquires are configured to save it to S3 bucket. After that we run the deployment steps in https://catalog.workshops.aws/awscid/en-US/dashboards/advanced/health-events/deployment

Encountered this error below - 'xxxxxxxxxxxx.optimization_data.health_events_detail_data' does not exist after running the commands below. Would like to check if we miss out any steps for the implementation? And how do resolve this issue? Appreciate any support for this.

===================================================================

=================================================================== Looking by DataSetId defined in template...complete

There are still 1 datasets missing: health_events_view Creating dataset: health_events_view

[athena-workgroup] Select Amazon Athena workgroup to use: CID

[quicksight-datasource-id] Please choose DataSource (Select the first one if not sure): CID-CMD-Athena CID-CMD-Athena (workgroup=CID)

[athena-database] Select AWS Athena database to use: cid_cur Detected views: account_map Missing views: health_events_view {'account_id': 'xxxxxxxxxxxxx'}

[data-collection-database-name] Required parameter: data_collection_database_name (Enter the name of the data collection database): optimization_data {'account_id': 'xxxxxxxxxxxxxx'}

[table-name] Required parameter: table_name (Enter the name of the health events table (do not alter)): health_events_detail_data CRITICAL - Athena query failed: line 34:6: Table

'xxxxxxxxxxxxxx.optimization_data.health_events_detail_data' does not exist

===================================================================

Thank you Regards Ross

질문됨 2년 전742회 조회

1개 답변
0
수락된 답변

It looks like you're encountering an issue where the required Athena table health_events_detail_data does not exist in the specified database optimization_data. This usually indicates that the data collection stack, which is responsible for creating and populating this table, has not been run or has not completed successfully.

Check Cloudformation outputs and error to check what is going wrong

전문가

답변함 2년 전

전문가

검토됨 2년 전

  • Hi Giovanni Lauria,

    Thanks for ur advice. Run the data collection stack and the setup was successful

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.