From the course: Advanced Snowflake: Deep Dive Cloud Data Warehousing and Analytics

Unlock this course with a free trial

Join today to access over 25,600 courses taught by industry experts.

Query acceleration service

Query acceleration service - Snowflake Tutorial

From the course: Advanced Snowflake: Deep Dive Cloud Data Warehousing and Analytics

Start my 1-month free trial Buy for my team

Query acceleration service

“

When you create a virtual warehouse in Snowflake, you can enable the Query Acceleration service on that warehouse. The Query Acceleration service is a serverless performance booster for Snowflake. It automatically detects eligible long-running queries and offloads parts of their workload to additional shared compute resources beyond the warehouse itself. This reduces query execution time without you having to manually tune your queries. This means you get a burst of additional serverless capacity to execute your query without you having to resize your warehouse. Query acceleration is thus a serverless performance booster. You don't have to do anything special except enable query acceleration on your virtual warehouse. It will automatically detect eligible queries that it can offload to this serverless resources. When QAS is enabled on a warehouse, Snowflake evaluates each query to see if it could benefit from query acceleration. For eligible queries, the service runs portions of the…

Contents