Comments (5)
Hey @JESCHO99. Thanks for raising this issue.
Unfortunately, this is a known error that affects multiple resources, not only tables (e.g., check #2735).
Long story short: data types with arguments (like VARCHAR(3) and VARCHAR(200)) are not always handled properly. In this case, they are both synonymized to check if the type changed, but their length is not taken into consideration, so the diff is suppressed incorrectly.
We should start working on procedures and functions next week, so the datatype topic will be addressed then. Before that, we can add a hotfix to handle properly at least changes to VARCHAR length in the table resource. The hotfix won't make it probably into the next release (tomorrow or on Friday) but should be ready next week.
from terraform-provider-snowflake.
I will also make sure it's added to the known issues/limitations in our FAQ (https://github.com/Snowflake-Labs/terraform-provider-snowflake/blob/main/CREATING_ISSUES.md#commonly-known-issues).
from terraform-provider-snowflake.
Hey @sfc-gh-asawicki, thanks for the reply. A Hotfix for Varchar Fields in the next week would help a lot. If possible it would be great if NUMBER fields could be added to the Hotfix too. Those are the two data types mainly used in our environments. Thanks for your help!
from terraform-provider-snowflake.
Hey @JESCHO99. I think we can include numbers, too; I will confirm next week.
from terraform-provider-snowflake.
Hey @JESCHO99.
I have prepared a fix both for text and number columns in #3020. It will be released as part of v0.95.0 today or tomorrow (we have to wrap a few other pull requests before making the release).
Please check the migration guide for the description of the changes and report any problems with this hotfix.
from terraform-provider-snowflake.
Related Issues (20)
- [Bug]: Certain database role grants not persisting in state file HOT 2
- [Bug]: Terraform fails to success while creating secure procedure in reader account though procedure gets created in account. HOT 4
- [Feature]: Improve documentation for snowflake_grant_privileges_to_account_role HOT 1
- [Bug]: Creating snowflake_stage resource fails when file format is specified HOT 3
- [Bug]: Setting Column Default Crashes Snowflake Plugin HOT 1
- [Bug]: `snowflake_warehouses` data resource has issues when 'SYSTEM$STREAMLIT_NOTEBOOK_WH' is included and `with_describe = true` HOT 1
- [Feature]: Add comments on columns defined in views HOT 1
- [Bug]: snowflake_grant_account_role with role name PUBLIC fails on apply HOT 3
- [Bug]: terraform import snowflake_user_password_policy_attachment - Error: required id format 'user_name|password_policy_name' HOT 3
- [Bug]: snowflake_external_oauth_integration always running a modify/update HOT 6
- [General Usage]: How to grant storage integration in the current state HOT 1
- [General Usage]: How to stop replacing schema while migrating HOT 3
- [Bug]: snowflake_account resource error due to 2024_06 bundle change HOT 2
- [Bug]: Issue while importing Stremlit apps HOT 1
- [Bug]: Issue while importing snowflake schemas to terraform HOT 1
- [Feature]: New resource for Warehouse assignment to Resource Monitor HOT 1
- Can't create roles HOT 4
- [Bug]: `snowflake_function` cannot create table functions with double-quoted columns HOT 1
- [Bug]: fail to create snowflake_account_parameter
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from terraform-provider-snowflake.