bi_reservation

Creates, updates, deletes, gets or lists a bi_reservation resource.

Overview

Name	bi_reservation
Type	Resource
Id	google.bigqueryreservation.bi_reservation

Fields

Name	Datatype	Description
name	string	The resource name of the singleton BI reservation. Reservation names have the form projects/{project_id}/locations/{location_id}/biReservation.
preferredTables	array	Preferred tables to use BI capacity for.
size	string	Size of a reservation, in bytes.
updateTime	string	Output only. The last update timestamp of a reservation.

Methods

Name	Accessible by	Required Params	Description
get_bi_reservation	SELECT	locationsId, projectsId	Retrieves a BI reservation.
update_bi_reservation	UPDATE	locationsId, projectsId	Updates a BI reservation. Only fields specified in the field_mask are updated. A singleton BI reservation always exists with default size 0. In order to reserve BI capacity it needs to be updated to an amount greater than 0. In order to release BI capacity reservation size must be set to 0.

SELECT examples

Retrieves a BI reservation.

SELECT
name,
preferredTables,
size,
updateTime
FROM google.bigqueryreservation.bi_reservation
WHERE locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}';

UPDATE example

Updates a bi_reservation resource.

/*+ update */
UPDATE google.bigqueryreservation.bi_reservation
SET 
name = '{{ name }}',
size = '{{ size }}',
preferredTables = '{{ preferredTables }}'
WHERE 
locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}';