Skip to main content

accounts

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

Overview

Nameaccounts
TypeResource
Idazure_extras.intelligent_recommendations.accounts

Fields

The following fields are returned by SELECT queries:

Account details.

NameDatatypeDescription
identityobjectThe identity used for the resource.
locationstringThe geo-location where the resource lives
propertiesobjectAccount resource properties.
systemDataobjectMetadata pertaining to creation and last modification of the resource.
tagsobjectResource tags.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, accountNameReturns RecommendationsService Account resource for a given name.
list_by_resource_groupselectsubscriptionId, resourceGroupNameReturns list of RecommendationsService Account resources.
list_by_subscriptionselectsubscriptionIdReturns list of RecommendationsService Account resources.
create_or_updateinsertsubscriptionId, resourceGroupName, accountNameCreates or updates RecommendationsService Account resource.
updateupdatesubscriptionId, resourceGroupName, accountNameUpdates RecommendationsService Account details.
deletedeletesubscriptionId, resourceGroupName, accountNameDeletes RecommendationsService Account resource.
check_name_availabilityexecsubscriptionIdChecks that the RecommendationsService Account name is valid and is not already in use.

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 RecommendationsService Account resource.
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
subscriptionIdstringThe ID of the target subscription.

SELECT examples

Returns RecommendationsService Account resource for a given name.

SELECT
identity,
location,
properties,
systemData,
tags
FROM azure_extras.intelligent_recommendations.accounts
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND accountName = '{{ accountName }}' -- required
;

INSERT examples

Creates or updates RecommendationsService Account resource.

INSERT INTO azure_extras.intelligent_recommendations.accounts (
data__tags,
data__location,
data__properties,
data__identity,
subscriptionId,
resourceGroupName,
accountName
)
SELECT
'{{ tags }}',
'{{ location }}',
'{{ properties }}',
'{{ identity }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ accountName }}'
RETURNING
identity,
location,
properties,
systemData,
tags
;

UPDATE examples

Updates RecommendationsService Account details.

UPDATE azure_extras.intelligent_recommendations.accounts
SET
data__tags = '{{ tags }}',
data__properties = '{{ properties }}',
data__identity = '{{ identity }}'
WHERE
subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND accountName = '{{ accountName }}' --required
RETURNING
identity,
location,
properties,
systemData,
tags;

DELETE examples

Deletes RecommendationsService Account resource.

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

Lifecycle Methods

Checks that the RecommendationsService Account name is valid and is not already in use.

EXEC azure_extras.intelligent_recommendations.accounts.check_name_availability 
@subscriptionId='{{ subscriptionId }}' --required
@@json=
'{
"name": "{{ name }}",
"type": "{{ type }}"
}'
;