Skip to main content

data_manager_for_agriculture_resources

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

Overview

Namedata_manager_for_agriculture_resources
TypeResource
Idazure_extras.ag_food_platform.data_manager_for_agriculture_resources

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
identityobjectIdentity for the resource.
locationstringThe geo-location where the resource lives
propertiesobjectData Manager For Agriculture ARM Resource properties.
tagsobjectResource tags.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, dataManagerForAgricultureResourceNameGet DataManagerForAgriculture resource.
list_by_resource_groupselectresourceGroupName, subscriptionId$maxPageSize, $skipTokenLists the DataManagerForAgriculture instances for a resource group.
list_by_subscriptionselectsubscriptionId$maxPageSize, $skipTokenLists the DataManagerForAgriculture instances for a subscription.
create_or_updateinsertsubscriptionId, resourceGroupName, dataManagerForAgricultureResourceNameCreate or update Data Manager For Agriculture resource.
updateupdatesubscriptionId, resourceGroupName, dataManagerForAgricultureResourceNameUpdate a Data Manager For Agriculture resource.
deletedeletesubscriptionId, resourceGroupName, dataManagerForAgricultureResourceNameDelete a Data Manager For Agriculture resource.

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
dataManagerForAgricultureResourceNamestringDataManagerForAgriculture resource name.
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
subscriptionIdstring (uuid)The ID of the target subscription. The value must be an UUID.
$maxPageSizeinteger (int32)Maximum number of items needed (inclusive). Minimum = 10, Maximum = 1000, Default value = 50.
$skipTokenstringSkip token for getting next set of results.

SELECT examples

Get DataManagerForAgriculture resource.

SELECT
identity,
location,
properties,
tags
FROM azure_extras.ag_food_platform.data_manager_for_agriculture_resources
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND dataManagerForAgricultureResourceName = '{{ dataManagerForAgricultureResourceName }}' -- required
;

INSERT examples

Create or update Data Manager For Agriculture resource.

INSERT INTO azure_extras.ag_food_platform.data_manager_for_agriculture_resources (
data__tags,
data__location,
data__identity,
data__properties,
subscriptionId,
resourceGroupName,
dataManagerForAgricultureResourceName
)
SELECT
'{{ tags }}',
'{{ location }}',
'{{ identity }}',
'{{ properties }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ dataManagerForAgricultureResourceName }}'
RETURNING
identity,
location,
properties,
tags
;

UPDATE examples

Update a Data Manager For Agriculture resource.

UPDATE azure_extras.ag_food_platform.data_manager_for_agriculture_resources
SET
data__location = '{{ location }}',
data__identity = '{{ identity }}',
data__properties = '{{ properties }}',
data__tags = '{{ tags }}'
WHERE
subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND dataManagerForAgricultureResourceName = '{{ dataManagerForAgricultureResourceName }}' --required
RETURNING
identity,
location,
properties,
tags;

DELETE examples

Delete a Data Manager For Agriculture resource.

DELETE FROM azure_extras.ag_food_platform.data_manager_for_agriculture_resources
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND dataManagerForAgricultureResourceName = '{{ dataManagerForAgricultureResourceName }}' --required
;