profiles

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

Overview

Name	`profiles`
Type	Resource
Id	`azure.cdn.profiles`

Fields

vw_profiles
profiles

Name	Datatype	Description
`extended_properties`	`text`	field from the `properties` object
`front_door_id`	`text`	field from the `properties` object
`identity`	`text`	Managed service identity (system assigned and/or user assigned identities)
`kind`	`text`	Kind of the profile. Used by portal to differentiate traditional CDN profile and new AFD profile.
`location`	`text`	Resource location.
`log_scrubbing`	`text`	field from the `properties` object
`origin_response_timeout_seconds`	`text`	field from the `properties` object
`profileName`	`text`	field from the `properties` object
`provisioning_state`	`text`	field from the `properties` object
`resourceGroupName`	`text`	field from the `properties` object
`resource_state`	`text`	field from the `properties` object
`sku`	`text`	Standard_Verizon = The SKU name for a Standard Verizon CDN profile.

Premium_Verizon = The SKU name for a Premium Verizon CDN profile. Custom_Verizon = The SKU name for a Custom Verizon CDN profile. Standard_Akamai = The SKU name for an Akamai CDN profile. Standard_ChinaCdn = The SKU name for a China CDN profile for VOD, Web and download scenarios using GB based billing model. Standard_Microsoft = The SKU name for a Standard Microsoft CDN profile. Standard_AzureFrontDoor = The SKU name for an Azure Front Door Standard profile. Premium_AzureFrontDoor = The SKU name for an Azure Front Door Premium profile. Standard_955BandWidth_ChinaCdn = The SKU name for a China CDN profile for VOD, Web and download scenarios using 95-5 peak bandwidth billing model. Standard_AvgBandWidth_ChinaCdn = The SKU name for a China CDN profile for VOD, Web and download scenarios using monthly average peak bandwidth billing model. StandardPlus_ChinaCdn = The SKU name for a China CDN profile for live-streaming using GB based billing model. StandardPlus_955BandWidth_ChinaCdn = The SKU name for a China CDN live-streaming profile using 95-5 peak bandwidth billing model. StandardPlus_AvgBandWidth_ChinaCdn = The SKU name for a China CDN live-streaming profile using monthly average peak bandwidth billing model. | | subscriptionId | text | field from the properties object | | tags | text | Resource tags. |

Name	Datatype	Description
`identity`	`object`	Managed service identity (system assigned and/or user assigned identities)
`kind`	`string`	Kind of the profile. Used by portal to differentiate traditional CDN profile and new AFD profile.
`location`	`string`	Resource location.
`properties`	`object`	The JSON object that contains the properties required to create a profile.
`sku`	`object`	Standard_Verizon = The SKU name for a Standard Verizon CDN profile.

Methods

Name	Accessible by	Required Params	Description
`get`	`SELECT`	`profileName, resourceGroupName, subscriptionId`	Gets an Azure Front Door Standard or Azure Front Door Premium or CDN profile with the specified profile name under the specified subscription and resource group.
`list`	`SELECT`	`subscriptionId`	Lists all of the Azure Front Door Standard, Azure Front Door Premium, and CDN profiles within an Azure subscription.
`list_by_resource_group`	`SELECT`	`resourceGroupName, subscriptionId`	Lists all of the Azure Front Door Standard, Azure Front Door Premium, and CDN profiles within a resource group.
`create`	`INSERT`	`profileName, resourceGroupName, subscriptionId, data__sku`	Creates a new Azure Front Door Standard or Azure Front Door Premium or CDN profile with a profile name under the specified subscription and resource group.
`delete`	`DELETE`	`profileName, resourceGroupName, subscriptionId`	Deletes an existing Azure Front Door Standard or Azure Front Door Premium or CDN profile with the specified parameters. Deleting a profile will result in the deletion of all of the sub-resources including endpoints, origins and custom domains.
`update`	`UPDATE`	`profileName, resourceGroupName, subscriptionId`	Updates an existing Azure Front Door Standard or Azure Front Door Premium or CDN profile with the specified profile name under the specified subscription and resource group.
`can_migrate`	`EXEC`	`resourceGroupName, subscriptionId, data__classicResourceReference`	Checks if CDN profile can be migrated to Azure Frontdoor(Standard/Premium) profile.
`generate_sso_uri`	`EXEC`	`profileName, resourceGroupName, subscriptionId`	Generates a dynamic SSO URI used to sign in to the CDN supplemental portal. Supplemental portal is used to configure advanced feature capabilities that are not yet available in the Azure portal, such as core reports in a standard profile; rules engine, advanced HTTP reports, and real-time stats and alerts in a premium profile. The SSO URI changes approximately every 10 minutes.
`migrate`	`EXEC`	`resourceGroupName, subscriptionId, data__classicResourceReference, data__profileName, data__sku`	Migrate the CDN profile to Azure Frontdoor(Standard/Premium) profile. The change need to be committed after this.
`migration_commit`	`EXEC`	`profileName, resourceGroupName, subscriptionId`	Commit the migrated Azure Frontdoor(Standard/Premium) profile.

`SELECT` examples

Lists all of the Azure Front Door Standard, Azure Front Door Premium, and CDN profiles within an Azure subscription.

vw_profiles
profiles

SELECT
extended_properties,
front_door_id,
identity,
kind,
location,
log_scrubbing,
origin_response_timeout_seconds,
profileName,
provisioning_state,
resourceGroupName,
resource_state,
sku,
subscriptionId,
tags
FROM azure.cdn.vw_profiles
WHERE subscriptionId = '{{ subscriptionId }}';

SELECT
identity,
kind,
location,
properties,
sku,
tags
FROM azure.cdn.profiles
WHERE subscriptionId = '{{ subscriptionId }}';

`INSERT` example

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

All Properties
Manifest

/*+ create */
INSERT INTO azure.cdn.profiles (
profileName,
resourceGroupName,
subscriptionId,
data__sku,
location,
tags,
sku,
identity,
properties
)
SELECT 
'{{ profileName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ data__sku }}',
'{{ location }}',
'{{ tags }}',
'{{ sku }}',
'{{ identity }}',
'{{ properties }}'
;

- name: your_resource_model_name
  props:
    - name: location
      value: string
    - name: tags
      value: object
    - name: sku
      value:
        - name: name
          value: string
    - name: kind
      value: string
    - name: identity
      value:
        - name: principalId
          value: string
        - name: tenantId
          value: string
        - name: type
          value: []
        - name: userAssignedIdentities
          value: []
    - name: properties
      value:
        - name: resourceState
          value: string
        - name: provisioningState
          value: string
        - name: extendedProperties
          value: object
        - name: frontDoorId
          value: string
        - name: originResponseTimeoutSeconds
          value: integer
        - name: logScrubbing
          value:
            - name: state
              value: string
            - name: scrubbingRules
              value:
                - - name: matchVariable
                    value: string
                  - name: selectorMatchOperator
                    value: string
                  - name: selector
                    value: string
                  - name: state
                    value: string

`UPDATE` example

Updates a profiles resource.

/*+ update */
UPDATE azure.cdn.profiles
SET 
tags = '{{ tags }}',
identity = '{{ identity }}',
properties = '{{ properties }}'
WHERE 
profileName = '{{ profileName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

`DELETE` example

Deletes the specified profiles resource.

/*+ delete */
DELETE FROM azure.cdn.profiles
WHERE profileName = '{{ profileName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

Overview​

Fields​

Methods​

SELECT examples​

INSERT example​

UPDATE example​

DELETE example​