79804887

Date: 2025-10-30 14:45:13
Score: 0.5
Natty:
Report link

SNOWFLAKE.ACCOUNT_USAGE.QUERY_HISTORY is a view. and also account admin has no access to the source. I guess you may challenge the security parameters of that view but I am not sure it will do the work.

Instead, I would consider to execute a predefined task that will extract this data into a table the app can access. it will take a few seconds of delay but you will get the data.

make sure in the CREATE TASK to RUN AS OWNER without a schedule.
then EXECUTE IMMEDIATE <TASK_NAME>;

I hope it will work for you

Reasons:
  • Long answer (-0.5):
  • Has code block (-0.5):
  • Starts with a question (0.5): is a
  • Low reputation (1):
Posted by: YGoldner