Compute usage with SQL warehousing

Running queries or builds with SQL warehousing in Foundry consumes compute resources, measured in compute-seconds. This page explains how compute is used by the SQL warehouse and how usage is attributed to Foundry resources for reporting. Usage can be viewed from the Resource management application.

Foundry compute by query type

The below table lays out Foundry compute used in SQL warehouse queries by query type and links to relevant detailed documentation.

Query typeResources queriedQuery engineCompute rate typeResource allocation
Read (SELECT)Datasets, Iceberg tablesFurnaceTransformsSplit evenly across resources queried
Write (CREATE, INSERT, UPDATE, DELETE)Datasets, Iceberg tablesFurnaceTransformsSplit evenly across resources written to
Read (SELECT)Datasets, Iceberg tables, virtual tables, restricted views, objects (via materializations)Legacy Spark engineContourSplit evenly across resources queried
Read (SELECT)DatasetsLegacy direct read engineNANA