Skip to main content

data_connectors

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

Overview

Namedata_connectors
TypeResource
Idazure_extras.ag_food_platform.data_connectors

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
eTagstringThe ETag value to implement optimistic concurrency.
propertiesobjectDataConnector Properties.
systemDataobjectMetadata pertaining to creation and last modification of the resource.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresourceGroupName, subscriptionId, dataManagerForAgricultureResourceName, dataConnectorNameGet specific Data Connector resource by DataConnectorName.
listselectsubscriptionId, resourceGroupName, dataManagerForAgricultureResourceName$maxPageSize, $skipTokenLists the Data Connector Credentials for MADMA instance.
create_or_updateinsertresourceGroupName, subscriptionId, dataManagerForAgricultureResourceName, dataConnectorName, data__propertiesCreate or update Data Connector For MADMA resource.
deletedeleteresourceGroupName, subscriptionId, dataManagerForAgricultureResourceName, dataConnectorNameDelete a Data Connectors with given dataConnector 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
dataConnectorNamestringConnector name.
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.
$skipTokenstringContinuation token for getting next set of results.

SELECT examples

Get specific Data Connector resource by DataConnectorName.

SELECT
eTag,
properties,
systemData
FROM azure_extras.ag_food_platform.data_connectors
WHERE resourceGroupName = '{{ resourceGroupName }}' -- required
AND subscriptionId = '{{ subscriptionId }}' -- required
AND dataManagerForAgricultureResourceName = '{{ dataManagerForAgricultureResourceName }}' -- required
AND dataConnectorName = '{{ dataConnectorName }}' -- required
;

INSERT examples

Create or update Data Connector For MADMA resource.

INSERT INTO azure_extras.ag_food_platform.data_connectors (
data__properties,
resourceGroupName,
subscriptionId,
dataManagerForAgricultureResourceName,
dataConnectorName
)
SELECT
'{{ properties }}' /* required */,
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ dataManagerForAgricultureResourceName }}',
'{{ dataConnectorName }}'
RETURNING
eTag,
properties,
systemData
;

DELETE examples

Delete a Data Connectors with given dataConnector name.

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