Skip to main content

accounts

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

Overview

Nameaccounts
TypeResource
Idazure.data_lake_store.accounts

Fields

The following fields are returned by SELECT queries:

Successfully retrieved details of the specified account.

NameDatatypeDescription
idstringThe resource identifier.
namestringThe resource name.
identityobjectThe Key Vault encryption identity, if any.
locationstringThe resource location.
propertiesobjectThe Data Lake Store account properties.
tagsobjectThe resource tags.
typestringThe resource type.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, accountNameGets the specified Data Lake Store account.
list_by_resource_groupselectsubscriptionId, resourceGroupName$filter, $top, $skip, $select, $orderby, $countLists the Data Lake Store accounts within a specific resource group. The response includes a link to the next page of results, if any.
listselectsubscriptionId$filter, $top, $skip, $select, $orderby, $countLists the Data Lake Store accounts within the subscription. The response includes a link to the next page of results, if any.
createinsertsubscriptionId, resourceGroupName, accountName, data__locationCreates the specified Data Lake Store account.
updateupdatesubscriptionId, resourceGroupName, accountNameUpdates the specified Data Lake Store account information.
deletedeletesubscriptionId, resourceGroupName, accountNameDeletes the specified Data Lake Store account.
enable_key_vaultexecsubscriptionId, resourceGroupName, accountNameAttempts to enable a user managed Key Vault for encryption of the specified Data Lake Store account.
check_name_availabilityexecsubscriptionId, location, name, typeChecks whether the specified account name is available or taken.

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
accountNamestringThe name of the Data Lake Store account.
locationstringThe resource location without whitespace.
resourceGroupNamestringThe name of the Azure resource group.
subscriptionIdstringGets subscription credentials which uniquely identify Microsoft Azure subscription. The subscription ID forms part of the URI for every service call.
$countbooleanThe Boolean value of true or false to request a count of the matching resources included with the resources in the response, e.g. Categories?$count=true. Optional.
$filterstringOData filter. Optional.
$orderbystringOrderBy clause. One or more comma-separated expressions with an optional "asc" (the default) or "desc" depending on the order you'd like the values sorted, e.g. Categories?$orderby=CategoryName desc. Optional.
$selectstringOData Select statement. Limits the properties on each entry to just those requested, e.g. Categories?$select=CategoryName,Description. Optional.
$skipinteger (int32)The number of items to skip over before returning elements. Optional.
$topinteger (int32)The number of items to return. Optional.

SELECT examples

Gets the specified Data Lake Store account.

SELECT
id,
name,
identity,
location,
properties,
tags,
type
FROM azure.data_lake_store.accounts
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND accountName = '{{ accountName }}' -- required
;

INSERT examples

Creates the specified Data Lake Store account.

INSERT INTO azure.data_lake_store.accounts (
data__location,
data__tags,
data__identity,
data__properties,
subscriptionId,
resourceGroupName,
accountName
)
SELECT
'{{ location }}' /* required */,
'{{ tags }}',
'{{ identity }}',
'{{ properties }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ accountName }}'
RETURNING
id,
name,
identity,
location,
properties,
tags,
type
;

UPDATE examples

Updates the specified Data Lake Store account information.

UPDATE azure.data_lake_store.accounts
SET
data__tags = '{{ tags }}',
data__properties = '{{ properties }}'
WHERE
subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND accountName = '{{ accountName }}' --required
RETURNING
id,
name,
identity,
location,
properties,
tags,
type;

DELETE examples

Deletes the specified Data Lake Store account.

DELETE FROM azure.data_lake_store.accounts
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND accountName = '{{ accountName }}' --required
;

Lifecycle Methods

Attempts to enable a user managed Key Vault for encryption of the specified Data Lake Store account.

EXEC azure.data_lake_store.accounts.enable_key_vault 
@subscriptionId='{{ subscriptionId }}' --required,
@resourceGroupName='{{ resourceGroupName }}' --required,
@accountName='{{ accountName }}' --required
;