data_lake_connectors

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

Overview

Name	data_lake_connectors
Type	Resource
Id	azure.iot_mq.data_lake_connectors

Fields

vw_data_lake_connectors

Name	Datatype	Description
dataLakeConnectorName	text	field from the properties object
database_format	text	field from the properties object
extended_location	text	field from the properties object
image	text	field from the properties object
instances	text	field from the properties object
local_broker_connection	text	field from the properties object
location	text	The geo-location where the resource lives
log_level	text	field from the properties object
mqName	text	field from the properties object
node_tolerations	text	field from the properties object
protocol	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
tags	text	Resource tags.
target	text	field from the properties object

data_lake_connectors

Name	Datatype	Description
extendedLocation	object	ExtendedLocation properties
location	string	The geo-location where the resource lives
properties	object	MQ DataLakeConnector Resource properties
tags	object	Resource tags.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	dataLakeConnectorName, mqName, resourceGroupName, subscriptionId	Get a DataLakeConnectorResource
list_by_mq_resource	SELECT	mqName, resourceGroupName, subscriptionId	List DataLakeConnectorResource resources by MqResource
create_or_update	INSERT	dataLakeConnectorName, mqName, resourceGroupName, subscriptionId, data__extendedLocation	Create a DataLakeConnectorResource
delete	DELETE	dataLakeConnectorName, mqName, resourceGroupName, subscriptionId	Delete a DataLakeConnectorResource
update	UPDATE	dataLakeConnectorName, mqName, resourceGroupName, subscriptionId	Update a DataLakeConnectorResource

SELECT examples

List DataLakeConnectorResource resources by MqResource

vw_data_lake_connectors

SELECT
dataLakeConnectorName,
database_format,
extended_location,
image,
instances,
local_broker_connection,
location,
log_level,
mqName,
node_tolerations,
protocol,
provisioning_state,
resourceGroupName,
subscriptionId,
tags,
target
FROM azure.iot_mq.vw_data_lake_connectors
WHERE mqName = '{{ mqName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

data_lake_connectors

SELECT
extendedLocation,
location,
properties,
tags
FROM azure.iot_mq.data_lake_connectors
WHERE mqName = '{{ mqName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.iot_mq.data_lake_connectors (
dataLakeConnectorName,
mqName,
resourceGroupName,
subscriptionId,
data__extendedLocation,
properties,
extendedLocation,
tags,
location
)
SELECT 
'{{ dataLakeConnectorName }}',
'{{ mqName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ data__extendedLocation }}',
'{{ properties }}',
'{{ extendedLocation }}',
'{{ tags }}',
'{{ location }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: databaseFormat
          value: []
        - name: image
          value:
            - name: pullPolicy
              value: string
            - name: pullSecrets
              value: string
            - name: repository
              value: string
            - name: tag
              value: string
        - name: instances
          value: integer
        - name: localBrokerConnection
          value:
            - name: authentication
              value:
                - name: kubernetes
                  value:
                    - name: secretPath
                      value: string
                    - name: serviceAccountTokenName
                      value: string
            - name: endpoint
              value: string
            - name: tls
              value:
                - name: tlsEnabled
                  value: boolean
                - name: trustedCaCertificateConfigMap
                  value: string
        - name: logLevel
          value: string
        - name: nodeTolerations
          value:
            - name: effect
              value: string
            - name: key
              value: string
            - name: operator
              value: string
            - name: value
              value: string
        - name: protocol
          value: []
        - name: target
          value:
            - name: datalakeStorage
              value:
                - name: endpoint
                  value: string
                - name: authentication
                  value:
                    - name: accessTokenSecretName
                      value: string
                    - name: systemAssignedManagedIdentity
                      value:
                        - name: audience
                          value: string
                        - name: extensionName
                          value: string
            - name: localStorage
              value:
                - name: volumeName
                  value: string
            - name: fabricOneLake
              value:
                - name: authentication
                  value: []
                - name: endpoint
                  value: string
                - name: fabricPath
                  value: []
                - name: guids
                  value:
                    - name: lakehouseGuid
                      value: string
                    - name: workspaceGuid
                      value: string
                - name: names
                  value:
                    - name: lakehouseName
                      value: string
                    - name: workspaceName
                      value: string
        - name: provisioningState
          value: []
    - name: extendedLocation
      value:
        - name: name
          value: string
        - name: type
          value: []
    - name: tags
      value: object
    - name: location
      value: string

UPDATE example

Updates a data_lake_connectors resource.

/*+ update */
UPDATE azure.iot_mq.data_lake_connectors
SET 
tags = '{{ tags }}',
properties = '{{ properties }}'
WHERE 
dataLakeConnectorName = '{{ dataLakeConnectorName }}'
AND mqName = '{{ mqName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified data_lake_connectors resource.

/*+ delete */
DELETE FROM azure.iot_mq.data_lake_connectors
WHERE dataLakeConnectorName = '{{ dataLakeConnectorName }}'
AND mqName = '{{ mqName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';