Artur Sawicki

Hey @krishreddy56. I finally had time to verify the issue. It is connected with #2629. Long story short: 1. The defaults in this resource are incorrect and the resulting SQL...

Hey @imanebenomar. Can you try only with: ``` enable = false deferrable = false ``` so in your case: ``` resource "snowflake_table_constraint" "pk" { for_each = module.common_vars.SNOWFLAKE_BRONZE_TABLES name = "PK_${upper(each.value.table_name)}"...

Please check this link: https://docs.snowflake.com/en/sql-reference/constraints-properties#non-default-values-for-the-enable-and-validate-constraint-properties. For more information about the inner workings of table constraints, please reach out to your Snowflake account manager, this is outside my field of expertise.

Hey @sadahry. For which systems have you verified the prerelease version? I want to release this patch as part of the 0.88.0 version officially, but first, I want to confirm...

Closing as completed.

Hey @bmhah. Thanks for reaching out to us. Please share the terraform run logs with `TF_LOG=DEBUG` enabled.

Hey @bmhah. I will confirm in the morning, but it looks like an easy fix, so we may even be able to include it in tomorrow's release. I will keep...

Hey @bmhah. We have released the new version: https://github.com/Snowflake-Labs/terraform-provider-snowflake/releases/tag/v0.89.0. Please bump and check if the error persists. Please remember to use the migration guide during version upgrades: https://github.com/Snowflake-Labs/terraform-provider-snowflake/blob/main/MIGRATION_GUIDE.md#migration-guide.

Hey @bmhah. Have you have a chance to test the newer versions after the introduced fixes?

The fix was introduced in 0.89, not 0.88, so please provide the config and logs (run terraform with TF_LOG=DEBUG) on the 0.89+ version (I could not reproduce the issue given...