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.
ASK INFAPreview
