Raw_data stage files could not be loaded due to insufficient privileges to operate on the directory_table

[davidmwilliams]

Describe the bug
When following quickstart "Getting Started with Cortex Analyst: Augment BI with AI" it says to check stage files have uploaded by clicking the stage, but Snowflake gives an error 'stage files could not be loaded ... insufficient privileges to operate on directory_table'

URL of where you see the bug
https://quickstarts.snowflake.com/guide/getting_started_with_cortex_analyst/#2

To Reproduce
Steps to reproduce the behavior:

1. Open Snowflake
2. Run the SQL on the previous page
3. Click Data / Databases
4. Select cortex_analyst_demo / revenue_timeseries / stages / raw_data

Expected behavior
To see the stage files.

Screenshots

Desktop (please complete the following information):

• OS: [e.g. iOS] Windows
• Browser [e.g. chrome, safari] Chrome
• Version [e.g. 22]

Additional context
Add any other context about the problem here.

[dave-findlay]

Hi @davidmwilliams. Came across your post when I had a the same error in a different project. Noticed that I wasn't using the correct role for my user. In my case I was using ACCOUNTADMIN and not CORTEX_USER_ROLE when I received the error. Changing to CORTEX_USER_ROLE (or whatever the role is that has permissions on those objects) resolved the issue for me.

Not sure if this will help you, but I thought I drop a line in any case.