Jake Robert Mongaya
06/17/2026, 1:45 PMRocky
06/17/2026, 1:45 PMSHOW WAREHOUSES, CREATE WAREHOUSE, and SET WAREHOUSE to manage and switch between compute resources.
* New in 4.1.1 / 4.0.11: Release notes specify that SHOW WAREHOUSES (along with other SHOW statements) is now allowed inside explicit transactions, improving compatibility for JDBC and BI clients.
* Utility Functions: The CURRENT_WAREHOUSE() function is available to return the name of the warehouse currently being used by your session.
* Kubernetes Support: If you are using the StarRocks Kubernetes Operator (v1.9.0+), it supports the StarRocksWarehouse CRD to manage these resources in cloud-native environments.
If you are using the Open Source (Apache 2.0) edition, you typically manage compute resources via Resource Groups for workload isolation, as the full multi-warehouse scaling feature is restricted to the enterprise version.
References
• release_notes/release-3.5.md
• release_notes/release-2.1.md
• release_notes/release-2.5.md
• release_notes/release-2.3.md