Cloudformation-coverage-roadmap: AWS::Athena::Workgroup -WorkGroupConfiguration/WorkGroupConfigurationUpdates should support setting engine version

[mgmarino]

1. Title

AWS::Athena::Workgroup-WorkGroupConfiguration/WorkGroupConfigurationUpdates

2. Scope of request

AWS::Athena::Workgroup -WorkGroupConfiguration/WorkGroupConfigurationUpdates should support setting the version of the Athena engine

3. Expected behavior

It should allow you to select the following:
- Default => let AWS decide/upgrade
- 1 => Manually set Version 1
- 2 => Manually set Version 2

4. Suggest specific test cases

5. Helpful Links to speed up research and evaluation

Athena docs: https://docs.aws.amazon.com/athena/latest/ug/engine-versions-changing.html#engine-versions-changing-changing-the-engine-version

6. Category (required)

Analytics

7. Any additional context (optional)

[vincentippon]

Did you try to set the SelectedEngineVersion to Athena engine version 2 with EnforceWorkGroupConfiguration enabled ?

...
WorkGroupConfiguration:
  EnforceWorkGroupConfiguration: true
  EngineVersion:
    SelectedEngineVersion: Athena engine version 2
...

[mgmarino]

At the time this issue was opened, there wasn’t any support for updating/setting the version. However, now it seems to work, and the documentation has also been updated. I have, however, not seen anything about it in the release notes so I’m not sure if this is yet “official”.

As an aside, I do find it very odd (and very contrary to normal CF functionality) that you have to use a completely different attribute (WorkGroupConfigurationUpdates vs WorkGroupConfiguration) to update an existing resource vs when you create it.