Skip to main content

modelings

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

Overview

Namemodelings
TypeResource
Idazure_extras.intelligent_recommendations.modelings

Fields

The following fields are returned by SELECT queries:

Modeling resource details.

NameDatatypeDescription
locationstringThe geo-location where the resource lives
propertiesobjectModeling 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, accountName, modelingNameReturns Modeling resources for a given name.
list_by_account_resourceselectsubscriptionId, resourceGroupName, accountNameReturns list of Modeling resources for a given Account name.
create_or_updateinsertsubscriptionId, resourceGroupName, accountName, modelingNameCreates or updates Modeling resource.
updateupdatesubscriptionId, resourceGroupName, accountName, modelingNameUpdates Modeling resource details.
deletedeletesubscriptionId, resourceGroupName, accountName, modelingNameDeletes Modeling resources of a given name.

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

SELECT examples

Returns Modeling resources for a given name.

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

INSERT examples

Creates or updates Modeling resource.

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

UPDATE examples

Updates Modeling resource details.

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

DELETE examples

Deletes Modeling resources of a given name.

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