Skip to main content

policies

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

Overview

Namepolicies
TypeResource
Idazure.front_door.policies

Fields

The following fields are returned by SELECT queries:

OK. The request has succeeded.

NameDatatypeDescription
idstringResource ID.
namestringResource name.
etagstringGets a unique read-only string that changes whenever the resource is updated.
locationstringResource location.
propertiesobjectProperties of the web application firewall policy.
skuobjectThe pricing tier of web application firewall policy. Defaults to Classic_AzureFrontDoor if not specified.
tagsobjectResource tags.
typestringResource type.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresourceGroupName, policyName, 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_updateinsertresourceGroupName, policyName, subscriptionIdCreate or update policy with specified rule set name within a resource group.
updateupdateresourceGroupName, policyName, subscriptionIdPatch a specific frontdoor webApplicationFirewall policy for tags update under the specified subscription and resource group.
deletedeleteresourceGroupName, policyName, subscriptionIdDeletes Policy

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
policyNamestringThe name of the Web Application Firewall Policy.
resourceGroupNamestringName of the Resource group within the Azure subscription.
subscriptionIdstringThe subscription credentials which uniquely identify the Microsoft Azure subscription. The subscription ID forms part of the URI for every service call.

SELECT examples

Retrieve protection policy with specified name within a resource group.

SELECT
id,
name,
etag,
location,
properties,
sku,
tags,
type
FROM azure.front_door.policies
WHERE resourceGroupName = '{{ resourceGroupName }}' -- required
AND policyName = '{{ policyName }}' -- required
AND subscriptionId = '{{ subscriptionId }}' -- required
;

INSERT examples

Create or update policy with specified rule set name within a resource group.

INSERT INTO azure.front_door.policies (
data__properties,
data__etag,
data__sku,
data__location,
data__tags,
resourceGroupName,
policyName,
subscriptionId
)
SELECT
'{{ properties }}',
'{{ etag }}',
'{{ sku }}',
'{{ location }}',
'{{ tags }}',
'{{ resourceGroupName }}',
'{{ policyName }}',
'{{ subscriptionId }}'
RETURNING
id,
name,
etag,
location,
properties,
sku,
tags,
type
;

UPDATE examples

Patch a specific frontdoor webApplicationFirewall policy for tags update under the specified subscription and resource group.

UPDATE azure.front_door.policies
SET
data__tags = '{{ tags }}'
WHERE
resourceGroupName = '{{ resourceGroupName }}' --required
AND policyName = '{{ policyName }}' --required
AND subscriptionId = '{{ subscriptionId }}' --required
RETURNING
id,
name,
etag,
location,
properties,
sku,
tags,
type;

DELETE examples

Deletes Policy

DELETE FROM azure.front_door.policies
WHERE resourceGroupName = '{{ resourceGroupName }}' --required
AND policyName = '{{ policyName }}' --required
AND subscriptionId = '{{ subscriptionId }}' --required
;