Creating health_events_view fails in cid-cmd due to SQL query issue

aws-samples / aws-cudos-framework-deployment

Command Line Interface tool for Cloud Intelligence Dashboards deployment

https://catalog.workshops.aws/awscid

MIT No Attribution

372 stars 138 forks source link

Creating health_events_view fails in cid-cmd due to SQL query issue #855

Closed frankrosano closed 6 days ago

frankrosano commented 1 week ago

I was attempting to deploy the new Health Events Dashboard with cid-cmd in my environment however the automated Athena view creation fails due to a syntax issue with the query. Error:

CRITICAL - InvalidRequestException: An error occurred (InvalidRequestException) when calling the StartQueryExecution operation: line 1:27: mismatched input '-'. Expecting: 'AS', 'COMMENT', 'SECURITY', 'WITH'

Screenshot of error:

Attempting to run the query manually in Athena results in the same error:

iakov-aws commented 6 days ago

Thanks for the reporting and contribution! Merged. Will be released soon.