mediaservices

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

Overview

Name	mediaservices
Type	Resource
Id	azure.media_services.mediaservices

Fields

vw_mediaservices

Name	Datatype	Description
accountName	text	field from the properties object
encryption	text	field from the properties object
identity	text	field from the properties object
key_delivery	text	field from the properties object
location	text	The geo-location where the resource lives
media_service_id	text	field from the properties object
minimum_tls_version	text	field from the properties object
private_endpoint_connections	text	field from the properties object
provisioning_state	text	field from the properties object
public_network_access	text	field from the properties object
resourceGroupName	text	field from the properties object
storage_accounts	text	field from the properties object
storage_authentication	text	field from the properties object
subscriptionId	text	field from the properties object
system_data	text	field from the properties object
tags	text	Resource tags.

mediaservices

Name	Datatype	Description
identity	object
location	string	The geo-location where the resource lives
properties	object	Properties of the Media Services account.
systemData	object	Metadata pertaining to creation and last modification of the resource.
tags	object	Resource tags.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	accountName, resourceGroupName, subscriptionId	Get the details of a Media Services account
list	SELECT	resourceGroupName, subscriptionId	List Media Services accounts in the resource group
list_by_subscription	SELECT	subscriptionId	List Media Services accounts in the subscription.
create_or_update	INSERT	accountName, resourceGroupName, subscriptionId	Creates or updates a Media Services account
delete	DELETE	accountName, resourceGroupName, subscriptionId	Deletes a Media Services account
update	UPDATE	accountName, resourceGroupName, subscriptionId	Updates an existing Media Services account
sync_storage_keys	EXEC	accountName, resourceGroupName, subscriptionId	Synchronizes storage account keys for a storage account associated with the Media Service account.

SELECT examples

List Media Services accounts in the subscription.

vw_mediaservices

SELECT
accountName,
encryption,
identity,
key_delivery,
location,
media_service_id,
minimum_tls_version,
private_endpoint_connections,
provisioning_state,
public_network_access,
resourceGroupName,
storage_accounts,
storage_authentication,
subscriptionId,
system_data,
tags
FROM azure.media_services.vw_mediaservices
WHERE subscriptionId = '{{ subscriptionId }}';

mediaservices

SELECT
identity,
location,
properties,
systemData,
tags
FROM azure.media_services.mediaservices
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.media_services.mediaservices (
accountName,
resourceGroupName,
subscriptionId,
tags,
location,
properties,
identity
)
SELECT 
'{{ accountName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ tags }}',
'{{ location }}',
'{{ properties }}',
'{{ identity }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: tags
      value: object
    - name: location
      value: string
    - name: properties
      value:
        - name: mediaServiceId
          value: string
        - name: storageAccounts
          value:
            - - name: id
                value: string
              - name: type
                value: string
              - name: identity
                value:
                  - name: userAssignedIdentity
                    value: string
                  - name: useSystemAssignedIdentity
                    value: boolean
              - name: status
                value: string
        - name: storageAuthentication
          value: string
        - name: encryption
          value:
            - name: type
              value: string
            - name: keyVaultProperties
              value:
                - name: keyIdentifier
                  value: string
                - name: identity
                  value: string
            - name: status
              value: string
        - name: keyDelivery
          value:
            - name: accessControl
              value:
                - name: defaultAction
                  value: string
                - name: ipAllowList
                  value:
                    - string
        - name: publicNetworkAccess
          value: string
        - name: provisioningState
          value: string
        - name: privateEndpointConnections
          value:
            - - name: properties
                value:
                  - name: privateEndpoint
                    value:
                      - name: id
                        value: string
                  - name: privateLinkServiceConnectionState
                    value:
                      - name: status
                        value: []
                      - name: description
                        value: string
                      - name: actionsRequired
                        value: string
                  - name: provisioningState
                    value: []
              - name: id
                value: string
              - name: name
                value: string
              - name: type
                value: string
        - name: minimumTlsVersion
          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: identity
      value:
        - name: type
          value: string
        - name: principalId
          value: string
        - name: tenantId
          value: string
        - name: userAssignedIdentities
          value: []

UPDATE example

Updates a mediaservices resource.

/*+ update */
UPDATE azure.media_services.mediaservices
SET 
tags = '{{ tags }}',
properties = '{{ properties }}',
identity = '{{ identity }}'
WHERE 
accountName = '{{ accountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified mediaservices resource.

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