iot_connectors

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

Overview

Name	iot_connectors
Type	Resource
Id	azure_extras.healthcare.iot_connectors

Fields

vw_iot_connectors

Name	Datatype	Description
device_mapping	text	field from the properties object
identity	text	Setting indicating whether the service has a managed identity associated with it.
ingestion_endpoint_configuration	text	field from the properties object
iotConnectorName	text	field from the properties object
provisioning_state	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
workspaceName	text	field from the properties object

iot_connectors

Name	Datatype	Description
identity	object	Setting indicating whether the service has a managed identity associated with it.
properties	object	IoT Connector properties.
systemData	object	Metadata pertaining to creation and last modification of the resource.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	iotConnectorName, resourceGroupName, subscriptionId, workspaceName	Gets the properties of the specified IoT Connector.
list_by_workspace	SELECT	resourceGroupName, subscriptionId, workspaceName	Lists all IoT Connectors for the given workspace
create_or_update	INSERT	iotConnectorName, resourceGroupName, subscriptionId, workspaceName	Creates or updates an IoT Connector resource with the specified parameters.
delete	DELETE	iotConnectorName, resourceGroupName, subscriptionId, workspaceName	Deletes an IoT Connector.
update	UPDATE	iotConnectorName, resourceGroupName, subscriptionId, workspaceName	Patch an IoT Connector.

SELECT examples

Lists all IoT Connectors for the given workspace

vw_iot_connectors

SELECT
device_mapping,
identity,
ingestion_endpoint_configuration,
iotConnectorName,
provisioning_state,
resourceGroupName,
subscriptionId,
system_data,
workspaceName
FROM azure_extras.healthcare.vw_iot_connectors
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceName = '{{ workspaceName }}';

iot_connectors

SELECT
identity,
properties,
systemData
FROM azure_extras.healthcare.iot_connectors
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceName = '{{ workspaceName }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure_extras.healthcare.iot_connectors (
iotConnectorName,
resourceGroupName,
subscriptionId,
workspaceName,
identity,
properties,
systemData
)
SELECT 
'{{ iotConnectorName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ workspaceName }}',
'{{ identity }}',
'{{ properties }}',
'{{ systemData }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: identity
      value:
        - name: type
          value: string
        - name: principalId
          value: string
        - name: tenantId
          value: string
        - name: userAssignedIdentities
          value: []
    - name: properties
      value:
        - name: provisioningState
          value: []
        - name: ingestionEndpointConfiguration
          value:
            - name: eventHubName
              value: string
            - name: consumerGroup
              value: string
            - name: fullyQualifiedEventHubNamespace
              value: string
        - name: deviceMapping
          value:
            - name: content
              value: object
    - 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 iot_connectors resource.

/*+ update */
UPDATE azure_extras.healthcare.iot_connectors
SET 
tags = '{{ tags }}',
identity = '{{ identity }}'
WHERE 
iotConnectorName = '{{ iotConnectorName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceName = '{{ workspaceName }}';

DELETE example

Deletes the specified iot_connectors resource.

/*+ delete */
DELETE FROM azure_extras.healthcare.iot_connectors
WHERE iotConnectorName = '{{ iotConnectorName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceName = '{{ workspaceName }}';