thinQmaster Virtual testing partner Adaptive practice exams that find your weak spots and drill them. Every answer explained. From $69
Enroll

thinQmaster

Find your exam

Five questions free, before you decide.

Step 1 · choose a vendor

In one of our camps? Your practice exams come with the tuition — they are on your study page already.

Data & Analytics · Advanced

Query Acceleration Service (QAS)

A Snowflake warehouse feature that offloads parts of eligible large scans and filters to shared serverless compute, helping outlier queries.

Definition

QAS helps ad hoc analytics and workloads with unpredictable large scans without permanently upsizing the warehouse. It is enabled per warehouse with a scale factor that caps how much extra compute it can use.

Example

ALTER WAREHOUSE adhoc_wh SET ENABLE_QUERY_ACCELERATION = TRUE QUERY_ACCELERATION_MAX_SCALE_FACTOR = 8;

Exam tip

Occasional outlier queries scanning lots of data on a shared warehouse = QAS rather than a permanently bigger warehouse.

Related terms