What causes 090106 (42501)?

USAGE on the warehouse was never granted to the role. The warehouse name is misspelled in the connection string or session configuration. A role change removed warehouse access. The warehouse was recreated and the USAGE grant was not reapplied. The connection is using a different role than expected (check the active role with SELECT CURRENT_ROLE())

How do I fix 090106 (42501)?

Grant warehouse access: GRANT USAGE ON WAREHOUSE TO ROLE . Verify the warehouse name: SHOW WAREHOUSES. Check the active role: SELECT CURRENT_ROLE(). If the role recently changed, re-verify that USAGE was granted to the new role. Check the connection string or BI tool configuration for the correct warehouse name and role

High severityaccess control

Power BI Refresh Error:
090106 (42501)

What does this error mean?

The session cannot use the specified Snowflake virtual warehouse because the current role does not have USAGE privilege on it. Without warehouse access, no SQL queries can execute.

Common causes

1USAGE on the warehouse was never granted to the role
2The warehouse name is misspelled in the connection string or session configuration
3A role change removed warehouse access
4The warehouse was recreated and the USAGE grant was not reapplied
5The connection is using a different role than expected (check the active role with SELECT CURRENT_ROLE())

How to fix it

1Grant warehouse access: GRANT USAGE ON WAREHOUSE <wh_name> TO ROLE <role>
2Verify the warehouse name: SHOW WAREHOUSES
3Check the active role: SELECT CURRENT_ROLE()
4If the role recently changed, re-verify that USAGE was granted to the new role
5Check the connection string or BI tool configuration for the correct warehouse name and role

Frequently asked questions

What is the minimum privilege needed to run queries on a warehouse?

USAGE on the warehouse. To start a suspended warehouse automatically when executing a query, USAGE is sufficient if AUTO_RESUME is enabled on the warehouse.

Can I grant USAGE to all roles at once?

You can grant USAGE to the PUBLIC role, which all users inherit. However, this gives everyone access to the warehouse — use with caution.