0

I am getting the error "SQL access control error: Insufficient privileges to operate on account 'XXXXXX'" when I try to create a role in Snowflake in order to get it connected to Segment.

I am following the Segment documentation here: https://segment.com/docs/connections/warehouses/catalog/snowflake/

And I am getting stuck when I run the command "CREATE ROLE "SEGMENT";"

Any help in how to get around this would be great. I am currently on the trial and was able to successfully create the data warehouse and database as per the segment instructions.

quantumofnolace
  • 125
  • 7
  • Are you explicitly setting your role as ACCOUNTADMIN (i.e use role accountadmin;) before trying this? Do you have access to the SECURITYADMIN role and if so could you try creating the role with that? – Mike Donovan Feb 19 '20 at 20:01

1 Answers1

1

Thanks to Greg in the comments: "An easy way to remember it is that the upper right role is for UI actions, while the lower one sets the context for the worksheet"

1) while I had the correct profile up here

2) once I clicked this

3) I did not have the right profile in here

After switching to ACCOUNTADMIN in 3) I was able to create the role.

screenshot of how I fixed it

quantumofnolace
  • 125
  • 7
  • This is the #1 most common mistake made when choosing roles in the Snowflake UI. – Mike Walton Feb 19 '20 at 20:56
  • Was surprised that there was no questions about this already or at least not that came up with a quick google. If you have any recommendations on how I could change the title of the question for it to be better found through search let me know. – quantumofnolace Feb 19 '20 at 21:37
  • 1
    Thank you for the screenshot. An easy way to remember it is that the upper right role is for UI actions, while the lower one sets the context for the worksheet. – Greg Pavlik Feb 19 '20 at 23:42