projects

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

Overview

Name	projects
Type	Resource
Id	azure.storage_mover.projects

Fields

vw_projects

Name	Datatype	Description
description	text	field from the properties object
projectName	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
storageMoverName	text	field from the properties object
subscriptionId	text	field from the properties object
system_data	text	field from the properties object

projects

Name	Datatype	Description
properties	object	Project properties.
systemData	object	Metadata pertaining to creation and last modification of the resource.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	projectName, resourceGroupName, storageMoverName, subscriptionId	Gets a Project resource.
list	SELECT	resourceGroupName, storageMoverName, subscriptionId	Lists all Projects in a Storage Mover.
create_or_update	INSERT	projectName, resourceGroupName, storageMoverName, subscriptionId	Creates or updates a Project resource, which is a logical grouping of related jobs.
delete	DELETE	projectName, resourceGroupName, storageMoverName, subscriptionId	Deletes a Project resource.
update	UPDATE	projectName, resourceGroupName, storageMoverName, subscriptionId	Updates properties for a Project resource. Properties not specified in the request body will be unchanged.

SELECT examples

Lists all Projects in a Storage Mover.

vw_projects

SELECT
description,
projectName,
provisioning_state,
resourceGroupName,
storageMoverName,
subscriptionId,
system_data
FROM azure.storage_mover.vw_projects
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND storageMoverName = '{{ storageMoverName }}'
AND subscriptionId = '{{ subscriptionId }}';

projects

SELECT
properties,
systemData
FROM azure.storage_mover.projects
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND storageMoverName = '{{ storageMoverName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.storage_mover.projects (
projectName,
resourceGroupName,
storageMoverName,
subscriptionId,
properties,
systemData
)
SELECT 
'{{ projectName }}',
'{{ resourceGroupName }}',
'{{ storageMoverName }}',
'{{ subscriptionId }}',
'{{ properties }}',
'{{ systemData }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: description
          value: string
        - name: provisioningState
          value: []
    - name: systemData
      value:
        - name: createdBy
          value: string
        - name: createdByType
          value: string
        - name: createdAt
          value: string
        - name: lastModifiedBy
          value: string
        - name: lastModifiedByType
          value: string
        - name: lastModifiedAt
          value: string

UPDATE example

Updates a projects resource.

/*+ update */
UPDATE azure.storage_mover.projects
SET 
properties = '{{ properties }}'
WHERE 
projectName = '{{ projectName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND storageMoverName = '{{ storageMoverName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified projects resource.

/*+ delete */
DELETE FROM azure.storage_mover.projects
WHERE projectName = '{{ projectName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND storageMoverName = '{{ storageMoverName }}'
AND subscriptionId = '{{ subscriptionId }}';