Manage workgroups
In the Athena console at https://console.aws.amazon.com/athena/
Statement | Description |
---|---|
Create a workgroup |
Create a new workgroup. |
View the workgroup's details | View the workgroup's details, such as its name, description, data usage limits, location of query results, expected query results bucket owner, encryption, and control of objects written to the query results bucket. You can also verify whether this workgroup enforces its settings, if Override client-side settings is checked. |
Specify a workgroup for queries |
Before you can run queries, you must specify to Athena which workgroup to use. You must have permissions to the workgroup. |
Switch workgroups |
Switch between workgroups to which you have access. |
Edit a workgroup | Edit a workgroup and change its settings. You cannot change a workgroup's name, but you can create a new workgroup with the same settings and a different name. |
Enable or disable a workgroup |
Enable or disable a workgroup. When a workgroup is disabled, its users cannot run queries, or create new named queries. If you have access to it, you can still view metrics, data usage limit controls, workgroup's settings, query history, and saved queries. |
Copy a saved query between workgroups | Copy a saved query between workgroups. You might want to do this if, for example, you created a query in a preview workgroup and you want to make it available in a nonpreview workgroup. |
Delete a workgroup |
Delete a workgroup. If you delete a workgroup, query history, saved queries, the workgroup's settings and per-query data limit controls are deleted. The workgroup-wide data limit controls remain in CloudWatch, and you can delete them individually. The primary workgroup cannot be deleted. |
Use IAM policies to control workgroup access | Use IAM policies to control workgroup access. For example workgroup policies, see Example workgroup policies. |
Create an Athena workgroup that uses IAM Identity Center authentication | To use IAM Identity Center identities with Athena, you must create an IAM Identity Center enabled workgroup. After you create the workgroup, you can use the IAM Identity Center console or API to assign IAM Identity Center users or groups to the workgroup. |
Configure minimum encryption for a workgroup | Enforce a minimal level of encryption in Amazon S3 for all query results from the workgroup. Use this feature to ensure that query results are never stored in an Amazon S3 bucket in an unencrypted state. |