data_connectors

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

Overview

Name	data_connectors
Type	Resource
Id	azure_extras.ag_food_platform.data_connectors

Fields

vw_data_connectors

Name	Datatype	Description
credentials	text	field from the properties object
dataConnectorName	text	field from the properties object
dataManagerForAgricultureResourceName	text	field from the properties object
e_tag	text	field from the properties object
resourceGroupName	text	field from the properties object
subscriptionId	text	field from the properties object
system_data	text	field from the properties object

data_connectors

Name	Datatype	Description
eTag	string	The ETag value to implement optimistic concurrency.
properties	object	DataConnector Properties.
systemData	object	Metadata pertaining to creation and last modification of the resource.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	dataConnectorName, dataManagerForAgricultureResourceName, resourceGroupName, subscriptionId	Get specific Data Connector resource by DataConnectorName.
list	SELECT	dataManagerForAgricultureResourceName, resourceGroupName, subscriptionId	Lists the Data Connector Credentials for MADMA instance.
create_or_update	INSERT	dataConnectorName, dataManagerForAgricultureResourceName, resourceGroupName, subscriptionId, data__properties	Create or update Data Connector For MADMA resource.
delete	DELETE	dataConnectorName, dataManagerForAgricultureResourceName, resourceGroupName, subscriptionId	Delete a Data Connectors with given dataConnector name.

SELECT examples

Lists the Data Connector Credentials for MADMA instance.

vw_data_connectors

SELECT
credentials,
dataConnectorName,
dataManagerForAgricultureResourceName,
e_tag,
resourceGroupName,
subscriptionId,
system_data
FROM azure_extras.ag_food_platform.vw_data_connectors
WHERE dataManagerForAgricultureResourceName = '{{ dataManagerForAgricultureResourceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

data_connectors

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

INSERT example

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

All Properties

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

Manifest

- name: your_resource_model_name
  props:
    - 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
    - name: properties
      value:
        - name: credentials
          value:
            - name: kind
              value: []
    - name: eTag
      value: string

DELETE example

Deletes the specified data_connectors resource.

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