You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Destroy operation for snowflake_shared_database should not be dependent on the accessibility of its underlying provider database to be able to perform a destruction when needed. Such access can be lost in case the provider database and share gets re-created.
Actual Behavior
When creating an imported database via snowflake_shared_database, if the provider database gets re-created we need to re-create the consumer database as well.
Destroy of snowflake_shared_database fails due to:
Shared database is no longer available for use. It will need to be re-created if and when the publisher makes it available again.
Steps to Reproduce
Create a share from account A to account B
Deploy a snowflake_shared_database in account B sourcing from account A share
Re-create share in account A
Destroy snowflake_shared_database in account B (ERROR)
How much impact is this issue causing?
Low
Logs
No response
Additional Information
No response
Would you like to implement a fix?
Yeah, I'll take it 😎
The text was updated successfully, but these errors were encountered:
snowflake_unsafe_execute does not try to use the database context and then works without throwing errors.
simonepm
changed the title
[Bug]: consumer snowflake_shared_database cannot be destroyed if provider database is dropped/re-created
[Bug]: consumer snowflake_shared_database cannot be destroyed if provider share is dropped/re-created
Sep 20, 2024
Terraform CLI Version
1.9.5
Terraform Provider Version
0.96.0
Terraform Configuration
Category
category:resource
Object type(s)
resource:share
Expected Behavior
Destroy operation for snowflake_shared_database should not be dependent on the accessibility of its underlying provider database to be able to perform a destruction when needed. Such access can be lost in case the provider database and share gets re-created.
Actual Behavior
When creating an imported database via snowflake_shared_database, if the provider database gets re-created we need to re-create the consumer database as well.
Destroy of snowflake_shared_database fails due to:
Shared database is no longer available for use. It will need to be re-created if and when the publisher makes it available again.
Steps to Reproduce
Create a share from account A to account B
Deploy a snowflake_shared_database in account B sourcing from account A share
Re-create share in account A
Destroy snowflake_shared_database in account B (ERROR)
How much impact is this issue causing?
Low
Logs
No response
Additional Information
No response
Would you like to implement a fix?
The text was updated successfully, but these errors were encountered: