operations

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

Overview

Name	operations
Type	Resource
Id	google.sqladmin.operations

Fields

Name	Datatype	Description
name	string	An identifier that uniquely identifies the operation. You can use this identifier to retrieve the Operations resource that has information about the operation.
acquireSsrsLeaseContext	object	Acquire SSRS lease context.
apiWarning	object	An Admin API warning message.
backupContext	object	Backup context.
endTime	string	The time this operation finished in UTC timezone in RFC 3339 format, for example 2012-11-15T16:19:00.094Z.
error	object	Database instance operation errors list wrapper.
exportContext	object	Database instance export context.
importContext	object	Database instance import context.
insertTime	string	The time this operation was enqueued in UTC timezone in RFC 3339 format, for example 2012-11-15T16:19:00.094Z.
kind	string	This is always sql#operation.
operationType	string	The type of the operation. Valid values are: CREATE DELETE UPDATE RESTART IMPORT EXPORT BACKUP_VOLUME RESTORE_VOLUME CREATE_USER DELETE_USER CREATE_DATABASE DELETE_DATABASE
selfLink	string	The URI of this resource.
startTime	string	The time this operation actually started in UTC timezone in RFC 3339 format, for example 2012-11-15T16:19:00.094Z.
status	string	The status of an operation.
targetId	string	Name of the database instance related to this operation.
targetLink	string
targetProject	string	The project ID of the target instance related to this operation.
user	string	The email address of the user who initiated this operation.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	operation, project	Retrieves an instance operation that has been performed on an instance.
list	SELECT	project	Lists all instance operations that have been performed on the given Cloud SQL instance in the reverse chronological order of the start time.
cancel	EXEC	operation, project	Cancels an instance operation that has been performed on an instance.

SELECT examples

Lists all instance operations that have been performed on the given Cloud SQL instance in the reverse chronological order of the start time.

SELECT
name,
acquireSsrsLeaseContext,
apiWarning,
backupContext,
endTime,
error,
exportContext,
importContext,
insertTime,
kind,
operationType,
selfLink,
startTime,
status,
targetId,
targetLink,
targetProject,
user
FROM google.sqladmin.operations
WHERE project = '{{ project }}';