search

sundeck-io / OpsCenter

OpsCenter for Snowflake makes it easy to understand and manage your Snowflake consumption
Other
25 stars 15 forks source link

warehouse load history #606

Closed rymurr closed 7 months ago

rymurr commented 7 months ago

calling call internal.refresh_one_warehouse_load_history('COMPUTE_WH');

produces the sql statement

insert into internal_reporting_mv.warehouse_load_history select start_time, end_time, warehouse_name, avg_running, avg_queued_load, avg_queued_provisioning, avg_blocked from table(dryan.information_schema.warehouse_load_history(date_range_start => to_timestamp_ltz('2024-03-14 10:43:51.973'), date_range_end => to_timestamp_ltz('2024-03-14 18:43:51.973'), warehouse_name => 'COMPUTE_WH'))

but fails with

Uncaught exception of type 'STATEMENT_ERROR' on line 19 at position 8 : Stored procedure execution error: Requested information on the current user is not accessible in stored procedure.