feat: Create a snowflake_user_grant resource.

[hleb-lizunkou1]

Create a snowflake_user_grant resource.

Test Plan

• acceptance tests
• unit tests
• tested in my snowflake account

References

(Feature Request) Create resource snowflake_user_grant

[sfc-gh-swinkler]

what is with the weird id format? why have ||| instead of |?

[hleb-lizunkou1]

Actually this format is used everywhere, i'm just trying to follow codebase format

terraform-provider-snowflake/docs/resources/integration_grant.md

Lines 49 to 50 in 72c3180

	# format is integration name ||| privilege | true/false for with_grant_option
	terraform import snowflake_integration_grant.example 'intName|||USAGE|true'

terraform-provider-snowflake/docs/resources/account_grant.md

Lines 42 to 43 in 72c3180

	# format is account name | | | privilege | true/false for with_grant_option
	terraform import snowflake_account_grant.example 'accountName|||USAGE|true'

[sfc-gh-swinkler]

is it possible to read the role to determine if with_grant_option has been set already? it would be nice if this could actually be read, rather than just set from the id. i know we don't do that anywhere else, i am just wondering.

[hleb-lizunkou1]

propably yes, i beleive it's better to make in separte PR for it to have the same approach for all grants resources

[sfc-gh-swinkler]

/ok-to-test sha=1b03a11

[github-actions]

Integration tests failure for 1b03a11

[sfc-gh-swinkler]

Hello @hleb-lizunkou1 . Getting the following error message when running integration tests:

     Error: 003008 (42601): SQL compilation error:
        Invalid object type 'USER' for privilege 'USAGE'.
        
          on terraform_plugin_test.tf line 11, in resource "snowflake_user_grant" "test":
          11: resource "snowflake_user_grant" "test" {

--- FAIL: TestAcc_UserGrant (3.87s)

[hleb-lizunkou1]

@sfc-gh-swinkler i have updated PR with fix please take a look at last commit

[sfc-gh-swinkler]

/ok-to-test sha=a6d207e

[github-actions]

Integration tests failure for a6d207e

[sfc-gh-swinkler]

hi @hleb-lizunkou1 can you please run make docs? also it looks like integration tests failed with the following error message:

=== CONT  TestAcc_UserGrant
    user_grant_acceptance_test.go:20: Step 1/2 error: Check failed: Check 2/2 error: snowflake_user_grant.test: Attribute 'privilege' expected "MONITORING", got "MONITOR"

[hleb-lizunkou1]

hi @sfc-gh-swinkler i have run make docs and fixed integration tests

[sfc-gh-swinkler]

/ok-to-test sha=0dede64

[github-actions]

Integration tests success for 0dede64

[sfc-gh-swinkler]

@Hleb-Lizunkou thank you for your contribution!