compute_policies
Creates, updates, deletes, gets or lists a compute_policies
resource.
Overview
Name | compute_policies |
Type | Resource |
Id | azure.data_lake_analytics.compute_policies |
Fields
- vw_compute_policies
- compute_policies
Name | Datatype | Description |
---|---|---|
id | text | The resource identifier. |
name | text | The resource name. |
accountName | text | field from the properties object |
computePolicyName | text | field from the properties object |
max_degree_of_parallelism_per_job | text | field from the properties object |
min_priority_per_job | text | field from the properties object |
object_id | text | field from the properties object |
object_type | text | field from the properties object |
resourceGroupName | text | field from the properties object |
subscriptionId | text | field from the properties object |
type | text | The resource type. |
Name | Datatype | Description |
---|---|---|
id | string | The resource identifier. |
name | string | The resource name. |
properties | object | The compute policy properties. |
type | string | The resource type. |
Methods
Name | Accessible by | Required Params | Description |
---|---|---|---|
get | SELECT | accountName, computePolicyName, resourceGroupName, subscriptionId | Gets the specified Data Lake Analytics compute policy. |
list_by_account | SELECT | accountName, resourceGroupName, subscriptionId | Lists the Data Lake Analytics compute policies within the specified Data Lake Analytics account. An account supports, at most, 50 policies |
create_or_update | INSERT | accountName, computePolicyName, resourceGroupName, subscriptionId, data__properties | Creates 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 |
delete | DELETE | accountName, computePolicyName, resourceGroupName, subscriptionId | Deletes the specified compute policy from the specified Data Lake Analytics account |
update | UPDATE | accountName, computePolicyName, resourceGroupName, subscriptionId | Updates 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
- vw_compute_policies
- compute_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 }}';
SELECT
id,
name,
properties,
type
FROM azure.data_lake_analytics.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.
- All Properties
- Manifest
/*+ create */
INSERT INTO azure.data_lake_analytics.compute_policies (
accountName,
computePolicyName,
resourceGroupName,
subscriptionId,
data__properties,
properties
)
SELECT
'{{ accountName }}',
'{{ computePolicyName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ data__properties }}',
'{{ properties }}'
;
- name: your_resource_model_name
props:
- name: properties
value:
- name: objectId
value: string
- name: objectType
value: string
- name: maxDegreeOfParallelismPerJob
value: integer
- name: minPriorityPerJob
value: integer
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 }}';