Snowflake permissions - Insufficient privileges to operate on table

Help
,
1

Hi, I am trying to create a Snowflake user that will run my dbt jobs. I have been using my accountadmin user and it has been fine so far, but when I created a user for dbt purposes only, I am encountering problems with the grants the role should have and keep getting ‘Insufficient privileges to operate on table xx’ message when I try to do a dbt run (in dbt cloud).

I have granted a lot of privileges to the database, schema, tables, views, and when I check a particular table I can see the dbt user has all these privileges:

APPLYBUDGET
DELETE
EVOLVE SCHEMA
INSERT
REBUILD
REFERENCES
SELECT
TRUNCATE
UPDATE

The only privilege that is missing is the OWNERSHIP, but it belongs to the accountadmin, so I am running out of options of what to do to keep a separate user with the minimum amount of privileges that are required for dbt.

I appreciate all the help I can get :slight_smile:

2

Hi @lau_com, does your role also have the right level of perms on the WAREHOUSE?

2 Likes
3

These are the privileges that the role has on the warehouse:
APPLYBUDGET
MODIFY
MONITOR
OPERATE
USAGE

4

I’m wondering if you also need USAGE on the database/schema @lau_com.

5

I also have that on all databases and schemas