groups

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

Overview

Name	groups
Type	Resource
Id	google.migrationcenter.groups

Fields

Name	Datatype	Description
name	string	Output only. The name of the group.
description	string	Optional. The description of the group.
createTime	string	Output only. The timestamp when the group was created.
displayName	string	Optional. User-friendly display name.
labels	object	Labels as key value pairs.
updateTime	string	Output only. The timestamp when the group was last updated.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	groupsId, locationsId, projectsId	Gets the details of a group.
list	SELECT	locationsId, projectsId	Lists all groups in a given project and location.
create	INSERT	locationsId, projectsId	Creates a new group in a given project and location.
delete	DELETE	groupsId, locationsId, projectsId	Deletes a group.
patch	UPDATE	groupsId, locationsId, projectsId	Updates the parameters of a group.

SELECT examples

Lists all groups in a given project and location.

SELECT
name,
description,
createTime,
displayName,
labels,
updateTime
FROM google.migrationcenter.groups
WHERE locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO google.migrationcenter.groups (
locationsId,
projectsId,
labels,
displayName,
description
)
SELECT 
'{{ locationsId }}',
'{{ projectsId }}',
'{{ labels }}',
'{{ displayName }}',
'{{ description }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: name
      value: string
    - name: createTime
      value: string
    - name: updateTime
      value: string
    - name: labels
      value: object
    - name: displayName
      value: string
    - name: description
      value: string

UPDATE example

Updates a groups resource.

/*+ update */
UPDATE google.migrationcenter.groups
SET 
labels = '{{ labels }}',
displayName = '{{ displayName }}',
description = '{{ description }}'
WHERE 
groupsId = '{{ groupsId }}'
AND locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}';

DELETE example

Deletes the specified groups resource.

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