backups

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

Overview

Name	backups
Type	Resource
Id	google.looker.backups

Fields

The following fields are returned by SELECT queries:

get

Name	Datatype	Description
name	string	Immutable. The relative resource name of the backup, in the following form: projects/{project_number}/locations/{location_id}/instances/{instance_id}/backups/{backup}
createTime	string (google-datetime)	Output only. The time when the backup was started.
encryptionConfig	object	Output only. Current status of the CMEK encryption (id: EncryptionConfig)
expireTime	string (google-datetime)	Output only. The time when the backup will be deleted.
state	string	Output only. The current state of the backup. (STATE_UNSPECIFIED, CREATING, DELETING, ACTIVE, FAILED)

list

Name	Datatype	Description
name	string	Immutable. The relative resource name of the backup, in the following form: projects/{project_number}/locations/{location_id}/instances/{instance_id}/backups/{backup}
createTime	string (google-datetime)	Output only. The time when the backup was started.
encryptionConfig	object	Output only. Current status of the CMEK encryption (id: EncryptionConfig)
expireTime	string (google-datetime)	Output only. The time when the backup will be deleted.
state	string	Output only. The current state of the backup. (STATE_UNSPECIFIED, CREATING, DELETING, ACTIVE, FAILED)

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	projectsId, locationsId, instancesId, backupsId
list	select	projectsId, locationsId, instancesId	orderBy, pageSize, pageToken	List backups of Looker instance.
create	insert	projectsId, locationsId, instancesId		Backup Looker instance.
delete	delete	projectsId, locationsId, instancesId, backupsId		Delete backup.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
backupsId	string
instancesId	string
locationsId	string
projectsId	string
orderBy	string
pageSize	integer (int32)
pageToken	string

SELECT examples

get

Successful response

SELECT
name,
createTime,
encryptionConfig,
expireTime,
state
FROM google.looker.backups
WHERE projectsId = '{{ projectsId }}' -- required
AND locationsId = '{{ locationsId }}' -- required
AND instancesId = '{{ instancesId }}' -- required
AND backupsId = '{{ backupsId }}' -- required
;

list

List backups of Looker instance.

SELECT
name,
createTime,
encryptionConfig,
expireTime,
state
FROM google.looker.backups
WHERE projectsId = '{{ projectsId }}' -- required
AND locationsId = '{{ locationsId }}' -- required
AND instancesId = '{{ instancesId }}' -- required
AND orderBy = '{{ orderBy }}'
AND pageSize = '{{ pageSize }}'
AND pageToken = '{{ pageToken }}'
;

INSERT examples

create

Backup Looker instance.

INSERT INTO google.looker.backups (
data__name,
projectsId,
locationsId,
instancesId
)
SELECT 
'{{ name }}',
'{{ projectsId }}',
'{{ locationsId }}',
'{{ instancesId }}'
RETURNING
name,
done,
error,
metadata,
response
;

Manifest

# Description fields are for documentation purposes
- name: backups
props:
  - name: projectsId
    value: "{{ projectsId }}"
    description: Required parameter for the backups resource.
  - name: locationsId
    value: "{{ locationsId }}"
    description: Required parameter for the backups resource.
  - name: instancesId
    value: "{{ instancesId }}"
    description: Required parameter for the backups resource.
  - name: name
    value: "{{ name }}"
    description: |
      Immutable. The relative resource name of the backup, in the following form: `projects/{project_number}/locations/{location_id}/instances/{instance_id}/backups/{backup}`

DELETE examples

delete

Delete backup.

DELETE FROM google.looker.backups
WHERE projectsId = '{{ projectsId }}' --required
AND locationsId = '{{ locationsId }}' --required
AND instancesId = '{{ instancesId }}' --required
AND backupsId = '{{ backupsId }}' --required
;