Skip to content

This feature is currently in Preview.

REASONER_USAGE()

relationalai.observability_preview
REASONER_USAGE(START_TS TIMESTAMP_NTZ, END_TS TIMESTAMP_NTZ DEFAULT NULL)

A preview table function that estimates Snowflake credits and RelationalAI units used by each reasoner in the selected time window. It applies hourly rates for each instance family to the observed run durations. These estimates are not billing records.

Before querying, enable app observability and use an active Snowflake warehouse. Requires the observability_viewer or observability_admin application role.

NameTypeDescription
START_TSTIMESTAMP_NTZRequired start of the time window, inclusive. Use a UTC timestamp.
END_TSTIMESTAMP_NTZOptional end of the time window, exclusive. Defaults to NULL, which includes all matching telemetry from START_TS onward.

One row per reasoner in the selected time window:

ColumnTypeDescription
REASONER_IDSTRINGReasoner identifier from the event attributes.
REASONER_NAMESTRINGReasoner name from the event attributes.
REASONER_TYPESTRINGReasoner type from the event attributes; may be NULL if it is not present in the telemetry.
START_TIMESTAMPTIMESTAMP_NTZEarliest metric timestamp observed for the reasoner in the window, in UTC.
END_TIMESTAMPTIMESTAMP_NTZLatest metric timestamp observed for the reasoner in the window, in UTC.
SNOWFLAKE_CREDITSNUMBER(38,8)Estimated Snowflake credits, calculated from observed run durations and instance-family rates.
RAI_UNITSNUMBER(38,8)Estimated RelationalAI units, calculated from observed run durations and instance-family rates.

Estimate usage between two UTC timestamps:

SELECT *
FROM TABLE(
relationalai.observability_preview.REASONER_USAGE(
'2026-11-01 00:00:00'::TIMESTAMP_NTZ,
'2026-11-02 00:00:00'::TIMESTAMP_NTZ
)
)
ORDER BY START_TIMESTAMP DESC;
  • The function uses hourly rates keyed by INSTANCE_FAMILY. Runs on instance families without a matching rate contribute nothing, so estimates may be incomplete or NULL if no runs have a matching rate.
  • The result aggregates the runs for each reasoner in the selected window. Its timestamps show the earliest and latest observed metric timestamps for those runs.