Monitoring metrics ‘Reservation Complete Bytes’ offers details about the BI engine capability reservation whereas ‘Reservation Used Bytes’ offers details about the full used_bytes. Prospects could make use of those 2 metrics to provide you with the precise capability for reservation.
When a venture has BI engine capability reserved, queries working in BigQuery will use BI engine to speed up the suitable subquery efficiency.The diploma of acceleration of the question falls into one of many beneath talked about modes:
BI Engine Mode FULL – BI Engine compute was used to speed up leaf phases of the question however the knowledge wanted could also be in reminiscence or might must be scanned from a disk. Even when BI Engine compute is utilized, BQ slots may additionally be used for components of the question. The extra advanced the question,the extra slots are used.This mode executes all leaf phases in BI Engine (and typically all phases).
BI Engine Mode PARTIAL – BI Engine accelerates suitable subqueries and BigQuery processes the subqueries that aren’t suitable with BI Engine.This mode additionally gives bi-engine-reason for not utilizing BI Engine mode totally.This mode executes some leaf phases in BI Engine and relaxation in BigQuery.
BI Engine Mode DISABLED – When BI Engine course of subqueries that aren’t suitable for acceleration, all leaf phases will get processed in BigQuery. This mode additionally gives bi-engine-reason for not utilizing BI Engine mode totally/partially.