Managing groups of users with Amazon Athena workgroups

Athena workgroups are a powerful mechanism for separating different groups and types of user queries (such as SQL based queries, and Spark Notebook queries), for applying cost controls, assigning provisioned capacity, and for implementing strong governance on Athena usage.

All queries within Athena are run in a specific workgroup, and you can apply a number of configuration settings to each workgroup to control costs and governance for the users in that workgroup. The following list shows the configuration items that can be controlled at the workgroup level:

• The analytic engine that users in this workgroup use (either Athena SQL or Apache Spark)
• Whether the Athena engine version used for this workgroup is selected and upgraded automatically, or whether you manually specify the engine version to use
• The S3 location where the results of queries are written to, and whether these files are encrypted or...