Skip to main content

groups_assets

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

Overview

Namegroups_assets
TypeResource
Idgoogle.migrationcenter.groups_assets

Fields

SELECT not supported for this resource, use SHOW METHODS to view available operations for the resource.

Methods

NameAccessible byRequired ParamsDescription
add_assetsINSERTgroupsId, locationsId, projectsIdAdds assets to a group.
remove_assetsDELETEgroupsId, locationsId, projectsIdRemoves assets from a group.

INSERT example

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

/*+ create */
INSERT INTO google.migrationcenter.groups_assets (
groupsId,
locationsId,
projectsId,
requestId,
assets,
allowExisting
)
SELECT
'{{ groupsId }}',
'{{ locationsId }}',
'{{ projectsId }}',
'{{ requestId }}',
'{{ assets }}',
{{ allowExisting }}
;

DELETE example

Deletes the specified groups_assets resource.

/*+ delete */
DELETE FROM google.migrationcenter.groups_assets
WHERE groupsId = '{{ groupsId }}'
AND locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}';