SQLInstance missing support for transactionLogRetentionDays

[isaacseymour]

Describe the feature or resource
The SQLInstance resource does not have an option for setting transactionLogRetentionDays. This is available in the REST API

Importance
This is a pain point, since this setting can be modified in the GCP Console, but when it's not in the config-as-code there's no documentation about what the setting should be and why.

[maqiuyujoyce]

Hi @isaacseymour , thank you for your request. We'll be looking into prioritizing it.

Just to share some context - The SQLInstance resource is supported on top of the Terraform resource, google_sql_database_instance, and Config Connector will support transactionLogRetentionDays after the TF resource supports it. Currently there is an open enhancement request for supporting this particular field. Will keep you posted when we have any updates.

[isaacseymour]

Aha! Looks like that request is being closed in the unreleased version of the terraform provider, so hopefully that won't be a blocker for much longer! Thanks for the speedy reply :)

[isaacseymour]

Looks like this was added to the Google Terraform provider in 3.60.0. Is there another issue I should be following to track when that update will be included in config-connector?

[maqiuyujoyce]

Hi @isaacseymour , transactionLogRetentionDays in SQLInstance has been supported in Config Connector 1.44.0. Please let us know if you have any additional questions.

[isaacseymour]

Oh amazing! Thanks!