accounts

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

Overview

Name	accounts
Type	Resource
Id	azure.data_lake_analytics.accounts

Fields

vw_accounts

Name	Datatype	Description
id	text	The resource identifier.
name	text	The resource name.
accountName	text	field from the properties object
account_id	text	field from the properties object
compute_policies	text	field from the properties object
creation_time	text	field from the properties object
current_tier	text	field from the properties object
data_lake_store_accounts	text	field from the properties object
debug_data_access_level	text	field from the properties object
default_data_lake_store_account	text	field from the properties object
default_data_lake_store_account_type	text	field from the properties object
endpoint	text	field from the properties object
firewall_allow_azure_ips	text	field from the properties object
firewall_rules	text	field from the properties object
firewall_state	text	field from the properties object
hive_metastores	text	field from the properties object
last_modified_time	text	field from the properties object
location	text	The resource location.
max_active_job_count_per_user	text	field from the properties object
max_degree_of_parallelism	text	field from the properties object
max_degree_of_parallelism_per_job	text	field from the properties object
max_job_count	text	field from the properties object
max_job_running_time_in_min	text	field from the properties object
max_queued_job_count_per_user	text	field from the properties object
min_priority_per_job	text	field from the properties object
new_tier	text	field from the properties object
provisioning_state	text	field from the properties object
public_data_lake_store_accounts	text	field from the properties object
query_store_retention	text	field from the properties object
resourceGroupName	text	field from the properties object
state	text	field from the properties object
storage_accounts	text	field from the properties object
subscriptionId	text	field from the properties object
system_max_degree_of_parallelism	text	field from the properties object
system_max_job_count	text	field from the properties object
tags	text	The resource tags.
type	text	The resource type.
virtual_network_rules	text	field from the properties object

accounts

Name	Datatype	Description
id	string	The resource identifier.
name	string	The resource name.
location	string	The resource location.
properties	object	The account specific properties that are associated with an underlying Data Lake Analytics account. Returned only when retrieving a specific account.
tags	object	The resource tags.
type	string	The resource type.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	accountName, resourceGroupName, subscriptionId	Gets details of the specified Data Lake Analytics account.
list	SELECT	subscriptionId	Gets the first page of Data Lake Analytics accounts, if any, within the current subscription. This includes a link to the next page, if any.
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	Gets the first page of Data Lake Analytics accounts, if any, within a specific resource group. This includes a link to the next page, if any.
create	INSERT	accountName, resourceGroupName, subscriptionId, data__location, data__properties	Creates the specified Data Lake Analytics account. This supplies the user with computation services for Data Lake Analytics workloads.
delete	DELETE	accountName, resourceGroupName, subscriptionId	Begins the delete process for the Data Lake Analytics account object specified by the account name.
update	UPDATE	accountName, resourceGroupName, subscriptionId	Updates the Data Lake Analytics account object specified by the accountName with the contents of the account object.
check_name_availability	EXEC	location, subscriptionId, data__name, data__type	Checks whether the specified account name is available or taken.

SELECT examples

Gets the first page of Data Lake Analytics accounts, if any, within the current subscription. This includes a link to the next page, if any.

vw_accounts

SELECT
id,
name,
accountName,
account_id,
compute_policies,
creation_time,
current_tier,
data_lake_store_accounts,
debug_data_access_level,
default_data_lake_store_account,
default_data_lake_store_account_type,
endpoint,
firewall_allow_azure_ips,
firewall_rules,
firewall_state,
hive_metastores,
last_modified_time,
location,
max_active_job_count_per_user,
max_degree_of_parallelism,
max_degree_of_parallelism_per_job,
max_job_count,
max_job_running_time_in_min,
max_queued_job_count_per_user,
min_priority_per_job,
new_tier,
provisioning_state,
public_data_lake_store_accounts,
query_store_retention,
resourceGroupName,
state,
storage_accounts,
subscriptionId,
system_max_degree_of_parallelism,
system_max_job_count,
tags,
type,
virtual_network_rules
FROM azure.data_lake_analytics.vw_accounts
WHERE subscriptionId = '{{ subscriptionId }}';

accounts

SELECT
id,
name,
location,
properties,
tags,
type
FROM azure.data_lake_analytics.accounts
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.data_lake_analytics.accounts (
accountName,
resourceGroupName,
subscriptionId,
data__location,
data__properties,
location,
tags,
properties
)
SELECT 
'{{ accountName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ data__location }}',
'{{ data__properties }}',
'{{ location }}',
'{{ tags }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: location
      value: string
    - name: tags
      value: object
    - name: properties
      value:
        - name: defaultDataLakeStoreAccount
          value: string
        - name: dataLakeStoreAccounts
          value:
            - - name: name
                value: string
              - name: properties
                value:
                  - name: suffix
                    value: string
        - name: storageAccounts
          value:
            - - name: name
                value: string
              - name: properties
                value:
                  - name: accessKey
                    value: string
                  - name: suffix
                    value: string
        - name: computePolicies
          value:
            - - name: name
                value: string
              - name: properties
                value:
                  - name: objectId
                    value: string
                  - name: objectType
                    value: string
                  - name: maxDegreeOfParallelismPerJob
                    value: integer
                  - name: minPriorityPerJob
                    value: integer
        - name: firewallRules
          value:
            - - name: name
                value: string
              - name: properties
                value:
                  - name: startIpAddress
                    value: string
                  - name: endIpAddress
                    value: string
        - name: firewallState
          value: string
        - name: firewallAllowAzureIps
          value: string
        - name: newTier
          value: string
        - name: maxJobCount
          value: integer
        - name: maxDegreeOfParallelism
          value: integer
        - name: maxDegreeOfParallelismPerJob
          value: integer
        - name: minPriorityPerJob
          value: integer
        - name: queryStoreRetention
          value: integer

UPDATE example

Updates a accounts resource.

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

DELETE example

Deletes the specified accounts resource.

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