transforms

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

Overview

Name	transforms
Type	Resource
Id	azure.media_services.transforms

Fields

vw_transforms

Name	Datatype	Description
description	text	field from the properties object
accountName	text	field from the properties object
created	text	field from the properties object
last_modified	text	field from the properties object
outputs	text	field from the properties object
resourceGroupName	text	field from the properties object
subscriptionId	text	field from the properties object
system_data	text	field from the properties object
transformName	text	field from the properties object

transforms

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

Methods

Name	Accessible by	Required Params	Description
get	SELECT	accountName, resourceGroupName, subscriptionId, transformName	Gets a Transform.
list	SELECT	accountName, resourceGroupName, subscriptionId	Lists the Transforms in the account.
create_or_update	INSERT	accountName, resourceGroupName, subscriptionId, transformName	Creates or updates a new Transform.
delete	DELETE	accountName, resourceGroupName, subscriptionId, transformName	Deletes a Transform.
update	UPDATE	accountName, resourceGroupName, subscriptionId, transformName	Updates a Transform.

SELECT examples

Lists the Transforms in the account.

vw_transforms

SELECT
description,
accountName,
created,
last_modified,
outputs,
resourceGroupName,
subscriptionId,
system_data,
transformName
FROM azure.media_services.vw_transforms
WHERE accountName = '{{ accountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

transforms

SELECT
properties,
systemData
FROM azure.media_services.transforms
WHERE accountName = '{{ accountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.media_services.transforms (
accountName,
resourceGroupName,
subscriptionId,
transformName,
properties
)
SELECT 
'{{ accountName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ transformName }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: created
          value: string
        - name: description
          value: string
        - name: lastModified
          value: string
        - name: outputs
          value:
            - - name: onError
                value: string
              - name: relativePriority
                value: string
              - name: preset
                value:
                  - name: '@odata.type'
                    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

UPDATE example

Updates a transforms resource.

/*+ update */
UPDATE azure.media_services.transforms
SET 
properties = '{{ properties }}'
WHERE 
accountName = '{{ accountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND transformName = '{{ transformName }}';

DELETE example

Deletes the specified transforms resource.

/*+ delete */
DELETE FROM azure.media_services.transforms
WHERE accountName = '{{ accountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND transformName = '{{ transformName }}';