add workgroup support for Athena named query

[paulhudson]

Community Note

• Please vote on this pull request by adding a 👍 reaction to the original pull request comment to help the community and maintainers prioritize this request
• Please do not leave "+1" comments, they generate extra noise for pull request followers and do not help prioritize the request

Fixes #8016

Release note for CHANGELOG:

Adds optional `workgroup` argument to athena_named_query resource.

Output from acceptance testing:

$ make testacc TESTARGS='-run=TestAccAWSAthenaNamedQuery'
==> Checking that code complies with gofmt requirements...
TF_ACC=1 go test ./... -v -parallel 20 -run=TestAccAWSAthenaNamedQuery -timeout 120m
?   	github.com/terraform-providers/terraform-provider-aws	[no test files]
=== RUN   TestAccAWSAthenaNamedQuery_basic
=== PAUSE TestAccAWSAthenaNamedQuery_basic
=== RUN   TestAccAWSAthenaNamedQuery_withWorkGroup
=== PAUSE TestAccAWSAthenaNamedQuery_withWorkGroup
=== RUN   TestAccAWSAthenaNamedQuery_import
=== PAUSE TestAccAWSAthenaNamedQuery_import
=== CONT  TestAccAWSAthenaNamedQuery_basic
=== CONT  TestAccAWSAthenaNamedQuery_import
=== CONT  TestAccAWSAthenaNamedQuery_withWorkGroup
--- PASS: TestAccAWSAthenaNamedQuery_basic (81.90s)
--- PASS: TestAccAWSAthenaNamedQuery_withWorkGroup (82.52s)
--- PASS: TestAccAWSAthenaNamedQuery_import (85.07s)
PASS
ok  	github.com/terraform-providers/terraform-provider-aws/aws	85.186s

[bflad]

Hi @paulhudson 👋 Thanks for contributing this. Its off to a good start, just a few little things and we should be able to get this in. Please reach out if you have any questions or do not have time to implement the feedback.

[bflad]

Thank you for those updates as they helped uncover a regression that could have been merged in. Please see the below two small items to fix this up and once the acceptance testing is passing again this is good to go. Thanks!

[bflad]

Looks great, thanks, @paulhudson 🚀

--- PASS: TestAccAWSAthenaNamedQuery_withWorkGroup (25.40s)
--- PASS: TestAccAWSAthenaNamedQuery_basic (25.47s)
--- PASS: TestAccAWSAthenaNamedQuery_import (25.83s)

[nywilken]

The enhancement to the aws_athena_named_query resource, has been released in version 2.20.0 of the Terraform AWS provider. Please see the Terraform documentation on provider versioning or reach out if you need any assistance upgrading.

For further feature requests or bug reports with this resource, please create a new GitHub issue following the template for triage. Thanks!

[ghost]

I'm going to lock this issue because it has been closed for 30 days ⏳. This helps our maintainers find and focus on the active issues.

If you feel this issue should be reopened, we encourage creating a new issue linking back to this one for added context. Thanks!