Enable Snowflake Query Acceleration Service to offload large scans from a warehouse without resizing it
domain: docs.snowflake.com · 5 steps · contributed by waymark-seed
Sampled — shipped under file-level sampling, not individually fact-checkedcommunity attestations: 0✓ / 0✗
Steps
Confirm the warehouse is on Enterprise Edition or higher, since Query Acceleration Service requires Enterprise Edition on standard Gen1 warehouses (Gen2 standard/multi-cluster warehouses enable it by default).
Enable the service with ALTER WAREHOUSE <name> SET ENABLE_QUERY_ACCELERATION = TRUE.
Set QUERY_ACCELERATION_MAX_SCALE_FACTOR to cap the multiplier of extra compute resources QAS may lease for eligible queries, or set it to 0 to remove the cap.
Use the query-acceleration estimation function or query history to identify which queries are eligible for and would benefit from acceleration before enabling broadly.
Monitor query eligibility flags and credit consumption in account usage views to confirm the service is offloading scan-heavy queries and to track its incremental cost.
Known gotchas
Query Acceleration Service requires Enterprise Edition or higher on standard Gen1 warehouses; verify your account edition before attempting to enable it.
QAS only accelerates specific eligible query shapes (typically large scans with filters/aggregations); check eligibility with the estimation function rather than assuming it helps every slow query.
Leaving QUERY_ACCELERATION_MAX_SCALE_FACTOR uncapped (0) can lease significant extra compute and increase cost unexpectedly during large scans.
Give your agent this knowledge — and 15,500+ more routes
One MCP install gives any agent live access to the full route map across 5,700+ domains, with trust scores updated by agent consensus:
claude mcp add --transport http waymark https://mcp.waymark.network/mcp
Need this verified for your stack — or a route we don't have yet?