Skip to main content

policies

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

Overview

Namepolicies
TypeResource
Idazure.front_door.policies

Fields

NameDatatypeDescription
idtextResource ID.
nametextResource name.
custom_rulestextfield from the properties object
etagtextGets a unique read-only string that changes whenever the resource is updated.
frontend_endpoint_linkstextfield from the properties object
locationtextResource location.
managed_rulestextfield from the properties object
policyNametextfield from the properties object
policy_settingstextfield from the properties object
provisioning_statetextfield from the properties object
resourceGroupNametextfield from the properties object
resource_statetextfield from the properties object
routing_rule_linkstextfield from the properties object
security_policy_linkstextfield from the properties object
skutextThe pricing tier of the web application firewall policy.
subscriptionIdtextfield from the properties object
tagstextResource tags.
typetextResource type.

Methods

NameAccessible byRequired ParamsDescription
getSELECTpolicyName, resourceGroupName, subscriptionIdRetrieve protection policy with specified name within a resource group.
listSELECTresourceGroupName, subscriptionIdLists all of the protection policies within a resource group.
list_by_subscriptionSELECTsubscriptionIdLists all of the protection policies within a subscription.
create_or_updateINSERTpolicyName, resourceGroupName, subscriptionIdCreate or update policy with specified rule set name within a resource group.
deleteDELETEpolicyName, resourceGroupName, subscriptionIdDeletes Policy
updateUPDATEpolicyName, resourceGroupName, subscriptionIdPatch a specific frontdoor webApplicationFirewall policy for tags update under the specified subscription and resource group.

SELECT examples

Lists all of the protection policies within a subscription.

SELECT
id,
name,
custom_rules,
etag,
frontend_endpoint_links,
location,
managed_rules,
policyName,
policy_settings,
provisioning_state,
resourceGroupName,
resource_state,
routing_rule_links,
security_policy_links,
sku,
subscriptionId,
tags,
type
FROM azure.front_door.vw_policies
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

/*+ create */
INSERT INTO azure.front_door.policies (
policyName,
resourceGroupName,
subscriptionId,
properties,
etag,
sku,
location,
tags
)
SELECT
'{{ policyName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}',
'{{ etag }}',
'{{ sku }}',
'{{ location }}',
'{{ tags }}'
;

UPDATE example

Updates a policies resource.

/*+ update */
UPDATE azure.front_door.policies
SET
tags = '{{ tags }}'
WHERE
policyName = '{{ policyName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified policies resource.

/*+ delete */
DELETE FROM azure.front_door.policies
WHERE policyName = '{{ policyName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';