backups

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

Overview

Name	backups
Type	Resource
Id	google.metastore.backups

Fields

Name	Datatype	Description
name	string	Immutable. The relative resource name of the backup, in the following form:projects/{project_number}/locations/{location_id}/services/{service_id}/backups/{backup_id}
description	string	The description of the backup.
createTime	string	Output only. The time when the backup was started.
endTime	string	Output only. The time when the backup finished creating.
restoringServices	array	Output only. Services that are restoring from the backup.
serviceRevision	object	A managed metastore service that serves metadata queries.
state	string	Output only. The current state of the backup.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	backupsId, locationsId, projectsId, servicesId	Gets details of a single backup.
list	SELECT	locationsId, projectsId, servicesId	Lists backups in a service.
create	INSERT	locationsId, projectsId, servicesId	Creates a new backup in a given project and location.
delete	DELETE	backupsId, locationsId, projectsId, servicesId	Deletes a single backup.

SELECT examples

Lists backups in a service.

SELECT
name,
description,
createTime,
endTime,
restoringServices,
serviceRevision,
state
FROM google.metastore.backups
WHERE locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}'
AND servicesId = '{{ servicesId }}';

INSERT example

Use the following StackQL query and manifest file to create a new backups resource.

All Properties

/*+ create */
INSERT INTO google.metastore.backups (
locationsId,
projectsId,
servicesId,
name,
description
)
SELECT 
'{{ locationsId }}',
'{{ projectsId }}',
'{{ servicesId }}',
'{{ name }}',
'{{ description }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: name
      value: string
    - name: createTime
      value: string
    - name: endTime
      value: string
    - name: state
      value: string
    - name: serviceRevision
      value:
        - name: hiveMetastoreConfig
          value:
            - name: version
              value: string
            - name: configOverrides
              value: object
            - name: kerberosConfig
              value:
                - name: keytab
                  value:
                    - name: cloudSecret
                      value: string
                - name: principal
                  value: string
                - name: krb5ConfigGcsUri
                  value: string
            - name: endpointProtocol
              value: string
            - name: auxiliaryVersions
              value: object
        - name: name
          value: string
        - name: createTime
          value: string
        - name: updateTime
          value: string
        - name: labels
          value: object
        - name: network
          value: string
        - name: endpointUri
          value: string
        - name: port
          value: integer
        - name: state
          value: string
        - name: stateMessage
          value: string
        - name: artifactGcsUri
          value: string
        - name: tier
          value: string
        - name: metadataIntegration
          value:
            - name: dataCatalogConfig
              value:
                - name: enabled
                  value: boolean
        - name: maintenanceWindow
          value:
            - name: hourOfDay
              value: integer
            - name: dayOfWeek
              value: string
        - name: uid
          value: string
        - name: metadataManagementActivity
          value:
            - name: metadataExports
              value:
                - - name: destinationGcsUri
                    value: string
                  - name: startTime
                    value: string
                  - name: endTime
                    value: string
                  - name: state
                    value: string
                  - name: databaseDumpType
                    value: string
            - name: restores
              value:
                - - name: startTime
                    value: string
                  - name: endTime
                    value: string
                  - name: state
                    value: string
                  - name: backup
                    value: string
                  - name: type
                    value: string
                  - name: details
                    value: string
                  - name: backupLocation
                    value: string
        - name: releaseChannel
          value: string
        - name: encryptionConfig
          value:
            - name: kmsKey
              value: string
        - name: networkConfig
          value:
            - name: consumers
              value:
                - - name: subnetwork
                    value: string
                  - name: endpointUri
                    value: string
                  - name: endpointLocation
                    value: string
        - name: databaseType
          value: string
        - name: telemetryConfig
          value:
            - name: logFormat
              value: string
        - name: scalingConfig
          value:
            - name: instanceSize
              value: string
            - name: scalingFactor
              value: number
            - name: autoscalingConfig
              value:
                - name: autoscalingFactor
                  value: number
                - name: autoscalingEnabled
                  value: boolean
                - name: limitConfig
                  value:
                    - name: maxScalingFactor
                      value: number
                    - name: minScalingFactor
                      value: number
        - name: scheduledBackup
          value:
            - name: enabled
              value: boolean
            - name: cronSchedule
              value: string
            - name: timeZone
              value: string
            - name: nextScheduledTime
              value: string
            - name: backupLocation
              value: string
            - name: latestBackup
              value:
                - name: backupId
                  value: string
                - name: startTime
                  value: string
                - name: state
                  value: string
                - name: duration
                  value: string
        - name: deletionProtection
          value: boolean
    - name: description
      value: string
    - name: restoringServices
      value:
        - string

DELETE example

Deletes the specified backups resource.

/*+ delete */
DELETE FROM google.metastore.backups
WHERE backupsId = '{{ backupsId }}'
AND locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}'
AND servicesId = '{{ servicesId }}';