Syntax¶

WAREHOUSE_LOAD_HISTORY([DATE_RANGE_START=><constant_expr>][,DATE_RANGE_END=><constant_expr>][,WAREHOUSE_NAME=>'<string>'])

Arguments¶

All the arguments are optional.

DATE_RANGE_START=>constant_expr ,.DATE_RANGE_END=>constant_expr

The date range, within the last 14 days, for which to retrieve warehouse load history data:

• If an end date is not specified, thenCURRENT_DATE is used as the end of the range.

• If a start date is not specified, then the range starts 10 minutes prior to the start ofDATE_RANGE_END (i.e. the default is to show the previous 10 minutes of load history). For example,ifDATE_RANGE_END isCURRENT_DATE, then the defaultDATE_RANGE_START is 11:50 PM on theprevious day.

If the range falls outside the last 15 days, an error is returned.

Note

If the selected period is less than 8 hours, load is shown in 5-second intervals; otherwise, 5-minute intervals are used.

WAREHOUSE_NAME=>'string'

The name of the warehouse to retrieve usage load history for. Note that the warehouse name must be enclosed in single quotes. Also, if the warehouse name contains any spaces, mixed-case characters,or special characters, the name must be double-quoted within the single quotes (e.g.'"MyWarehouse"' vs'mywarehouse').

Default:CURRENT_WAREHOUSE

Usage notes¶

• To get results from this function, one of the following roles or privileges are required:

  • The ACCOUNTADMIN role can get results from this function as it has all of the global account permissions.

  • A role with the MONITOR USAGE global privilege on the ACCOUNT can query this function for any warehouses in the account.

  • A role with the MONITOR privilege on the WAREHOUSE can query this function for the warehouse it has permissions on.

  • A role with the OWNERSHIP privilege on the WAREHOUSE has all permissions on the warehouse including MONITOR.

  For more details, seeAccess control privileges.

• When calling an Information Schema table function, the session must have an INFORMATION_SCHEMA schema in useor the function name must be fully-qualified. For more details, seeSnowflake Information Schema.

Output¶

The function returns the following columns:

Examples¶

Retrieve the load history for the last hour, in 5-second intervals, for the warehouse currently in use for your session:

usewarehousemywarehouse;select*fromtable(information_schema.warehouse_load_history(date_range_start=>dateadd('hour',-1,current_timestamp())));

Copy

Retrieve the load history for the last 14 days, in 5-minute intervals, for the warehouse currently in use for your session:

usewarehousemywarehouse;select*fromtable(information_schema.warehouse_load_history(date_range_start=>dateadd('day',-14,current_date()),date_range_end=>current_date()));

Copy