Open hnmpatel opened 1 month ago
Also common_shared_db
is not created from share. It's standard database created within reader account only. Procedure gets created but plan execution still fails with the error as given in issue details.
Hi @hnmpatel 👋 It seems like you are not authorized to do a DESCRIBE
query on the procedure. Please make sure you have proper grants. For more information, please provide more detailed logs with TF_LOG=DEBUG
.
@sfc-gh-jmichalak Is it possible that, role can create procedure but do not have permission to describe? If we have to grant separate grants then could you please give reference?
I see that you're using a separate reader account for reading procedures, right? It seems like show operation is not permitted (docs), so maybe it affects describe operation as well? Please check on your reader account to see if you can run show and describe procedures. If it's not possible, then it's just a Snowflake limitation, and I would advise using a regular account for this resource.
@hnmpatel did you have a chance to verify what @sfc-gh-jmichalak suggested?
Yeah the show and describe are not possible in the reader account hence I had to use null resources for that.
Okay, thanks! So I understand that because this is a Snowflake limitation, we can close this issue?
Terraform CLI Version
0.14.11
Terraform Provider Version
0.94.1
Terraform Configuration
Category
category:resource
Object type(s)
resource:procedure
Expected Behavior
It should have created successfully, and plan should have been applied without any error.
Actual Behavior
Failed with error as following
Steps to Reproduce
Use terraform configuration and just hit terraform apply after making plan
How much impact is this issue causing?
High
Logs
No response
Additional Information
No response
Would you like to implement a fix?