data_manager_for_agriculture_resources

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

Overview

Name	data_manager_for_agriculture_resources
Type	Resource
Id	azure_extras.ag_food_platform.data_manager_for_agriculture_resources

Fields

vw_data_manager_for_agriculture_resources

Name	Datatype	Description
dataManagerForAgricultureResourceName	text	field from the properties object
identity	text	Identity for the resource.
instance_uri	text	field from the properties object
location	text	The geo-location where the resource lives
private_endpoint_connections	text	field from the properties object
provisioning_state	text	field from the properties object
public_network_access	text	field from the properties object
resourceGroupName	text	field from the properties object
sensor_integration	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	Resource tags.

data_manager_for_agriculture_resources

Name	Datatype	Description
identity	object	Identity for the resource.
location	string	The geo-location where the resource lives
properties	object	Data Manager For Agriculture ARM Resource properties.
tags	object	Resource tags.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	dataManagerForAgricultureResourceName, resourceGroupName, subscriptionId	Get DataManagerForAgriculture resource.
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	Lists the DataManagerForAgriculture instances for a resource group.
list_by_subscription	SELECT	subscriptionId	Lists the DataManagerForAgriculture instances for a subscription.
create_or_update	INSERT	dataManagerForAgricultureResourceName, resourceGroupName, subscriptionId	Create or update Data Manager For Agriculture resource.
delete	DELETE	dataManagerForAgricultureResourceName, resourceGroupName, subscriptionId	Delete a Data Manager For Agriculture resource.
update	UPDATE	dataManagerForAgricultureResourceName, resourceGroupName, subscriptionId	Update a Data Manager For Agriculture resource.

SELECT examples

Lists the DataManagerForAgriculture instances for a subscription.

vw_data_manager_for_agriculture_resources

SELECT
dataManagerForAgricultureResourceName,
identity,
instance_uri,
location,
private_endpoint_connections,
provisioning_state,
public_network_access,
resourceGroupName,
sensor_integration,
subscriptionId,
tags
FROM azure_extras.ag_food_platform.vw_data_manager_for_agriculture_resources
WHERE subscriptionId = '{{ subscriptionId }}';

data_manager_for_agriculture_resources

SELECT
identity,
location,
properties,
tags
FROM azure_extras.ag_food_platform.data_manager_for_agriculture_resources
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure_extras.ag_food_platform.data_manager_for_agriculture_resources (
dataManagerForAgricultureResourceName,
resourceGroupName,
subscriptionId,
tags,
location,
identity,
properties
)
SELECT 
'{{ dataManagerForAgricultureResourceName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ tags }}',
'{{ location }}',
'{{ identity }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: tags
      value: object
    - name: location
      value: string
    - name: identity
      value:
        - name: principalId
          value: string
        - name: tenantId
          value: string
        - name: type
          value: string
    - name: properties
      value:
        - name: instanceUri
          value: string
        - name: provisioningState
          value: string
        - name: sensorIntegration
          value:
            - name: enabled
              value: string
            - name: provisioningState
              value: string
            - name: provisioningInfo
              value:
                - name: error
                  value:
                    - name: code
                      value: string
                    - name: message
                      value: string
                    - name: target
                      value: string
                    - name: details
                      value:
                        - - name: code
                            value: string
                          - name: message
                            value: string
                          - name: target
                            value: string
                          - name: details
                            value:
                              - - name: code
                                  value: string
                                - name: message
                                  value: string
                                - name: target
                                  value: string
                                - name: details
                                  value:
                                    - - name: code
                                        value: string
                                      - name: message
                                        value: string
                                      - name: target
                                        value: string
                                      - name: details
                                        value:
                                          - - name: code
                                              value: string
                                            - name: message
                                              value: string
                                            - name: target
                                              value: string
                                            - name: details
                                              value:
                                                - - name: code
                                                    value: string
                                                  - name: message
                                                    value: string
                                                  - name: target
                                                    value: string
                                                  - name: details
                                                    value:
                                                      - - name: code
                                                          value: string
                                                        - name: message
                                                          value: string
                                                        - name: target
                                                          value: string
                                                        - name: details
                                                          value:
                                                            - []
                                                        - name: additionalInfo
                                                          value:
                                                            - []
                                                  - name: additionalInfo
                                                    value:
                                                      - - name: type
                                                          value: string
                                                        - name: info
                                                          value: object
                                            - name: additionalInfo
                                              value:
                                                - - name: type
                                                    value: string
                                                  - name: info
                                                    value: object
                                      - name: additionalInfo
                                        value:
                                          - - name: type
                                              value: string
                                            - name: info
                                              value: object
                                - name: additionalInfo
                                  value:
                                    - - name: type
                                        value: string
                                      - name: info
                                        value: object
                          - name: additionalInfo
                            value:
                              - - name: type
                                  value: string
                                - name: info
                                  value: object
                    - name: additionalInfo
                      value:
                        - - name: type
                            value: string
                          - name: info
                            value: object
        - name: publicNetworkAccess
          value: []
        - name: privateEndpointConnections
          value:
            - - name: properties
                value:
                  - name: groupIds
                    value:
                      - string
                  - name: privateEndpoint
                    value:
                      - name: id
                        value: string
                  - name: privateLinkServiceConnectionState
                    value:
                      - name: status
                        value: []
                      - name: description
                        value: string
                      - name: actionsRequired
                        value: string
                  - name: provisioningState
                    value: []
              - name: id
                value: string
              - name: name
                value: string
              - name: type
                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 data_manager_for_agriculture_resources resource.

/*+ update */
UPDATE azure_extras.ag_food_platform.data_manager_for_agriculture_resources
SET 
location = '{{ location }}',
identity = '{{ identity }}',
properties = '{{ properties }}',
tags = '{{ tags }}'
WHERE 
dataManagerForAgricultureResourceName = '{{ dataManagerForAgricultureResourceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified data_manager_for_agriculture_resources resource.

/*+ delete */
DELETE FROM azure_extras.ag_food_platform.data_manager_for_agriculture_resources
WHERE dataManagerForAgricultureResourceName = '{{ dataManagerForAgricultureResourceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';