REASONER_COST()
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.
Parameters
Section titled “Parameters”| Name | Type | Description |
|---|---|---|
START_TS | TIMESTAMP_NTZ | Required start of the time window, inclusive. Use a UTC timestamp. |
END_TS | TIMESTAMP_NTZ | Optional end of the time window, exclusive. Defaults to NULL, which includes all matching telemetry from START_TS onward. |
EDITION | STRING | Edition used to determine default prices. Defaults to STANDARD. Supported values are STANDARD, ENTERPRISE, and BUSINESS CRITICAL. |
RAI_UNIT_PRICE | NUMBER(10,2) | Optional custom price in U.S. dollars per RelationalAI unit. Defaults to NULL, which uses the price for EDITION. |
SNOWFLAKE_CREDIT_PRICE | NUMBER(10,2) | Optional custom price in U.S. dollars per Snowflake credit. Defaults to NULL, which uses the price for EDITION. |
Returns
Section titled “Returns”One row per reasoner in the selected time window:
| Column | Type | Description |
|---|---|---|
REASONER_ID | STRING | Reasoner identifier from the event attributes. |
REASONER_NAME | STRING | Reasoner name from the event attributes. |
REASONER_TYPE | STRING | Reasoner type from the event attributes; may be NULL if it is not present in the telemetry. |
START_TIMESTAMP | TIMESTAMP_NTZ | Earliest metric timestamp observed for the reasoner in the window, in UTC. |
END_TIMESTAMP | TIMESTAMP_NTZ | Latest metric timestamp observed for the reasoner in the window, in UTC. |
SNOWFLAKE_COST_USD | NUMBER(38,8) | Estimated Snowflake cost in U.S. dollars. |
RAI_COST_USD | NUMBER(38,8) | Estimated RelationalAI cost in U.S. dollars. |
Default prices
Section titled “Default prices”When the corresponding custom price is NULL, the function uses the following default price for both a Snowflake credit and a RelationalAI unit:
| Edition | Default 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.
Example
Section titled “Example”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 orNULLif no runs have a matching rate. - An unsupported
EDITIONdoes not match a default price. A cost column isNULLif neither a supported edition price nor a custom price is available for that measure.