[Bug]: Athena - aws_athena_data_catalog fails for federated type data sources

[francisInfact]

Terraform Core Version

1.9.8

AWS Provider Version

5.84.0

Affected Resource(s)

aws_athena_data_catalog

Expected Behavior

I would expect the terraform provider to successfully create the data source and all dependent resources.

Actual Behavior

Terraform fails immediately and does not wait for the resource(s) to be created. This is probably due to the fact that Athena creates these resources asynchronously and therefore the resource doesn't exist for a period (until dependent resources have finished creation). Downstream it seems like the following resources are created

• CloudFormation stack with
• Lambda for JDBC connections (in this case, this may differ for other FEDERATED connections)
• Glue connections/catalog

Although the failure happens, assuming the configuration is correct the resource does eventually create correctly. However, if terraform is then re-applied the resource is marked as tainted and is deleted.

Relevant Error/Panic Output Snippet

Error: listing tags for Athena Data Catalog (ARN): operation error Athena: ListTagsForResource, https response error StatusCode: 400, RequestID: ... ResourceNotFoundException: Could not find valid resource from ARN:..

Terraform Configuration Files

resource "aws_athena_data_catalog" "example" {
  name        = "my-data-catalog"
  description = "JDBC Conn"
  type        = "FEDERATED"

  parameters = {
    "connection-type" = "POSTGRESQL"
    "connection-properties" = jsonencode({
           "spill_bucket" = "...",
           "host" = "...",
          "port" = "..",
          "database" = "..",
          "SecretArn" = "..",
          "AvailabilityZone": "..",
          "SecurityGroupIdList": [...],
          "SubnetId": "..."
    })
  }
}

Steps to Reproduce

Snippet like the above with appropriate connection details to a given DB.

Debug Output

No response

Panic Output

No response

Important Factoids

No response

References

No response

Would you like to implement a fix?

None

[github-actions]

Community Note

Voting for Prioritization

• Please vote on this issue by adding a 👍 reaction to the original post to help the community and maintainers prioritize this request.
• Please see our prioritization guide for information on how we prioritize.
• Please do not leave "+1" or other comments that do not add relevant new information or questions, they generate extra noise for issue followers and do not help prioritize the request.

Volunteering to Work on This Issue

• If you are interested in working on this issue, please leave a comment.
• If this would be your first contribution, please review the contribution guide.