This template updates an existing Amazon Athena workgroup with the specified name, description, state, and configuration updates. The workgroup enables you to isolate queries for you or your group from other queries in the same account.
A collection of configuration templates for Amazon Athena as well as security controls for monitoring and protecting Amazon Athena configuration such as Config Rules, CloudWatch Alarms, EventBridge Rules, IAM policies, and more.
This template creates an Amazon Athena saved query. The query selects all aggregated data from the 'swfmetadata' database. The query is named 'MostExpensiveWorkflow' and it calculates the average workflow time for each workflow name. The results are ordered in descending order by the average workflow time and limited to the top 10 results.