Run warehouse queries on Serverless or on a dedicated cluster sized in compute units. Dedicated clusters are in early access.
Early access
Dedicated clusters are in early access. Outside early access, every query runs on Serverless.
Warehouse queries run on Serverless unless they name a dedicated cluster. Serverless is shared capacity that Contrast scales for each query, metered by data scanned under your plan. A dedicated cluster is compute reserved for your workspace: a node type and a number of nodes. Workspace owners and admins create and change clusters under Compute.
Every node in a cluster has the same type. Clusters have 1 to 32 nodes.
| Node type | Compute units an hour |
|---|---|
| 2 vCPU · 8 GB | 1 CU |
| 4 vCPU · 16 GB | 2 CU |
| 8 vCPU · 32 GB | 4 CU |
| 16 vCPU · 64 GB | 8 CU |
| 32 vCPU · 128 GB | 16 CU |
A workspace can have 10 clusters. Owners and admins can change the limit in Settings → Admin.
A query runs on a cluster only when it names one. If that cluster can't run the query, the query fails; it never falls back to Serverless.
contrast query run "<sql>" --compute bi-dashboardsSET contrast.compute = 'bi-dashboards', and RESET contrast.compute to return to Serverless.You can name a cluster by its name or its id.
A cluster runs read-only SELECT queries while it is Running or Resizing; writes, SHOW and DESCRIBE run on Serverless. A query on a cluster is written in the same SQL as on Serverless. If the cluster can't run a query's SQL, the query fails and says why. When a cluster is busy, a query waits for room until its timeout.
A compute unit (CU) is how Contrast measures dedicated compute: 2 vCPU and 8 GB of memory for one hour. Node types double in size, so each uses twice the compute units of the one below it, from 1 CU an hour for 2 vCPU to 16 CU an hour for 32 vCPU.
Multiply the node count by the node type's compute units. Two 8 vCPU nodes use 2 × 4 CU = 8 CU an hour. The Usage panel shows the total as you change the node type or count.
No. Serverless is metered by the data your queries scan, under your plan's allowances. See Limits.