RELOAD_QUERY_HISTORY is a SQL Snowflake stored procedure that reloads the materialized query history and warehouse events data from customer’s Snowflake ACCOUNT_USAGE database.
This procedure is defined in the database
OPSCENTER (database where Snowflake NativeApp is installed) schema
ACCOUNTADMIN privilege is required to run this stored procedure.
This is syncronous operation and might take some time if your query_history table is large.
- See also:
- if query history was successfully reloaded.
- error message string in the case of failure to reload query history.