Support Athena Views

[robmoore]

Community Note

• Please vote on this issue by adding a 👍 reaction to the original issue 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 issue followers and do not help prioritize the request
• If you are interested in working on this issue or have submitted a pull request, please leave a comment

Description

New resource for AWS Athena views which would provide a way to define views using Terraform.

New or Affected Resource(s)

• aws_athena_view

Potential Terraform Configuration

resource "aws_athena_view" "my_view" {
  name      = "sc_eq_taq_1min"
  database  = aws_athena_database.my_database.name
  query     = "SELECT x, y, from_iso8601_date(a_date_as_string) AS a_date_as_date_type FROM ${aws_athena_database.my_table.name}"
}

References

• https://docs.aws.amazon.com/athena/latest/ug/views.html
• https://docs.aws.amazon.com/athena/latest/ug/create-view.html
• Some workarounds to lack of view support

[breisig]

Has this feature been included yet in Terraform? This would be a great feature.

[massung]

Yes, please. This would be a big win!

[blaargh]

/push this would be great!

[chell0veck]

+1