curl --request POST \
  --url https://api.select.dev/v2/metrics/snowflake-warehouses/query \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --header 'x-tenant-id: <x-tenant-id>' \
  --data '
{
  "measures": [
    "utilization_efficiency_percent",
    "idle_spend",
    "spend"
  ],
  "dimensions": [
    "hour",
    "snowflake_account_name"
  ],
  "filter_expression": {
    "operator": "and",
    "filters": [
      {
        "field": "day",
        "operator": "in range",
        "value": "2D"
      },
      {
        "field": "warehouse_name",
        "operator": "=",
        "value": "COMPUTE_WH"
      }
    ]
  },
  "sort": [
    {
      "field": "hour",
      "direction": "asc"
    }
  ],
  "limit": 1000
}
'

{
  "items": [
    {}
  ],
  "page_token": "<string>",
  "row_count": 123,
  "sql": "<string>"
}

{
  "title": "<string>",
  "status": 123,
  "detail": "<string>",
  "code": "validation_failed",
  "retryable": true,
  "type": "about:blank",
  "details": [
    {}
  ]
}

{
  "title": "<string>",
  "status": 123,
  "detail": "<string>",
  "code": "validation_failed",
  "retryable": true,
  "type": "about:blank",
  "details": [
    {}
  ]
}

{
  "title": "<string>",
  "status": 123,
  "detail": "<string>",
  "code": "validation_failed",
  "retryable": true,
  "type": "about:blank",
  "details": [
    {}
  ]
}

{
  "title": "<string>",
  "status": 123,
  "detail": "<string>",
  "code": "validation_failed",
  "retryable": true,
  "type": "about:blank",
  "details": [
    {}
  ]
}

{
  "title": "<string>",
  "status": 123,
  "detail": "<string>",
  "code": "validation_failed",
  "retryable": true,
  "type": "about:blank",
  "details": [
    {}
  ]
}

{
  "title": "<string>",
  "status": 123,
  "detail": "<string>",
  "code": "validation_failed",
  "retryable": true,
  "type": "about:blank",
  "details": [
    {}
  ]
}

{
  "title": "<string>",
  "status": 123,
  "detail": "<string>",
  "code": "validation_failed",
  "retryable": true,
  "type": "about:blank",
  "details": [
    {}
  ]
}

{
  "title": "<string>",
  "status": 123,
  "detail": "<string>",
  "code": "validation_failed",
  "retryable": true,
  "type": "about:blank",
  "details": [
    {}
  ]
}

{
  "title": "<string>",
  "status": 123,
  "detail": "<string>",
  "code": "validation_failed",
  "retryable": true,
  "type": "about:blank",
  "details": [
    {}
  ]
}

{
  "title": "<string>",
  "status": 123,
  "detail": "<string>",
  "code": "validation_failed",
  "retryable": true,
  "type": "about:blank",
  "details": [
    {}
  ]
}

{
  "title": "<string>",
  "status": 123,
  "detail": "<string>",
  "code": "validation_failed",
  "retryable": true,
  "type": "about:blank",
  "details": [
    {}
  ]
}

metrics

Query Snowflake warehouses

One row per group of Snowflake warehouse utilization, spend and savings. Activity is grouped to the hour for a request that asks about hours, and to the day otherwise. sql in the response is populated for requests that read the hourly table and is null for requests that read the daily table.

Returns one row per combination of the requested dimensions, carrying the requested measures. Each row is keyed by dimension and measure name. row_count is the number of rows in items: results are not paginated, so an aggregation with more rows than limit is cut short at limit rather than continued under a page_token. Send X-Team-Id to evaluate the query as a team you belong to; rows are then limited to what that team’s roles reach.

Use this route for the utilization, idle spend and automated savings of each Snowflake warehouse. A row is one warehouse for one day, or for one hour. spend is dollars: the metering spend of the warehouse for compute, cloud services after the daily adjustment, and query acceleration, including idle time. The sum_spend measure of snowflake-workloads is the cost that SELECT gives to each query, so its total is slightly different. The SELECT app’s Warehouses page ranks warehouses by cost with snowflake-workloads, and gets utilization and savings from this route. For each cluster, use snowflake-warehouse-clusters. For query latency, queueing and spilling, use snowflake-warehouse-query-performance. utilization_efficiency_percent and idle_percent are 0 to 100. idle_percent is the part of the running cluster time in which no query ran. The *_annualized measures are run-rates, not spend.

warehouse_generation is 1, 2, or not_applicable for a warehouse that is not a standard warehouse. On the hourly table it is the generation at the start of the hour. On the daily table it is the generation of the hours in which the warehouse was active, or of all hours of the day if the warehouse was not active. It is null when those hours have different generations, or when the generation of one of them is not known.

POST

metrics

snowflake-warehouses

query

curl --request POST \
  --url https://api.select.dev/v2/metrics/snowflake-warehouses/query \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --header 'x-tenant-id: <x-tenant-id>' \
  --data '
{
  "measures": [
    "utilization_efficiency_percent",
    "idle_spend",
    "spend"
  ],
  "dimensions": [
    "hour",
    "snowflake_account_name"
  ],
  "filter_expression": {
    "operator": "and",
    "filters": [
      {
        "field": "day",
        "operator": "in range",
        "value": "2D"
      },
      {
        "field": "warehouse_name",
        "operator": "=",
        "value": "COMPUTE_WH"
      }
    ]
  },
  "sort": [
    {
      "field": "hour",
      "direction": "asc"
    }
  ],
  "limit": 1000
}
'

{
  "items": [
    {}
  ],
  "page_token": "<string>",
  "row_count": 123,
  "sql": "<string>"
}

{
  "title": "<string>",
  "status": 123,
  "detail": "<string>",
  "code": "validation_failed",
  "retryable": true,
  "type": "about:blank",
  "details": [
    {}
  ]
}

{
  "title": "<string>",
  "status": 123,
  "detail": "<string>",
  "code": "validation_failed",
  "retryable": true,
  "type": "about:blank",
  "details": [
    {}
  ]
}

{
  "title": "<string>",
  "status": 123,
  "detail": "<string>",
  "code": "validation_failed",
  "retryable": true,
  "type": "about:blank",
  "details": [
    {}
  ]
}

{
  "title": "<string>",
  "status": 123,
  "detail": "<string>",
  "code": "validation_failed",
  "retryable": true,
  "type": "about:blank",
  "details": [
    {}
  ]
}

{
  "title": "<string>",
  "status": 123,
  "detail": "<string>",
  "code": "validation_failed",
  "retryable": true,
  "type": "about:blank",
  "details": [
    {}
  ]
}

{
  "title": "<string>",
  "status": 123,
  "detail": "<string>",
  "code": "validation_failed",
  "retryable": true,
  "type": "about:blank",
  "details": [
    {}
  ]
}

{
  "title": "<string>",
  "status": 123,
  "detail": "<string>",
  "code": "validation_failed",
  "retryable": true,
  "type": "about:blank",
  "details": [
    {}
  ]
}

{
  "title": "<string>",
  "status": 123,
  "detail": "<string>",
  "code": "validation_failed",
  "retryable": true,
  "type": "about:blank",
  "details": [
    {}
  ]
}

{
  "title": "<string>",
  "status": 123,
  "detail": "<string>",
  "code": "validation_failed",
  "retryable": true,
  "type": "about:blank",
  "details": [
    {}
  ]
}

{
  "title": "<string>",
  "status": 123,
  "detail": "<string>",
  "code": "validation_failed",
  "retryable": true,
  "type": "about:blank",
  "details": [
    {}
  ]
}

{
  "title": "<string>",
  "status": 123,
  "detail": "<string>",
  "code": "validation_failed",
  "retryable": true,
  "type": "about:blank",
  "details": [
    {}
  ]
}

Authorizations

Authorization

string

header

required

Organization API key (sl_…).

Headers

x-team-id

string<uuid> | null

Act as this team: rows are limited to what the team's roles reach instead of the caller's own. The caller must be a member of the team or hold the organization-wide permission the route requires.

x-tenant-id

string

required

The organization ID the request is scoped to.

Body

application/json

Aggregate Snowflake warehouse utilization, spend and savings over a period.

Warehouse metrics are stored twice, rolled up to the day and to the hour. A request naming hour, start_hour_of_day or start_hours_of_day reads the hourly table; anything else reads the daily rollup, which includes action-savings overlays the hourly table does not carry.

usage_group_sets

UsageGroupSetDefinitionV2 · object[] | null

Categorize against these set definitions instead of the organization's saved usage group sets, for evaluating a set before saving it. Omit to use the saved sets, which is what every other surface reports against.

Show child attributes

measures

(SemiStructuredMeasure[OrgHourlyWarehouseMetricsDimensions] · object | enum<string>)[]

Aggregates to compute over the matching rows.

Show child attributes

dimensions

(SemiStructuredDimension[OrgHourlyWarehouseMetricsDimensions] · object | enum<string>)[]

Columns to group the aggregates by. Each is returned on every row.

Show child attributes

filter_expression

FilterExpression[Union[SemiStructuredDimension[OrgHourlyWarehouseMetricsDimensions], OrgHourlyWarehouseMetricsDimensions]] · object | null

An and/or tree of predicates over dimensions, applied before aggregation. Omit to match every row the caller can see.

Show child attributes

measure_filters

(InFilter[SnowflakeWarehouseMeasures] · object | ArrayContainsFilter[SnowflakeWarehouseMeasures] · object | IsFilter[SnowflakeWarehouseMeasures] · object | LikeFilter[SnowflakeWarehouseMeasures] · object | MultiLikeFilter[SnowflakeWarehouseMeasures] · object | EqFilter[SnowflakeWarehouseMeasures] · object | FilterExpression[SnowflakeWarehouseMeasures] · object | InRelativeDateRangeFilter[SnowflakeWarehouseMeasures] · object)[]

Predicates over measures, applied after aggregation.

InFilter[SnowflakeWarehouseMeasures]
ArrayContainsFilter[SnowflakeWarehouseMeasures]
IsFilter[SnowflakeWarehouseMeasures]
LikeFilter[SnowflakeWarehouseMeasures]
MultiLikeFilter[SnowflakeWarehouseMeasures]
EqFilter[SnowflakeWarehouseMeasures]
FilterExpression[SnowflakeWarehouseMeasures]
InRelativeDateRangeFilter[SnowflakeWarehouseMeasures]

Show child attributes

sort

Sort[SnowflakeWarehouseMeasures, OrgHourlyWarehouseMetricsDimensions] · object[]

Ordering applied to the aggregated rows.

Show child attributes

limit

integer | null

Maximum rows to return. Omit for no limit. An aggregation that produces more rows than this is silently cut short at the limit.

Required range: x >= 1

return_sql

boolean

default:false

Return the SQL that produced the rows alongside them, for inspecting how a result was computed. Not every query endpoint publishes its SQL; where it does not, the field stays null.

pivot

PivotConfig · object | null

Reshape the result so the named dimensions become columns rather than rows. Each remaining dimension yields one row, carrying a pivot_data object keyed by the pivoted dimension values. Every name in pivot.on must also appear in dimensions.

Show child attributes

rollup

GroupRollupConfig · object | null

Return the result as a tree rather than a flat list, grouping the named dimensions into one level per tree depth. One request fetches the top level; a follow-up naming rollup.parent_paths fetches the children of the nodes expanded so far, so a deep hierarchy is read a level at a time. Every name in rollup.dimensions must also appear in dimensions.

Show child attributes

aggregate

boolean

default:true

Aggregate the matching rows. Set false to return the underlying rows as they are, projecting the requested dimensions with no grouping — a listing rather than an aggregation. It is honored only for a request that asks for no measures and no measure_filters, since an aggregate has to group to be computable; limit, when set, bounds the rows returned either way.

Response

Successful Response

items

Items · object[]

required

page_token

string | null

Opaque cursor for the next page; empty/absent on the last page.

row_count

integer | null

Best-effort total for the filtered result set; may be null when expensive.

sql

string | null

The SQL that produced these rows, returned only when the request asks for it. Database and schema names are left as placeholders. Null when the request did not ask for it, or when this endpoint does not publish its SQL.

Get Started

Endpoints

Query Snowflake warehouses

Authorizations

Headers

Body

Response