SQL DB Instance has attribute first_ip_address

[genevieve]

Related Issues:

#912
hashicorp/terraform#17048

[genevieve]

Hey @danawillow. I opened this PR after discussions in #912 and hashicorp/terraform#17048.

Is there anything about this attribute or it's implementation that we can fix? This is currently a blocker for us as there is no way to have this particular resource have a count.

[danawillow]

I see in the other issue that a workaround of using TF_WARN_OUTPUT_ERRORS=1 until the new syntax comes out was suggested- did that work?

[genevieve]

Since the terraform doesn't apply without that environment variable, it means resources that all our teams use in CI/CD pipelines would have to support that, as well as asking it of all the users that go directly to use these terraform templates. It wasn't really something we wanted to recommend since it risks actually swallowing relevant errors.

When we choose one output syntax over the other either the database-turned-off case works and the database-turned-on fails during terraform apply, and choosing a different syntax causes the opposite.

Ideally we could have a terraform module for creating this database, but due to the inability to actually make it work with the terraform syntax and the resource's structure, it has to be mandatory. Currently, teams that weren't opting in to this database are seeing a recurring issue opened here (#1138) and they can't avoid it by opting out of the database since we had to make it a mandatory resource.

[danawillow]

Thanks @genevieve! That sounds reasonable, and the code looks good. Merging now.

[danawillow]

Oh wait, I got ahead of myself. I'm going to keep it in, but would you mind sending a follow-up PR for changes to the docs to add this attribute? Please tag me in it and I'll review it right away.

[ghost]

I'm going to lock this issue because it has been closed for 30 days ⏳. This helps our maintainers find and focus on the active issues.

If you feel this issue should be reopened, we encourage creating a new issue linking back to this one for added context. If you feel I made an error 🤖 🙉 , please reach out to my human friends 👉 [email protected]. Thanks!