modelings

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

Overview

Name	modelings
Type	Resource
Id	azure_extras.intelligent_recommendations.modelings

Fields

Name	Datatype	Description
location	string	The geo-location where the resource lives
properties	object	Modeling resource properties.
systemData	object	Metadata pertaining to creation and last modification of the resource.
tags	object	Resource tags.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	accountName, modelingName, resourceGroupName, subscriptionId	Returns Modeling resources for a given name.
list_by_account_resource	SELECT	accountName, resourceGroupName, subscriptionId	Returns list of Modeling resources for a given Account name.
create_or_update	INSERT	accountName, modelingName, resourceGroupName, subscriptionId	Creates or updates Modeling resource.
delete	DELETE	accountName, modelingName, resourceGroupName, subscriptionId	Deletes Modeling resources of a given name.
update	UPDATE	accountName, modelingName, resourceGroupName, subscriptionId	Updates Modeling resource details.

SELECT examples

Returns list of Modeling resources for a given Account name.

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

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure_extras.intelligent_recommendations.modelings (
accountName,
modelingName,
resourceGroupName,
subscriptionId,
tags,
location,
properties,
systemData
)
SELECT 
'{{ accountName }}',
'{{ modelingName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ tags }}',
'{{ location }}',
'{{ properties }}',
'{{ systemData }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: tags
      value: object
    - name: location
      value: string
    - name: properties
      value:
        - name: features
          value: string
        - name: frequency
          value: string
        - name: size
          value: string
        - name: inputData
          value:
            - name: connectionString
              value: string
        - name: provisioningState
          value: string
    - name: systemData
      value:
        - name: createdBy
          value: string
        - name: createdByType
          value: string
        - name: createdAt
          value: string
        - name: lastModifiedBy
          value: string
        - name: lastModifiedByType
          value: string
        - name: lastModifiedAt
          value: string

UPDATE example

Updates a modelings resource.

/*+ update */
UPDATE azure_extras.intelligent_recommendations.modelings
SET 
tags = '{{ tags }}',
properties = '{{ properties }}'
WHERE 
accountName = '{{ accountName }}'
AND modelingName = '{{ modelingName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified modelings resource.

/*+ delete */
DELETE FROM azure_extras.intelligent_recommendations.modelings
WHERE accountName = '{{ accountName }}'
AND modelingName = '{{ modelingName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';