Skip to content

snowflake function grant failing with arguments #477

Answered by reebz84
reebz84 asked this question in Q&A
Discussion options

You must be logged in to vote

We figured this out! It needs to look like

resource "snowflake_function_grant" "get_lock_date_grants" {
  database_name   = "db"
  schema_name     = "schema"
  function_name   = "myfunc"
  arguments {
    name= "START_DATE"
    type= "date"
  }
  arguments {
    name= "END_DATE"
    type= "date"
  }
  return_type     = "date"
  privilege       = "USAGE"
  roles           = ["SYSADMIN"]
  on_future         = false
}```

Replies: 2 comments

Comment options

You must be logged in to vote
0 replies
Answer selected by reebz84
Comment options

You must be logged in to vote
0 replies
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Category
Q&A
Labels
None yet
2 participants