CODEWITHSUNDEEP
snowflake-cloud-data-platformwarehouse
VermaC
VermaC

Reputation: 53

In snowflake error while creating warehouse using RESOURCE_MONITOR with sysadmin role

In snowflake, we are creating a warehouse but when we create a warehouse with resource_moniter clause(it was created by accountadmin ) by sysadmin role it gives access level error. we have given all privileges to sysadmin on this resource monitor but it doesn't work.

can someone help in the creation of a warehouse without using "accountadmin" role?

Upvotes: 0

Views: 646

Answers (2)

Gokhan Atil
Gokhan Atil

Reputation: 10144

It's not possible to create a warehouse with Resource Monitor unless you use the accountadmin role (even if you change the ownership of the resource monitor). Please note that, when you assign a resource monitor to a warehouse, you do not only affect the warehouse, you also affect the resource monitor because it might be shared by other users.

You need to create the warehouse, and then assign the resource monitor to the warehouse using the accountadmin role.

Upvotes: 0

Srinath Menon
Srinath Menon

Reputation: 1640

CREATE WAREHOUSE privilege as listed here https://docs.snowflake.com/en/user-guide/security-access-control-privileges.html

must be granted by the accountadmin role to any other role which is being used for this operation.

By default sysadmin role would have this privilege, if not, then grant the privilege as accountadmin and use the sysadmin role to run the create operation.

Upvotes: 0

Related Questions