r/athena_database - add properties + import support

[DrFaust92]

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" or other comments that do not add relevant new information or questions, they generate extra noise for pull request followers and do not help prioritize the request

Closes #24022

Output from acceptance testing:

$ make testacc TESTS=TestAccAthenaDatabase_ PKG=athena

--- PASS: TestAccAthenaDatabase_nameCantHaveUppercase (4.89s)
--- PASS: TestAccAthenaDatabase_disppears (49.70s)
--- PASS: TestAccAthenaDatabase_properties (55.26s)
--- PASS: TestAccAthenaDatabase_forceDestroyAlwaysSucceeds (55.45s)
--- PASS: TestAccAthenaDatabase_basic (57.23s)
--- PASS: TestAccAthenaDatabase_acl (57.44s)
--- PASS: TestAccAthenaDatabase_nameStartsWithUnderscore (57.46s)
--- PASS: TestAccAthenaDatabase_unescaped_description (57.54s)
--- PASS: TestAccAthenaDatabase_description (57.55s)
--- PASS: TestAccAthenaDatabase_encryption (60.38s)
--- PASS: TestAccAthenaDatabase_destroyFailsIfTablesExist (64.35s)

[ewbankkit]

LGTM 🚀.

% make testacc TESTS=TestAccAthenaDatabase_ PKG=athena ACCTEST_PARALLELISM=2
==> Checking that code complies with gofmt requirements...
TF_ACC=1 go test ./internal/service/athena/... -v -count 1 -parallel 2 -run='TestAccAthenaDatabase_'  -timeout 180m
=== RUN   TestAccAthenaDatabase_basic
=== PAUSE TestAccAthenaDatabase_basic
=== RUN   TestAccAthenaDatabase_properties
=== PAUSE TestAccAthenaDatabase_properties
=== RUN   TestAccAthenaDatabase_acl
=== PAUSE TestAccAthenaDatabase_acl
=== RUN   TestAccAthenaDatabase_encryption
=== PAUSE TestAccAthenaDatabase_encryption
=== RUN   TestAccAthenaDatabase_nameStartsWithUnderscore
=== PAUSE TestAccAthenaDatabase_nameStartsWithUnderscore
=== RUN   TestAccAthenaDatabase_nameCantHaveUppercase
=== PAUSE TestAccAthenaDatabase_nameCantHaveUppercase
=== RUN   TestAccAthenaDatabase_destroyFailsIfTablesExist
=== PAUSE TestAccAthenaDatabase_destroyFailsIfTablesExist
=== RUN   TestAccAthenaDatabase_forceDestroyAlwaysSucceeds
=== PAUSE TestAccAthenaDatabase_forceDestroyAlwaysSucceeds
=== RUN   TestAccAthenaDatabase_description
=== PAUSE TestAccAthenaDatabase_description
=== RUN   TestAccAthenaDatabase_unescaped_description
=== PAUSE TestAccAthenaDatabase_unescaped_description
=== RUN   TestAccAthenaDatabase_disppears
=== PAUSE TestAccAthenaDatabase_disppears
=== CONT  TestAccAthenaDatabase_properties
=== CONT  TestAccAthenaDatabase_destroyFailsIfTablesExist
--- PASS: TestAccAthenaDatabase_properties (33.14s)
=== CONT  TestAccAthenaDatabase_nameStartsWithUnderscore
--- PASS: TestAccAthenaDatabase_destroyFailsIfTablesExist (41.89s)
=== CONT  TestAccAthenaDatabase_nameCantHaveUppercase
--- PASS: TestAccAthenaDatabase_nameCantHaveUppercase (1.27s)
=== CONT  TestAccAthenaDatabase_unescaped_description
--- PASS: TestAccAthenaDatabase_nameStartsWithUnderscore (32.70s)
=== CONT  TestAccAthenaDatabase_disppears
--- PASS: TestAccAthenaDatabase_unescaped_description (35.29s)
=== CONT  TestAccAthenaDatabase_encryption
--- PASS: TestAccAthenaDatabase_disppears (27.54s)
=== CONT  TestAccAthenaDatabase_acl
--- PASS: TestAccAthenaDatabase_encryption (33.01s)
=== CONT  TestAccAthenaDatabase_description
--- PASS: TestAccAthenaDatabase_acl (30.61s)
=== CONT  TestAccAthenaDatabase_forceDestroyAlwaysSucceeds
--- PASS: TestAccAthenaDatabase_description (32.37s)
=== CONT  TestAccAthenaDatabase_basic
--- PASS: TestAccAthenaDatabase_forceDestroyAlwaysSucceeds (31.41s)
--- PASS: TestAccAthenaDatabase_basic (31.61s)
PASS
ok  	github.com/hashicorp/terraform-provider-aws/internal/service/athena	180.670s

[ewbankkit]

@DrFaust92 Thanks for the contribution 🎉 👏.

[github-actions]

This functionality has been released in v4.10.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 functionality, please create a new GitHub issue following the template. Thank you!

[github-actions]

I'm going to lock this pull request because it has been closed for 30 days ⏳. This helps our maintainers find and focus on the active issues.
If you have found a problem that seems related to this change, please open a new issue and complete the issue template so we can capture all the details necessary to investigate further.