[Feature]: Add timeouts to snowflake_dynamic_table

[fabiomx]

Company Name

No response

Use Cases or Problem Statement

As mentioned in #3334, the snowflake_dynamic_table resource may require a longer timeout than Terraform's default during the creation phase, especially for large volumes of data.

To address this, it would be beneficial to add the timeouts configuration to this resource, similar to what was done for snowflake_execute.

Category

category:resource

Object type(s)

resource:dynamic_table

Proposal

No response

How much impact is this issue causing?

Low

Additional Information

No response

Would you like to implement a fix?

• Yeah, I'll take it 😎

[sfc-gh-asawicki]

Hey @fabiomx. Thanks for creating the issue.

We want to discuss the timeout topic in general and implement it in all suitable places (or even all the resources). We won't probably be able to address it before the GA, so I will keep this issue open for the time being.

One question, though: did you encounter the problem in your current setup, or is it a potential problem? In the latter case we may consider adding the timeout only to this resource but we also encourage contribution following our guidelines and the PR implementing the same functionality for the snowflake_execute resource #3337 .

[fabiomx]

Hey @sfc-gh-asawicki, thanks for getting back to me.

Yes, I'm experiencing the issue in my current setup. For example, yesterday, I had to create some dynamic tables one by one via -target option to make it work. Although I had increased the warehouse size, the warehouse's resources were still insufficient to handle all the dynamic table creations within 20 minutes. I believe that the initial loading might be significant in some cases.

As for contributing, I can't really focus on it right now, but I might consider it over the coming weeks, following your PR as a reference. Thanks!

If you have any other questions, feel free to reach out.

[sfc-gh-asawicki]

Hey @fabiomx. I will keep that in mind and we may be able to add these timeouts sooner.