0.88.0 (2024-04-09)

Hey 👋 , with today's release we're bringing a long-awaited grant_ownership resource. Use this resource with caution and please familiarise yourself with the documentation we prepared before using the resource. We have been also experimenting lately with our build system to support release candidate versions. It's not fully functional yet, but you could already saw the result of that with the latest v0.87.3-pre version. As we will be moving towards different topics than grants, as a closing note, we published a technical document to our repository. It describes the design decisions we took and how they shaped the current grant resources we have right now. Other than that, we focused on resolving incoming GitHub issues.

🎉 What's new:

• Grant ownership resource, implemented in #2628, #2658, #2684
• Introduce shared function to suspend task roots #2650
• Redesign snowflake_grants datasource #2667
• Fix user password policy attachment #2627

🔧 Misc

• Update grant examples in all resources #2660

🐛 Bug fixes:

• #2659 fixes #2651, #2656
• Adjust dynamic tables after BCR-1543 #2664
• Fix handling secure views read and import #2655
• #2654 fixes #2606 #2642 #2652 #2653
• Fix release workflow #2639
• Generate docs for dynamic table #2666
• Fix grant read operation #2665
• Migration guide for databases created from share #2637
• Fix with_grant_option diff drift #2608

0.87.3-pre (2024-03-18)

🎉 What's new:

• Add snowflake grant ownership resource (#2604) (bfadd24), closes #2549 #2199 #2084 #1942 #1875

🔧 Misc

• Fix env variables for tests (#2603) (8bc2437)
• release 0.87.3-pre (a2be7b9)

🐛 Bug fixes:

• alter table column data type (#2607) (538b6dc)
• cgo goreleaser alt solution (#2613) (5d31856)

0.87.2 (2024-03-07)

Hey 👋 This is a small release fixing the incorrect references for deprecation messages on the docs main page and the incorrect reference in snowflake_role_grants resource.

🐛 Bug fixes:

• Add missing path (#2597) (41865d9)
• Fix the deprecation message for snowflake_role_grants (#2602) (5d9c1a8)

0.87.1 (2024-03-06)

Hey 👋 , today we released a new version that mostly introduces bug fixes and some development improvements that will speed up our development cycle. We also added deprecation messages to our documentation pages in Terraform Registry to clearly see what resources/data sources are deprecated and what should be used instead. Here's what we ended up with on the main page (docs) and in the resources/data sources sub pages (for example). We are aware that there're some issues with links on the main page. We'll push the fix in the next version.

🔧 Misc

• Add deprecated resources/datasources to the main documentation page #2581
• Add deprecation message to docs #2578
• Add Terraform setup to the testing pipeline #2579
• Chore use get or skip in other tests #2570
• modify provider context to pass snowflake client instead of db connection #2577
• Speed up tests #2580

🐛 Bug fixes

• file_format validate() for field_optionally_enclosed_by #2575, closes #2385
• Fix import for account parameter #2594, closes #2573
• Support snowflake application as database #2596, closes #2366, #1998
• tag identifiers problems #2534, closes #1926, #1910, #1909, #1202

0.87.0 (2024-02-28)

🎉 What's new:

• Add network rule to the sdk (#2526) (b379565), closes https://github.com/Snowflake-Labs/terraform-provider-snowflake/issues/2514
• supports collation of table column (#2496) (56771f1)

🔧 Misc

• Clean up environment variables in tests and on CI (#2543) (9a10cb1)
• replace warning in new grant resources with info log (#2521) (c3014b9)

🐛 Bug fixes:

• data retention days follow up (#2566) (7aba384), closes https://github.com/Snowflake-Labs/terraform-provider-snowflake/issues/2356
• data retention time parameters (#2502) (76abf21), closes https://github.com/Snowflake-Labs/terraform-provider-snowflake/issues/2356
• data retention time parameters follow-up (#2530) (5544544), closes https://github.com/Snowflake-Labs/terraform-provider-snowflake/issues/2356
• Demote warning to info and set volatility for procedures and functions (#2567) (abaad7c), closes #2536
• Fix ACCOUNT PARAMETERS option failover group resource (#2522) (61883f3), closes #2517
• Fix failover group alter syntax and suppression for pipe statement (#2562) (24d76c3), closes https://github.com/Snowflake-Labs/terraform-provider-snowflake/issues/2544 https://github.com/Snowflake-Labs/terraform-provider-snowflake/issues/2560
• Fix few tests (#2515) (a523a6b)
• Fix provider config hierarchy (#2551) (677a12b), closes https://github.com/Snowflake-Labs/terraform-provider-snowflake/issues/2242 https://github.com/Snowflake-Labs/terraform-provider-snowflake/issues/2294
• Fix query_results in unsafe_execute resource (#2512) (94ca158), closes #2491
• Fix replication for database resource (#2524) (767fbce), closes #2021
• Fix show by id for external functions (#2531) (d910a84), closes #2528
• Fix various small problems (#2552) (f558ce6), closes https://github.com/Snowflake-Labs/terraform-provider-snowflake/issues/2110 https://github.com/Snowflake-Labs/terraform-provider-snowflake/issues/2495 https://github.com/Snowflake-Labs/terraform-provider-snowflake/issues/2519
• Granting database roles (#2511) (dc27d64), closes #2402
• grants on external volumes (#2538) (1de9a29), closes https://github.com/Snowflake-Labs/terraform-provider-snowflake/issues/2533
• Handle old reference for table_id in table constraint resource (#2558) (d1e8912), closes #2535
• loosen identifier field validation for account object identifiers (#2564) (a5ed8cd), closes https://github.com/Snowflake-Labs/terraform-provider-snowflake/issues/2548

✨ How to upgrade:

Migration guide: https://github.com/Snowflake-Labs/terraform-provider-snowflake/blob/main/MIGRATION_GUIDE.md#v0860--v0870

• IMPORTANT (bug fix) Configuration hierarchy
• snowflake_failover_group resource changes
• snowflake_database, snowflake_schema, and snowflake_table resource changes
• snowflake_table resource changes

Release notes 0.86.0 (2024-02-15)

🎉 What's new

• Add refresh_mode and initialize to dynamic tables #2437
• Add resource snowflake_user_password_policy_attachment #2162
• Create a workaround for granting privileges on all pipes #2477
• Handle IMPORTED PRIVILEGES privileges in privilege-to-role granting resources #2471
• Use from SDK
  • External functions #2454
  • Functions #2462
  • Procedures #2450
  • Table constraint resource #2466
  • Tables #2453

🔧 Misc

• Add migration notes to the docs and change JIRA integration #2497
• Change email and issue reporter #2470
• Grants migration guide #2455
• Remove unused old implementation from snowflake pkg #2458
• Update password policy attachment #2485

🐛 Bug fixes

• allow DT warehouse to be updated in-place #2439
• correct test dependencies #2493
• FileFormat not detecting changes correctly #2436
• Fix few smaller issues #2507 (#2501 #2506 #2488)
• Fix functions and small other fixes #2503, closes #2490
• Fix tag tests in view and in materialized view #2457
• Fix task related issues #2479 (#2036 #2207 #2346)
• Fix tests that base on default data retention #2465
• grant privileges to share test terraform dependencies #2473
• parameter issues #2463
• parse dynamic table query from DDL #2438
• Remove title and body temporarily from jira integration #2499
• SHOW GRANTS mapping for share data type #2508
• user error handling #2486

Release notes 0.85.0 (2024-02-01)

🎉 What's new:

• New resources
  • Grant privileges to share (#2447)
  • Grant privileges to account role (#2365)
• Migrate to the SDK
  • API Integration (#2409)
  • Application (#2350)
  • External Function (#2440)
  • Materialized View (#2403)
  • Notification Integration (#2412)
  • Sequence (#2351)
  • Streamlit (#2400)
  • Call With (#2337)
  • Stages (follow-up) (#2372)
• Use SDK in resource
  • API integration (#2429)
  • Managed Account (#2420)
  • Materialized View (#2448)
  • Notification Integration (#2445)
  • Roles (#2405)
  • Row Access Policy (#2428)
  • Storage Integration (#2380)
  • Sequence and add ordering attribute (#2419), * closes #2387
  • Stage (#2427)

🔧 Misc

• Add missing deprecation message (#2451)

🐛 Bug fixes:

• Account role test (#2422)
• Adjust tests after Snowflake behavior change (#2404)
• app-pkg unset (#2399)
• Fix some bugs (#2421), closes #2358 #2369 #2329
• snowflake_grant_privileges_to_role read operation (#2424)

0.84.1 (2024-01-22)

🔧 Misc

• skip acc managed account test (#2376) (dbf645d)

🐛 Bug fixes:

• Fix whitespace in goreleaser envs (#2388) (5e1266d)
• grant read opeartion (#2364) (5f51f0f)

Release notes 0.84.0 (2024-01-19)

🎉 What's new

• New Resource
  • snowflake_grant_role #2304
  • snowflake_grant_database_role #2301
• Migrate to the new SDK
  • App packages #2323
  • Managed account #2357
  • Row access policy #2363
  • Storage integration #2339

👨🏼‍💻 Coming soon

• Migrate to the new SDK
  • Applications
  • Sequences
• New resources
  • snowflake_grant_privileges_to_account_role
  • snowflake_grant_application_role

🔧 Misc

• 0.84 release #2374
• Add missing issues to existing TODOs and add missing ones #2354
• Skip managed account SDK integration tests temporarily #2370
• update readme and fmt #2373

🐛 Bug fixes

• Masking policy implementation #2371, closes #2362
• goreleaser for mfa token caching #2320, #2360

0.83.1 (2024-01-12)

🐛 Bug fixes:

• Revert goreleaser mfa token caching (#2343) (9a98031)