migration_executions

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

Overview

Name	migration_executions
Type	Resource
Id	google.metastore.migration_executions

Fields

Name	Datatype	Description
name	string	Output only. The relative resource name of the migration execution, in the following form: projects/{project_number}/locations/{location_id}/services/{service_id}/migrationExecutions/{migration_execution_id}
cloudSqlMigrationConfig	object	Configuration information for migrating from self-managed hive metastore on Google Cloud using Cloud SQL as the backend database to Dataproc Metastore.
createTime	string	Output only. The time when the migration execution was started.
endTime	string	Output only. The time when the migration execution finished.
phase	string	Output only. The current phase of the migration execution.
state	string	Output only. The current state of the migration execution.
stateMessage	string	Output only. Additional information about the current state of the migration execution.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	locationsId, migrationExecutionsId, projectsId, servicesId	Gets details of a single migration execution.
list	SELECT	locationsId, projectsId, servicesId	Lists migration executions on a service.
delete	DELETE	locationsId, migrationExecutionsId, projectsId, servicesId	Deletes a single migration execution.

SELECT examples

Lists migration executions on a service.

SELECT
name,
cloudSqlMigrationConfig,
createTime,
endTime,
phase,
state,
stateMessage
FROM google.metastore.migration_executions
WHERE locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}'
AND servicesId = '{{ servicesId }}';

DELETE example

Deletes the specified migration_executions resource.

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