Back to results for “Amazon Athena”
AWS › Amazon Athena

How do Athena workgroups help manage query costs and access control across teams?

Advanced

Answer

Athena workgroups let you separate queries run by different teams or applications, each with its own query result location, data scan limits, and cost tracking, so an organization can enforce spending limits per team and monitor usage separately, preventing one team's expensive queries from affecting the budget visibility of another.
aws athena create-work-group --name 'MarketingTeam' --configuration BytesScannedCutoffPerQuery=1000000000
Real-world example A large enterprise creates separate Athena workgroups for its finance and marketing teams, setting a data scan limit on the marketing workgroup to prevent runaway costs from accidental large queries.

Common follow-ups: How do you set a per query data scan limit in a workgroup?;Can workgroups enforce which S3 bucket stores query results?