AT A GLANCE
Performance capabilities
All warehouse types include Photon. Predictive I/O and Genie are available on Serverless and Pro, while intelligent workload management is exclusive to Serverless.
Databricks SQL warehouse capabilities
| Capability | Serverless | Pro | Classic |
|---|---|---|---|
Photon engineA vectorized query engine that accelerates existing SQL and DataFrame workloads. | Serverless supports this capability | Pro supports this capability | Classic supports this capability |
Predictive I/OUses intelligent access patterns to scan less data and speed up selective queries. | Serverless supports this capability | Pro supports this capability | Classic does not support this capability |
Intelligent workload managementPredicts query resource needs and dynamically manages capacity, queues, and scaling. | Serverless supports this capability | Pro does not support this capability | Classic does not support this capability |
GenieNatural-language analytics through Genie Agents, formerly known as Genie Spaces. | Serverless supports this capability | Pro supports this capability | Classic does not support this capability |
Capabilities and startup guidance are based on the Databricks SQL warehouse type documentation. Availability can vary by cloud and region.