resource/aws_ssm_parameter: Allow Intelligent-Tiering to upgrade to Advanced

[gdavison]

AWS SSM Parameters with Intelligent-Tiering were not upgrading from Standard to Advanced if needed.

Removes hard-coded default of Standard to use the default configured for the account and region.

Closes #18521
Closes #25037

Output from acceptance testing:

$ make testacc PKG=ssm TESTS=TestAccSSMParameter

--- PASS: TestAccSSMParameter_disappears (106.85s)
--- PASS: TestAccSSMParametersByPathDataSource_withRecursion (130.32s)
--- PASS: TestAccSSMParameter_Tier_intelligentTieringOnCreation (137.32s)
--- PASS: TestAccSSMParameter_overwriteWithTags (146.87s)
--- PASS: TestAccSSMParameter_secure (146.89s)
--- PASS: TestAccSSMParameter_noOverwriteWithTags (147.05s)
--- PASS: TestAccSSMParameter_fullPath (147.11s)
--- PASS: TestAccSSMParameter_basic (149.06s)
--- PASS: TestAccSSMParameter_Tier_intelligentTieringOnUpdate (204.45s)
--- PASS: TestAccSSMParameterDataSource_basic (209.50s)
--- PASS: TestAccSSMParameter_updateType (216.19s)
--- PASS: TestAccSSMParameter_updateToOverwriteWithTags (220.86s)
--- PASS: TestAccSSMParametersByPathDataSource_basic (114.14s)
--- PASS: TestAccSSMParameter_overwrite (222.88s)
--- PASS: TestAccSSMParameter_updateDescription (223.01s)
--- PASS: TestAccSSMParameter_Secure_keyUpdate (223.90s)
--- PASS: TestAccSSMParameterDataSource_fullPath (95.61s)
--- PASS: TestAccSSMParameter_overwriteCascade (236.64s)
--- PASS: TestAccSSMParameter_secureWithKey (99.41s)
--- PASS: TestAccSSMParameter_DataType_ec2Image (97.65s)
--- PASS: TestAccSSMParameter_tier (246.33s)
--- PASS: TestAccSSMParameter_tags (246.96s)
--- PASS: TestAccSSMParameter_Tier_intelligentTieringToStandard (247.06s)
--- PASS: TestAccSSMParameter_Tier_intelligentTieringToAdvanced (248.32s)
--- PASS: TestAccSSMParameter_changeNameForcesNew (103.43s)

[bassmanitram]

This is awesome - I really didn't expect this to be actioned so quickly! Thank you!

[anGie44]

Should we add a changelog entry too? otherwise LGTM 🚀

[github-actions]

This functionality has been released in v4.18.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.