Skip to main content

compute_policies

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

Overview

Namecompute_policies
TypeResource
Idazure.data_lake_analytics.compute_policies

Fields

NameDatatypeDescription
idtextThe resource identifier.
nametextThe resource name.
accountNametextfield from the properties object
computePolicyNametextfield from the properties object
max_degree_of_parallelism_per_jobtextfield from the properties object
min_priority_per_jobtextfield from the properties object
object_idtextfield from the properties object
object_typetextfield from the properties object
resourceGroupNametextfield from the properties object
subscriptionIdtextfield from the properties object
typetextThe resource type.

Methods

NameAccessible byRequired ParamsDescription
getSELECTaccountName, computePolicyName, resourceGroupName, subscriptionIdGets the specified Data Lake Analytics compute policy.
list_by_accountSELECTaccountName, resourceGroupName, subscriptionIdLists the Data Lake Analytics compute policies within the specified Data Lake Analytics account. An account supports, at most, 50 policies
create_or_updateINSERTaccountName, computePolicyName, resourceGroupName, subscriptionId, data__propertiesCreates or updates the specified compute policy. During update, the compute policy with the specified name will be replaced with this new compute policy. An account supports, at most, 50 policies
deleteDELETEaccountName, computePolicyName, resourceGroupName, subscriptionIdDeletes the specified compute policy from the specified Data Lake Analytics account
updateUPDATEaccountName, computePolicyName, resourceGroupName, subscriptionIdUpdates the specified compute policy.

SELECT examples

Lists the Data Lake Analytics compute policies within the specified Data Lake Analytics account. An account supports, at most, 50 policies

SELECT
id,
name,
accountName,
computePolicyName,
max_degree_of_parallelism_per_job,
min_priority_per_job,
object_id,
object_type,
resourceGroupName,
subscriptionId,
type
FROM azure.data_lake_analytics.vw_compute_policies
WHERE accountName = '{{ accountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

/*+ create */
INSERT INTO azure.data_lake_analytics.compute_policies (
accountName,
computePolicyName,
resourceGroupName,
subscriptionId,
data__properties,
properties
)
SELECT
'{{ accountName }}',
'{{ computePolicyName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ data__properties }}',
'{{ properties }}'
;

UPDATE example

Updates a compute_policies resource.

/*+ update */
UPDATE azure.data_lake_analytics.compute_policies
SET
properties = '{{ properties }}'
WHERE
accountName = '{{ accountName }}'
AND computePolicyName = '{{ computePolicyName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified compute_policies resource.

/*+ delete */
DELETE FROM azure.data_lake_analytics.compute_policies
WHERE accountName = '{{ accountName }}'
AND computePolicyName = '{{ computePolicyName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';