[Bug]: snowflake_database with the from_database won't migrate automatically for 0.93

[kanomaxb]

Terraform CLI Version

1.2.6

Terraform Provider Version

0.93

Terraform Configuration

resource "snowflake_database" "test" {
  name = "VERY_IMPORTANT_DB"
  data_retention_time_in_days = 7
  from_database = "THE_MODEL_DB"
}

Category

category:resource

Object type(s)

resource:database

Expected Behavior

I'm trying to upgrade from 0.92 to 0.93.

I have the old snowflake_database resource, with the from_database parameter set.

The migration guide says:

If you had from_database set, it should migrate automatically.

Actual Behavior

I'm not sure what it means, that it should migrate automatically.
If I just change the version, it says "Unsupported argument".
If I change the version and remove the from_database param, it says "failed to upgrade the state with database created from database".

What should I do to achieve the "automatic upgrade" mentioned in the migration guide?

Steps to Reproduce

.

How much impact is this issue causing?

Medium

Logs

No response

Additional Information

No response

Would you like to implement a fix?

• Yeah, I'll take it 😎

[sfc-gh-jcieslak]

Hey @kamilamarcinekpgs
That's a documentation error; I'll fix it. As from_database is database cloning, which is not currently supported, the only way is to remove the database from the state terraform state rm -> upgrade to the newer version -> import the database.

[sfc-gh-jcieslak]

Hey 👋
Yesterday, we released a new version of the provider (v0.95.0) where the message after migrating with from_database should be more descriptive and I adjusted the migration guide.

[sfc-gh-jcieslak]

Closing due to long inactivity. Please, create another issue if you think the problem is still not resolved.