storage_accounts

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

Overview

Name	storage_accounts
Type	Resource
Id	azure.data_lake_analytics.storage_accounts

Fields

vw_storage_accounts

Name	Datatype	Description
id	text	The resource identifier.
name	text	The resource name.
accountName	text	field from the properties object
resourceGroupName	text	field from the properties object
storageAccountName	text	field from the properties object
subscriptionId	text	field from the properties object
suffix	text	field from the properties object
type	text	The resource type.

storage_accounts

Name	Datatype	Description
id	string	The resource identifier.
name	string	The resource name.
properties	object	The Azure Storage account properties.
type	string	The resource type.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	accountName, resourceGroupName, storageAccountName, subscriptionId	Gets the specified Azure Storage account linked to the given Data Lake Analytics account.
list_by_account	SELECT	accountName, resourceGroupName, subscriptionId	Gets the first page of Azure Storage accounts, if any, linked to the specified Data Lake Analytics account. The response includes a link to the next page, if any.
delete	DELETE	accountName, resourceGroupName, storageAccountName, subscriptionId	Updates the specified Data Lake Analytics account to remove an Azure Storage account.
update	UPDATE	accountName, resourceGroupName, storageAccountName, subscriptionId	Updates the Data Lake Analytics account to replace Azure Storage blob account details, such as the access key and/or suffix.
add	EXEC	accountName, resourceGroupName, storageAccountName, subscriptionId, data__properties	Updates the specified Data Lake Analytics account to add an Azure Storage account.

SELECT examples

Gets the first page of Azure Storage accounts, if any, linked to the specified Data Lake Analytics account. The response includes a link to the next page, if any.

vw_storage_accounts

SELECT
id,
name,
accountName,
resourceGroupName,
storageAccountName,
subscriptionId,
suffix,
type
FROM azure.data_lake_analytics.vw_storage_accounts
WHERE accountName = '{{ accountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

storage_accounts

SELECT
id,
name,
properties,
type
FROM azure.data_lake_analytics.storage_accounts
WHERE accountName = '{{ accountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

UPDATE example

Updates a storage_accounts resource.

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

DELETE example

Deletes the specified storage_accounts resource.

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