I am currently considering create tables using Terraform in snowflake, but I am wondering if it is possible to convert the table format (add columns, etc.) by terraform after release tables when I need to do.
here is information for terraform we are using.
Product name : Terraform CLI
CLI version : 1.3.9
※I have remove a similar question from three days ago because the text was inappropriate.
There are lots of people who know about Terraform in this forum, but finding someone with specific experience of a particular provider can sometimes be hard.
I think your best option is to just try it out and see what happens.
My guess is that one of two things will happen:
Changing the schema might destroy and recreate the table, discarding all data
Or it might update the schema in the way you would hope
Not having worked with Snowflake, nor having an account on that platform, I have no idea which … but it shouldn’t take more than a few minutes to try it out interactively if you do.
@maxb
Thanks you for your kind. and sorry for late reply.
Now I dont have the acount to try the POC that check my question.
but I will try to create new acount. and check my question maybe, next week. thansks you.
Can confirm that changing the schema on a snowflake_table resource will break things. Dropping the table also seem not ideal. Posting here to bump conversation and see if there is a terraform approved way to get this schema change in.