relations

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

Overview

Name	relations
Type	Resource
Id	google.migrationcenter.relations

Fields

The following fields are returned by SELECT queries:

get

Name	Datatype	Description
name	string	Output only. Identifier. The identifier of the relation.
createTime	string (google-datetime)	Output only. The timestamp when the relation was created.
dstAsset	string	Output only. The destination asset name in the relation.
srcAsset	string	Output only. The source asset name in the relation.
type	string	Optional. The type of the relation. (TYPE_UNSPECIFIED, LOGICAL_DATABASE, DATABASE_DEPLOYMENT_HOSTING_SERVER)

list

Name	Datatype	Description
name	string	Output only. Identifier. The identifier of the relation.
createTime	string (google-datetime)	Output only. The timestamp when the relation was created.
dstAsset	string	Output only. The destination asset name in the relation.
srcAsset	string	Output only. The source asset name in the relation.
type	string	Optional. The type of the relation. (TYPE_UNSPECIFIED, LOGICAL_DATABASE, DATABASE_DEPLOYMENT_HOSTING_SERVER)

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	projectsId, locationsId, relationsId		Gets the details of an relation.
list	select	projectsId, locationsId	filter, orderBy, pageSize, pageToken	Lists all the relations in a given project and location.

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
locationsId	string
projectsId	string
relationsId	string
filter	string
orderBy	string
pageSize	integer (int32)
pageToken	string

SELECT examples

get

Gets the details of an relation.

SELECT
name,
createTime,
dstAsset,
srcAsset,
type
FROM google.migrationcenter.relations
WHERE projectsId = '{{ projectsId }}' -- required
AND locationsId = '{{ locationsId }}' -- required
AND relationsId = '{{ relationsId }}' -- required
;

list

Lists all the relations in a given project and location.

SELECT
name,
createTime,
dstAsset,
srcAsset,
type
FROM google.migrationcenter.relations
WHERE projectsId = '{{ projectsId }}' -- required
AND locationsId = '{{ locationsId }}' -- required
AND filter = '{{ filter }}'
AND orderBy = '{{ orderBy }}'
AND pageSize = '{{ pageSize }}'
AND pageToken = '{{ pageToken }}'
;