I have a free trial account for Snowflake. I am trying to create storage integration. But after running the script I am getting below error :
SQL access control error: Insufficient privileges to operate on account ''
Even for the Account Admin role, above error is coming.
There are two places to set your role in the Snowflake web UI. You need to make sure you're changing to the ACCOUNTADMIN role for the right context:
If you're getting the error when running a SQL statement from the web UI, check your current role for the worksheet. You can click on the icon or role text to change it.
In this example, you can see that I've changed my role in the upper right to ACCOUNTADMIN, but that changes only my role for the button bar. I'm still using the SYSADMIN role when running SQL statements in a worksheet.
Also note that each worksheet has its own context, so changing worksheets could change your role if it's set differently on the worksheet you're opening.
