Sign in

v5

latestOpenAPI 3.1.02026-08-081,0211,3082.1 MB
PREDICTION

Predict Query Time

Predict query execution time with confidence intervals.

Returns median prediction with 80% confidence interval. Uses model_with_historical for repeated queries or model_without_historical for new queries.

post/predict/query-time-estimate

Request body

query_textstring required

SQL query text to predict execution time for

warehouse_size'X-Small' | 'Small' | 'Medium' | 'Large' | 'X-Large' | '2X-Large' | '3X-Large' | '4X-Large'

Snowflake warehouse size

warehouse_type'UNKNOWN' | 'STANDARD_GEN_1' | 'STANDARD_GEN_2' | 'MEMORY_16X'

Warehouse generation/type

Response

Successful Response

predicted_msnumber required

Median prediction (q50) in milliseconds

quantilesobject required

All quantile predictions: q10, q50, q90

model_used'with_historical' | 'without_historical' required

with_historical (repeated query) or without_historical (new query)

query_hashstring required

Computed query hash