projects

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

Overview

Name	projects
Type	Resource
Id	azure.data_migration.projects

Fields

vw_projects

Name	Datatype	Description
id	text	field from the properties object
name	text	field from the properties object
azure_authentication_info	text	field from the properties object
creation_time	text	field from the properties object
databases_info	text	field from the properties object
etag	text	HTTP strong entity tag value. This is ignored if submitted.
groupName	text	field from the properties object
location	text	field from the properties object
projectName	text	field from the properties object
provisioning_state	text	field from the properties object
serviceName	text	field from the properties object
source_connection_info	text	field from the properties object
source_platform	text	field from the properties object
subscriptionId	text	field from the properties object
system_data	text	field from the properties object
tags	text	field from the properties object
target_connection_info	text	field from the properties object
target_platform	text	field from the properties object
type	text	field from the properties object

projects

Name	Datatype	Description
id	string
name	string
etag	string	HTTP strong entity tag value. This is ignored if submitted.
location	string
properties	object	Project-specific properties
systemData	object
tags	object
type	string

Methods

Name	Accessible by	Required Params	Description
get	SELECT	groupName, projectName, serviceName, subscriptionId	The project resource is a nested resource representing a stored migration project. The GET method retrieves information about a project.
list	SELECT	groupName, serviceName, subscriptionId	The project resource is a nested resource representing a stored migration project. This method returns a list of projects owned by a service resource.
create_or_update	INSERT	groupName, projectName, serviceName, subscriptionId	The project resource is a nested resource representing a stored migration project. The PUT method creates a new project or updates an existing one.
delete	DELETE	groupName, projectName, serviceName, subscriptionId	The project resource is a nested resource representing a stored migration project. The DELETE method deletes a project.
update	UPDATE	groupName, projectName, serviceName, subscriptionId	The project resource is a nested resource representing a stored migration project. The PATCH method updates an existing project.

SELECT examples

The project resource is a nested resource representing a stored migration project. This method returns a list of projects owned by a service resource.

vw_projects

SELECT
id,
name,
azure_authentication_info,
creation_time,
databases_info,
etag,
groupName,
location,
projectName,
provisioning_state,
serviceName,
source_connection_info,
source_platform,
subscriptionId,
system_data,
tags,
target_connection_info,
target_platform,
type
FROM azure.data_migration.vw_projects
WHERE groupName = '{{ groupName }}'
AND serviceName = '{{ serviceName }}'
AND subscriptionId = '{{ subscriptionId }}';

projects

SELECT
id,
name,
etag,
location,
properties,
systemData,
tags,
type
FROM azure.data_migration.projects
WHERE groupName = '{{ groupName }}'
AND serviceName = '{{ serviceName }}'
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.data_migration.projects (
groupName,
projectName,
serviceName,
subscriptionId,
properties,
etag,
location,
tags
)
SELECT 
'{{ groupName }}',
'{{ projectName }}',
'{{ serviceName }}',
'{{ subscriptionId }}',
'{{ properties }}',
'{{ etag }}',
'{{ location }}',
'{{ tags }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: sourcePlatform
          value: []
        - name: azureAuthenticationInfo
          value:
            - name: applicationId
              value: string
            - name: appKey
              value: string
            - name: tenantId
              value: string
            - name: ignoreAzurePermissions
              value: boolean
        - name: targetPlatform
          value: []
        - name: creationTime
          value: string
        - name: sourceConnectionInfo
          value:
            - name: type
              value: string
            - name: userName
              value: string
            - name: password
              value: string
        - name: databasesInfo
          value:
            - - name: sourceDatabaseName
                value: string
        - name: provisioningState
          value: string
    - 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
    - name: etag
      value: string
    - name: location
      value: string
    - name: tags
      value: object
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string

UPDATE example

Updates a projects resource.

/*+ update */
UPDATE azure.data_migration.projects
SET 
properties = '{{ properties }}',
etag = '{{ etag }}',
location = '{{ location }}',
tags = '{{ tags }}'
WHERE 
groupName = '{{ groupName }}'
AND projectName = '{{ projectName }}'
AND serviceName = '{{ serviceName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified projects resource.

/*+ delete */
DELETE FROM azure.data_migration.projects
WHERE groupName = '{{ groupName }}'
AND projectName = '{{ projectName }}'
AND serviceName = '{{ serviceName }}'
AND subscriptionId = '{{ subscriptionId }}';