You can use workgroups in Amazon Athena to isolate and manage queries for different users, teams, or applications. You can configure each workgroup with specific settings, such as default S3 output locations and encryption options, to control how queries are processed and results are stored.
When you create an Amazon Athena connection, you can specify a workgroup in the Amazon Athena JDBC URL
Consider the following guidelines when you use workgroups in Amazon Athena:
•When you use a workgroup with customer managed query results, you manage the storage for your queries and keep the results as long as you require.
To use a workgroup with customer managed query results, you must specify at least one of the two parameters in the JDBC URL, either the S3 output location where you want to save the query results or the name of a workgroup with a preconfigured default S3 output location.
To override the S3 output location and encryption settings specified in the JDBC URL, enable the Override client-side settings property when you create a workgroup with customer managed query results in Amazon Athena.
•When you use a workgroup with Athena managed query results, Amazon Athena manages the storage for your queries and retains query results for 24 hours.
To use a workgroup with Athena managed query results, specify only the workgroup name and do not include the S3 output location in the JDBC URL.