How to add a new column after changing ownership of a table? #591
Unanswered
anthonyClumio
asked this question in
Q&A
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
I create a table in snowflake using terraform and I changed the ownership of the table so that I can use snowflake task.
How can I add a new column to such a table? If I add a new column to the table using the new owner (using migration), the next terraform run will fail because the table definition does not know the new column and try to remove it, but it lack the permission to do so. I also cannot make terraform to add the new column since the role of the terraform is no longer the owner of the table.
Does that mean if a table is created by terraform, the ownership of the table should never change?
Beta Was this translation helpful? Give feedback.
All reactions