Reputation: 32286
Here is a nice blog post explaining how to configure two workgroups for Athena. One for ad hoc users and another for automated reports.
Is there a cloudformation template to automate all the steps mentioned?
Upvotes: 3
Views: 1354
Reputation: 1069
At the time of your question, Athena Workgroups creation using AWS CloudFormation was not supported. Recently, Amazon Athena added support for managing Athena Workgroups using AWS CloudFormation (03/13/2020). You can use AWS::Athena::WorkGroup to create Athena Workgroups.
More details: https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-resource-athena-workgroup.html
Upvotes: 2