Skip to content

This feature is currently in Preview.

REASONER_COST()

relationalai.observability_preview
REASONER_COST(
START_TS TIMESTAMP_NTZ,
END_TS TIMESTAMP_NTZ DEFAULT NULL,
EDITION STRING DEFAULT 'STANDARD',
RAI_UNIT_PRICE NUMBER(10,2) DEFAULT NULL,
SNOWFLAKE_CREDIT_PRICE NUMBER(10,2) DEFAULT NULL
)

A preview table function that estimates Snowflake and RelationalAI costs for each reasoner in the selected time window. It applies the supplied or edition-based prices to the usage estimates. 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.
EDITIONSTRINGEdition used to determine default prices. Defaults to STANDARD. Supported values are STANDARD, ENTERPRISE, and BUSINESS CRITICAL.
RAI_UNIT_PRICENUMBER(10,2)Optional custom price in U.S. dollars per RelationalAI unit. Defaults to NULL, which uses the price for EDITION.
SNOWFLAKE_CREDIT_PRICENUMBER(10,2)Optional custom price in U.S. dollars per Snowflake credit. Defaults to NULL, which uses the price for EDITION.

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_COST_USDNUMBER(38,8)Estimated Snowflake cost in U.S. dollars.
RAI_COST_USDNUMBER(38,8)Estimated RelationalAI cost in U.S. dollars.

When the corresponding custom price is NULL, the function uses the following default price for both a Snowflake credit and a RelationalAI unit:

EditionDefault price per credit or unit
STANDARD$2
ENTERPRISE$3
BUSINESS CRITICAL$4

A custom RAI_UNIT_PRICE overrides only the RelationalAI unit price. A custom SNOWFLAKE_CREDIT_PRICE overrides only the Snowflake credit price.

Estimate costs between two UTC timestamps using the default STANDARD prices:

SELECT *
FROM TABLE(
relationalai.observability_preview.REASONER_COST(
'2026-11-01 00:00:00'::TIMESTAMP_NTZ,
'2026-11-02 00:00:00'::TIMESTAMP_NTZ
)
)
ORDER BY START_TIMESTAMP DESC;
  • Estimates depend on the instance-family rates used by REASONER_USAGE(). Runs on instance families without a matching rate contribute nothing, so estimates may be incomplete or NULL if no runs have a matching rate.
  • An unsupported EDITION does not match a default price. A cost column is NULL if neither a supported edition price nor a custom price is available for that measure.