Query Acceleration Service: Expanded support for COPY statements

Attention

This behavior change is in the 2024_07 bundle.

For the current status of the bundle, refer to Bundle History.

The Query Acceleration Service (QAS) can accelerate eligible queries by offloading portions of the query processing to serverless compute resources that are provided by the service.

QAS support for COPY statements changes as follows:

Before the change:

COPY statements are not accelerated by the Query Acceleration Service.

After the change:

Eligible COPY statements are accelerated by the Query Acceleration Service and appear in the Account Usage QUERY_ACCELERATION_ELIGIBLE view.

This change might result in additional QAS usage for your account. Additionally, you can check the QUERY_ACCELERATION_ELIGIBLE view to see if you have new warehouses that may benefit from QAS.

Ref: 1749