Skip to main content

SqlWarehouse

A compute class for SQL: size, caps and the groups that may use it.

Spec​

FieldTypeRequiredDefaultDescriptionConstraints
spec.concurrencyobject (nullable)NoOverrides of the class defaults. An absent field keeps the class value.
spec.concurrency.memorySharestring (nullable)NoShare of the engine's memory the class may use, for example 40%.pattern ^([1-9][0-9]?|100)%$
spec.concurrency.queuedinteger (nullable)NoQueries that may wait (the resource group's queue limit).min 0, max 10000; format int32
spec.concurrency.runninginteger (nullable)NoQueries that run at the same time (the resource group's hard concurrency limit).min 1, max 100; format int32
spec.concurrency.schedulingstring (nullable)NoHow queued queries are chosen to run.fifo, fair, weighted, weighted_fair, null
spec.defaultbooleanNofalseThe class that queries land in when nothing selects another one.
spec.displayNamestring (nullable)Nomax 100
spec.grantsarray of objectNo[]max 50
spec.grants[].groupstringYesmin 1, max 64; pattern ^[A-Za-z0-9][A-Za-z0-9._-]*$
spec.lakehouseRefobjectYesThe Lakehouse that hosts a catalog or a warehouse.
spec.lakehouseRef.namestringYesmin 1, max 63; pattern ^[a-z0-9]([-a-z0-9]*[a-z0-9])?$
spec.sizestringNosmallThe platform's compute classes. A class is a name for four numbers (running, queued, memory share, scheduling), not a promise about hardware: the query engine has resource groups, not separate clusters.xs, small, medium, large

Status​

FieldTypeRequiredDefaultDescriptionConstraints
status.conditionsarray of objectNo[]
status.conditions[].lastTransitionTimestring (nullable)No
status.conditions[].messagestring (nullable)No
status.conditions[].observedGenerationinteger (nullable)Noformat int64
status.conditions[].reasonstring (nullable)No
status.conditions[].statusstringYes
status.conditions[].typestringYes
status.enginestring (nullable)NoWhich engine implements the class, for example trino@default.
status.observedGenerationinteger (nullable)Noformat int64
status.phasestringNo""
status.renderedGroupstring (nullable)NoThe resource group actually written.

Validation rules​

  • each group may appear once in grants