Documentation
Toggle Dark/Light/Auto modeToggle Dark/Light/Auto modeToggle Dark/Light/Auto modeBack to homepage
  1. Docs
  2. /
  3. Reference
  4. /
  5. Stored Procedures
  6. /
  7. Settings
  8. /
  9. RELOAD_QUERY_HISTORY

RELOAD_QUERY_HISTORY

Stored procedure 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 ADMIN. 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:
RELOAD_PRECONFIGURED_DATA

Syntax 

RELOAD_QUERY_HISTORY()

Arguments

None

Returns

NULL
if query history was successfully reloaded.
<error>
error message string in the case of failure to reload query history.

Example: