Skip to main content

projects

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

Overview

Nameprojects
TypeResource
Idazure.storage_mover.projects

Fields

The following fields are returned by SELECT queries:

The Project resource.

NameDatatypeDescription
propertiesobjectProject properties.
systemDataobjectResource system metadata.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, storageMoverName, projectNameGets a Project resource.
listselectsubscriptionId, resourceGroupName, storageMoverNameLists all Projects in a Storage Mover.
create_or_updateinsertsubscriptionId, resourceGroupName, storageMoverName, projectNameCreates or updates a Project resource, which is a logical grouping of related jobs.
updateupdatesubscriptionId, resourceGroupName, storageMoverName, projectNameUpdates properties for a Project resource. Properties not specified in the request body will be unchanged.
deletedeletesubscriptionId, resourceGroupName, storageMoverName, projectNameDeletes a Project resource.

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.

NameDatatypeDescription
projectNamestringThe name of the Project resource.
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
storageMoverNamestringThe name of the Storage Mover resource.
subscriptionIdstringThe ID of the target subscription.

SELECT examples

Gets a Project resource.

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

INSERT examples

Creates or updates a Project resource, which is a logical grouping of related jobs.

INSERT INTO azure.storage_mover.projects (
data__properties,
subscriptionId,
resourceGroupName,
storageMoverName,
projectName
)
SELECT
'{{ properties }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ storageMoverName }}',
'{{ projectName }}'
RETURNING
properties,
systemData
;

UPDATE examples

Updates properties for a Project resource. Properties not specified in the request body will be unchanged.

UPDATE azure.storage_mover.projects
SET
data__properties = '{{ properties }}'
WHERE
subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND storageMoverName = '{{ storageMoverName }}' --required
AND projectName = '{{ projectName }}' --required
RETURNING
properties,
systemData;

DELETE examples

Deletes a Project resource.

DELETE FROM azure.storage_mover.projects
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND storageMoverName = '{{ storageMoverName }}' --required
AND projectName = '{{ projectName }}' --required
;