snowflakedb/terraform-provider-snowflake v0.60.0

on GitHub

0.34.0 (2023-03-28)

Features

• Add 'snowflake_role' datasource (#986) (6983d17)
• Add a resource to manage sequences (#582) (7fab82f)
• add allowed values (#1006) (e7dcfd4)
• Add allowed values (#1028) (e756867)
• add AWS GOV support in api_integration (#1118) (2705970)
• add column masking policy specification (#796) (c1e763c)
• add connection param for snowhouse (#1231) (050c0a2)
• Add CREATE ROW ACCESS POLICY to schema grant priv list (#581) (b9d0e9e)
• add custom oauth int (#1286) (d6397f9)
• add failover groups (#1302) (687742c)
• Add file format resource (#577) (6b95dcb)
• add GRANT ... ON ALL TABLES IN ... (#1626) (505a5f3)
• Add importer to integration grant (#574) (3739d53)
• add in more functionality for UpdateResourceMonitor (#1456) (2df570f)
• Add INSERT_ONLY option to streams (#655) (c906e01)
• Add manage support cases account grants (#961) (1d1084d)
• add missing PrivateLink URLs to datasource (#1603) (78782b1)
• add new account resource (#1492) (b1473ba)
• add new table constraint resource (#1252) (fb1f145)
• add ON STAGE support for Stream resource (#1413) (447febf)
• add parameters resources + ds (#1429) (be81aea)
• add port and protocol to provider config (#1238) (7a6d312)
• add PREVENT_LOAD_FROM_INLINE_URL (#1612) (4945a3a)
• Add private key passphrase support (#639) (a1c4067)
• add python language support for functions (#1063) (ee4c2c1)
• Add REBUILD table grant (#638) (0b21c66)
• Add replication support (#832) (f519cfc)
• Add SHOW_INITIAL_ROWS to stream resource (#575) (3963193)
• add STORAGE_AWS_OBJECT_ACL support to storage integration (#755) (e136b1e)
• add support for notify_users to snowflake_resource_monitor resource (#1340) (7094f15)
• Add support for packages, imports, handler and runtimeVersion to snowflake_procedure resource (#1516) (a88f3ad)
• Add support for creation of streams on external tables (#999) (0ee1d55)
• Add support for default_secondary_roles (#1030) (ae8f3da)
• Add support for error notifications for Snowpipe (#595) (90af4cf)
• Add support for GCP notification integration (#603) (8a08ee6)
• Add support for is_secure to snowflake_function resource (#1575) (c41b6a3)
• Add support for table column comments and to control a tables data retention and change tracking settings (#614) (daa46a0)
• add the param "pattern" for snowflake_external_table (#657) (4b5aef6)
• Added (missing) API Key to API Integration (#1386) (500d6cf)
• Added Functions (UDF) Resource & Datasource (#647) (f28c7dc)
• Added Missing Grant Updates + Removed ForceNew (#1228) (1e9332d)
• Added Procedures Datasource (#646) (633f2bb)
• Added Query Acceleration for Warehouses (#1239) (ad4ce91)
• Added Row Access Policy Resources (#624) (fd97816)
• Added Several Datasources Part 2 (#622) (2a99ea9)
• Adding Database Replication (#1007) (26aa08e)
• adding in tag support (#713) (f75cd6e)
• Adding slack bot for PRs and Issues (#1106) (95c255e)
• Adding support for debugger-based debugging. (#1145) (5509899)
• Adding users datasource (#1013) (4cd86e4)
• Adding warehouse type for snowpark optimized warehouses (#1369) (b5bedf9)
• Allow creation of saml2 integrations (#616) (#805) (c07d582)
• allow in-place renaming of Snowflake schemas (#972) (2a18b96)
• Allow in-place renaming of Snowflake tables (#904) (6ac5188)
• Allow setting resource monitor on account (#768) (2613aa3)
• ci: add depguard (#1368) (1b29f05)
• ci: add goimports and makezero (#1378) (b0e6580)
• ci: add some linters and fix codes to pass lint (#1345) (75557d4)
• ci: golangci lint adding thelper, wastedassign and whitespace (#1356) (0079bee)
• Create a snowflake_user_grant resource. (#1193) (37500ac)
• create snowflake_role_ownership_grant resource (#917) (17de20f)
• Current role data source (#1415) (8152aee)
• Data source for list databases (#861) (537428d)
• Delete ownership grant updates (#1334) (4e6aba7)
• deleting gpg agent before importing key (#1123) (e895642)
• Expose GCP_PUBSUB_SERVICE_ACCOUNT attribute in notification integration (#871) (9cb863c)
• grants datasource (#1377) (0daafa0)
• handle serverless tasks (#736) (bde252e)
• handle-account-grant-managed-task (#751) (8952382)
• Identity Column Support (#726) (4da8014), closes #538
• Implemented External OAuth Security Integration Resource (#879) (83997a7)
• integer return type for procedure (#1266) (c1cf881)
• integration: add google api integration (#1589) (56909cd)
• OAuth security integration for partner applications (#763) (0ec5f4e)
• Pipe and Task Grant resources (#620) (90b9f80)
• Procedures (#619) (869ff75)
• Python support for functions (#1069) (bab729a)
• Release GH workflow (#840) (c4b81e1)
• roles support numbers (#1585) (d72dee8)
• S3GOV support to storage_integration (#1133) (92a5e35)
• show roles data source (#1309) (b2e5ecf)
• snowflake_user_ownership_grant resource (#969) (6f3f09d)
• Streams on views (#1112) (7a27b40)
• Support create function with Java language (#798) (7f077f2)
• Support DIRECTORY option on stage create (#872) (0ea9a1e)
• Support for selecting language in snowflake_procedure (#1010) (3161827)
• support host option to pass down to driver (#939) (f75f102)
• support object parameters on account level (#1583) (fb24802)
• Table Column Defaults (#631) (bcda1d9)
• table constraints (#599) (b0417a8)
• tag association resource (#1187) (123fd2f)
• tag based masking policy (#1143) (e388545)
• tag grants (#1127) (018e7ab)
• task after dag support (#1342) (a117802)
• Task error integration (#830) (8acfd5f)
• task with allow_overlapping_execution option (#1291) (8393763)
• TitleLinter customized (#842) (39c7e20)
• transient database (#1165) (f65a0b5)

BugFixes

• 0.54 (#1435) (4c9dd13)
• 0.55 fix (#1465) (8cb3370)
• 0.59 release fixes (#1636) (0a0256e)
• 0.60 misc bug fixes / linting (#1643) (53da853)
• Add AWS_SNS notification_provider support for error notifications for Snowpipe. (#777) (02a97e0)
• Add AWS_SQS_IAM_USER_ARN to notification integration (#610) (82a340a)
• Add contributing section to readme (#1560) (174355d)
• Add gpg signing to goreleaser (#911) (8ae3312)
• Add importer to account grant (#576) (a6d7f6f)
• Add manifest json (#914) (c61fcdd)
• add nill check for grant_helpers (#1518) (87689bb)
• add permissions (#1464) (e2d249a)
• Add release step in goreleaser (#919) (63f221e)
• add sweepers (#1203) (6c004a3)
• add test cases for update repl schedule on failover group (#1578) (ab638f0)
• Add valid property AWS_SNS_TOPIC_ARN to AWS_SNS notification provider (#783) (8224954)
• add warehouses attribute to resource monitor (#831) (b041e46)
• added force_new option to role grant when the role_name has been changed (#1591) (4ec3613)
• Added Missing Account Privileges (#635) (c9cc806)
• adding in issue link to slackbot (#1158) (6f8510b)
• all-grants (#1658) (d5d59b4)
• Allow creation of database-wide future external table grants (#1041) (5dff645)
• Allow creation of stage with storage integration including special characters (#1081) (7b5bf00), closes #1080
• allow custom characters to be ignored from validation (#1059) (b65d692)
• Allow empty result when looking for storage integration on refresh (#692) (16363cf)
• Allow legacy version of GrantIDs to be used with new grant functionality (#923) (b640a60)
• Allow multiple resources of the same object grant (#824) (7ac4d54)
• allow read of really old grant ids and add test cases (#1615) (cda40ec)
• backwards compatability for grant helpers id used by procedure and functions (#1508) (3787657)
• change resource monitor suspend properties to number (#1545) (4bc59e2)
• change the function_grant documentation example privilege to usage (#901) (70d9550)
• changing tool to ghaction-import for importing gpg keys (#1129) (5fadf08)
• ci: remove unnecessary type conversions (#1357) (1d2b455)
• clean up tag association read (#1261) (de5dc85)
• cleanup grant logic (#1522) (0502c61)
• Correctly read INSERT_ONLY mode for streams (#1047) (9c034fe)
• Database from share comment on create and docs (#1167) (fc3a8c2)
• Database tags UNSET (#1256) (#1257) (3d5dcac)
• default_secondary_roles doc (#1584) (23b64fa)
• Delete gpg change (#1126) (ea27084)
• Deleting a snowflake_user and their associated snowlfake_role_grant causes an error (#1142) (5f6725a)
• Dependabot configuration to make it easier to work with (a7c60f7)
• do not set query_acceleration_max_scale_factor when enable enable_query_acceleration = false (#1474) (d62b1b4)
• doc (#1326) (d7d5e08)
• doc of resource_monitor_grant (#1188) (03a6cb3)
• doc pipe (#1171) (c94c2f9)
• docs (#1409) (fb68c25)
• Don't throw an error on unhandled Role Grants (#1414) (be7e78b)
• errors package with new linter rules (#1360) (b8df2d7)
• escape string escape_unenclosed_field (#877) (6f5578f)
• Escape String for AS in external table (#580) (3954741)
• expand allowed special characters in role names (#1162) (30a59e0)
• external_function: Allow Read external_function where return_type is VARIANT (#720) (1873108)
• external_table headers order doesn't matter (#731) (e0d74be)
• File Format Update Grants (#1397) (19933c0)
• Fix snowflake_share resource not unsetting accounts (#1186) (03a225f)
• Fixed Grants Resource Update With Futures (#1289) (132373c)
• format for go ci (#1349) (75d7fd5)
• function not exist and integration grant (#1154) (ea01e66)
• future read on grants (#1520) (db78f64)
• Go Expression Fix #1384 (#1403) (8936e1a)
• go syntax (#1410) (c5f6b9f)
• Go syntax to add revive (#1411) (b484bc8)
• golangci.yml to keep quality of codes (#1296) (792665f)
• Handling 2022_03 breaking changes (#1072) (88f4d44)
• handling not exist gracefully (#1031) (101267d)
• Handling of task error_integration nulls (#834) (3b27905)
• ie-proxy for go build (#1318) (c55c101)
• Improve table constraint docs (#1355) (7c650bd)
• insecure go expression (#1384) (a6c8e75)
• integration errors (#1623) (83a40d6)
• interval for failover groups (#1448) (bd1d3cc)
• issue with ie-proxy (#903) (e028bc8)
• Legacy role grantID to work with new grant functionality (#941) (5182361)
• linting errors (#1432) (665c944)
• log fmt (#1192) (0f2e2db)
• make platform info compatible with quoted identifiers (#729) (30bb7d0)
• Make ReadWarehouse compatible with quoted resource identifiers (#907) (72cedc4)
• make saml2_enable_sp_initiated bool throughout (#828) (b79988e)
• makefile remove outdated version reference (#1027) (d066d0b)
• materialized view grant incorrectly requires schema_name (#654) (faf0767)
• misc linting changes for 0.56.2 (#1509) (e0d1ef5)
• missing t.Helper for thelper function (#1264) (17bd501)
• misspelling (#1262) (e9595f2)
• multiple share grants (#1510) (d501226)
• Network Attachment (Set For Account) (#990) (1dde150)
• oauth integration (#1315) (9087220)
• openbsd build (#1647) (6895a89)
• OSCP -> OCSP misspelling (#664) (cc8eb58)
• Pass file_format values as-is in external table configuration (#1183) (d3ad8a8), closes #1046
• Pin Jira actions versions (#1283) (ca25f25)
• preallocate slice (#1385) (9e972c0)
• procedure and function grants (#1502) (0d08ea8)
• provider upgrade doc (#1039) (e1e23b9)
• Ran make deps to fix dependencies (#899) (a65fcd6)
• read Database and Schema name during Stream import (#732) (9f747b5)
• read Name, Database and Schema during Procedure import (#819) (d17656f)
• readded imported privileges special case for database grants (#1597) (711ac0c)
• Recreate notification integration when type changes (#792) (e9768bf)
• refactor for simplify handling error (#1472) (3937216)
• refactor handling error to be simple (#1473) (9f37b99)
• refactor ReadWarehouse function to correctly read object parameters (#745) (d83c499)
• Release by updating go dependencies (#894) (79ec370)
• Release tag (#848) (610a85a)
• remove emojis, misc grant id fix (#1598) (fdefbc3)
• Remove force_new from masking_expression (#588) (fc3e78a)
• Remove keybase since moving to github actions (#852) (6e14906)
• remove share feature from stage because it isn't supported (#918) (7229387)
• remove shares from snowflake_stage_grant #1285 (#1361) (3167d9d)
• remove stage from statefile if not found (#1220) (b570217)
• remove table where is_external is Y (#667) (14b17b0)
• Remove validate_utf8 parameter from file_format (#1166) (6595eeb)
• Removed Read for API_KEY (#1402) (ddd00c5)
• Removing force new and adding update for data base replication config (#1105) (f34f012)
• resource snowflake_resource_monitor behavior conflict from provider 0.54.0 to 0.55.0 (#1468) (8ce0c53)
• run check docs (#1306) (53698c9)
• saml integration test (#1494) (8c31439)
• saml2_sign_request and saml2_force_authn cast type (#1452) (f8cecd7)
• schema name is optional for future file_format_grant (#1484) (1450cdd)
• schema name is optional for future function_grant (#1485) (dcc550e)
• schema name is optional for future procedure_grant (#1486) (4cf4561)
• schema name is optional for future sequence_grant (#1487) (ccf9e78)
• schema name is optional for future snowflake_stage_grant (#1466) (0b4d814)
• schema name is optional for future stream_grant (#1488) (3f7e5d6)
• schema name is optional for future task_grant (#1489) (4096fd0)
• schema read now checks first if the corresponding database exists (#1568) (368dc8f)
• schema_name is optional to enable future pipe grant (#1424) (5d966fd)
• SCIM access token compatible identifiers (#750) (afc92a3)
• sequence import (#775) (e728d2e)
• Share example (#673) (e9126a9)
• Share resource to use REFERENCE_USAGE instead of USAGE (#762) (6906760)
• Shares can't be updated on table_grant resource (#789) (6884748)
• snowflake_share: Can't be renamed, ForceNew on name changes (#659) (754a9df)
• stop file format failure when does not exist (#1399) (3611ff5)
• Stream append only (#653) (807c6ce)
• support different tag association queries for COLUMN object types (#1380) (546d0a1)
• Table Tags Acceptance Test (#1245) (ab34763)
• tag association name convention (#1294) (472f712)
• tag on schema fix (#1313) (62bf8b7)
• tagging for db, external_table, schema (#795) (7aff6a1)
• Temporarily disabling acceptance tests for release (#1083) (8eeb4b7)
• test modules in acceptance test for warehouse (#1359) (2d8f2b6)
• Update 'user_ownership_grant' schema validation (#1242) (061a28a)
• update 0.58.2 (#1620) (f1eab04)
• update doc (#1305) (4a82c67)
• Update go and docs package (#1009) (72c3180)
• Update goreleaser env Dirty to false (#850) (402f7e0)
• update id serialization (#1362) (4d08a8c)
• update packages (#1619) (79a3acc)
• update read role grants to use new builder (#1596) (e91860a)
• update ReadTask to correctly set USER_TASK_TIMEOUT_MS (#761) (7b388ca)
• update team slack bot configurations (#1134) (b83a461)
• Updating shares to disallow account locators (#1102) (4079080)
• Upgrade go (#715) (f0e59c0)
• Upgrade tf for testing (#625) (c03656f)
• use "DESCRIBE USER" in ReadUser, UserExists (#769) (36a4f2e)
• validate identifier (#1312) (295bc0f)
• Warehouse create and alter properties (#598) (632fd42)
• warehouse import when auto_suspend is set to null (#1092) (9dc748f)
• warehouses update issue (#1405) (1c57462)
• weird formatting (526b852)
• wildcards in database name (#1666) (54bf74c)
• workflow warnings (#1316) (6f513c2)
• wrong usage of testify Equal() function (#1379) (476b330)

Misc

• add godot to golangci (#1263) (3323470)
• deps: bump actions/setup-go from 3 to 4 (#1634) (3f128c1)
• deps: bump github.com/hashicorp/terraform-plugin-sdk/v2 (#1035) (f885f1c)
• deps: bump github.com/hashicorp/terraform-plugin-sdk/v2 (#1280) (657a180)
• deps: bump github.com/hashicorp/terraform-plugin-sdk/v2 (#1373) (b22a2bd)
• deps: bump github.com/hashicorp/terraform-plugin-sdk/v2 (#1639) (330777e)
• deps: bump github.com/snowflakedb/gosnowflake (#1304) (fb61921)
• deps: bump github.com/snowflakedb/gosnowflake (#1375) (e1891b6)
• deps: bump github.com/snowflakedb/gosnowflake (#1423) (84c9389)
• deps: bump github.com/snowflakedb/gosnowflake (#1638) (107bb4a)
• deps: bump github.com/stretchr/testify from 1.8.0 to 1.8.1 (#1300) (2f3c612)
• deps: bump github/codeql-action from 1 to 2 (#1353) (9d7bc15)
• deps: bump golang.org/x/crypto from 0.1.0 to 0.4.0 (#1407) (fc96d62)
• deps: bump golang.org/x/crypto from 0.4.0 to 0.5.0 (#1454) (ed6bfe0)
• deps: bump golang.org/x/crypto from 0.5.0 to 0.6.0 (#1528) (8a011e0)
• deps: bump golang.org/x/net from 0.5.0 to 0.7.0 (#1551) (35de62f)
• deps: bump golang.org/x/tools from 0.1.12 to 0.2.0 (#1295) (5de7a51)
• deps: bump golang.org/x/tools from 0.2.0 to 0.4.0 (#1400) (58ca9d8)
• deps: bump golang.org/x/tools from 0.4.0 to 0.5.0 (#1455) (ff01970)
• deps: bump goreleaser/goreleaser-action from 2 to 3 (#1354) (9ad93a8)
• deps: bump goreleaser/goreleaser-action from 3 to 4 (#1426) (409bcb1)
• deps: bump peter-evans/create-or-update-comment from 1 to 2 (#1350) (d4d340e)
• deps: bump peter-evans/find-comment from 1 to 2 (#1352) (ce13a8e)
• deps: bump peter-evans/slash-command-dispatch from 2 to 3 (#1351) (9d17ead)
• docs: terraform fmt (#1358) (0a2fe08)
• docs: update documentation adding double quotes (#1346) (c4af174)
• main: release 0.26.0 (#841) (4a6d659)
• main: release 0.26.1 (#849) (a2607e5)
• main: release 0.26.2 (#851) (016e02d)
• main: release 0.26.3 (#854) (63f2b85)
• main: release 0.27.0 (#870) (5178aa6)
• main: release 0.28.0 (#886) (b523f7e)
• main: release 0.28.1 (#895) (c92c518)
• main: release 0.28.2 (#902) (e1c228b)
• main: release 0.28.3 (#905) (b01a21b)
• main: release 0.28.4 (#913) (4fa19e3)
• main: release 0.28.5 (#915) (d9a7f01)
• main: release 0.28.6 (#920) (3a17e34)
• main: release 0.28.7 (#921) (adbb52e)
• main: release 0.28.8 (#928) (96152d7)
• main: release 0.29.0 (#943) (f1d0af9)
• main: release 0.30.0 (#954) (bfd3108)
• main: release 0.31.0 (#968) (1e21100)
• main: release 0.32.0 (#974) (e947417)
• main: release 0.33.0 (#988) (bf3482e)
• main: release 0.33.1 (#991) (1c5af87)
• main: release 0.34.0 (#1014) (f1c651e)
• main: release 0.34.0 (#1019) (83db3a4)
• main: release 0.34.0 (#1020) (7116025)
• main: release 0.34.0 (#1022) (d06c91f)
• main: release 0.34.0 (#1332) (7037952)
• main: release 0.34.0 (#1436) (7358fdd)
• main: release 0.34.0 (#1662) (129e4dd)
• main: release 0.35.0 (#1026) (f9036e8)
• main: release 0.36.0 (#1056) (d055d4c)
• main: release 0.37.0 (#1065) (6aecc46)
• main: release 0.37.1 (#1096) (1de53b5)
• main: release 0.38.0 (#1103) (aee8431)
• main: release 0.39.0 (#1130) (82616e3)
• main: release 0.40.0 (#1132) (f3f1f3b)
• main: release 0.41.0 (#1157) (5b9b47d)
• main: release 0.42.0 (#1179) (ba45fc2)
• main: release 0.42.1 (#1191) (7f9a3c2)
• main: release 0.43.0 (#1196) (3ac84ab)
• main: release 0.43.1 (#1207) (e61c15a)
• main: release 0.44.0 (#1222) (1852308)
• main: release 0.45.0 (#1232) (da886d4)
• main: release 0.46.0 (#1244) (b9bf009)
• main: release 0.47.0 (#1259) (887297f)
• main: release 0.48.0 (#1284) (cf6e54f)
• main: release 0.49.0 (#1303) (fb90556)
• main: release 0.49.1 (#1319) (431b8b7)
• main: release 0.49.2 (#1323) (c19f307)
• main: release 0.49.3 (#1327) (102ed1d)
• main: release 0.50.0 (#1344) (a860a76)
• main: release 0.51.0 (#1348) (2b273f7)
• main: release 0.52.0 (#1363) (e122715)
• main: release 0.53.0 (#1401) (80488da)
• main: release 0.53.1 (#1406) (8f5ac41)
• main: release 0.54.0 (#1431) (6b6b55d)
• main: release 0.55.0 (#1449) (1a00052)
• main: release 0.55.1 (#1469) (509ce3f)
• main: release 0.56.0 (#1493) (9a5fc2c)
• main: release 0.56.1 (#1504) (00fc00c)
• main: release 0.56.2 (#1505) (f950dac)
• main: release 0.56.3 (#1511) (9c69643)
• main: release 0.56.4 (#1519) (d0384b6)
• main: release 0.56.5 (#1555) (41663ee)
• main: release 0.57.0 (#1570) (44b96cf)
• main: release 0.58.0 (#1587) (6b20b8d)
• main: release 0.58.1 (#1616) (4780ba0)
• main: release 0.58.2 (#1621) (1c34ac1)
• main: release 0.59.0 (#1622) (afb18aa)
• main: release 0.60.0 (#1641) (ab4d49f)
• main: release 0.60.0 (#1665) (ea23020)
• main: release 0.60.0 (#1667) (9d3e40f)
• main: release 0.60.1 (#1649) (56a9b2e)
• main: release 0.61.0 (#1655) (2fbe15a)
• Move titlelinter workflow (#843) (be6c454)
• release 0.34.0 (836dfcb)
• update docs (#1297) (495558c)
• Update go files (#839) (5515443)
• update-license (#1190) (e9cfc3e)
• Upgarde all dependencies to latest (#878) (2f1c91a)