Skip to main content

data_lake_connectors

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

Overview

Namedata_lake_connectors
TypeResource
Idazure.iot_mq.data_lake_connectors

Fields

The following fields are returned by SELECT queries:

Azure operation completed successfully.

NameDatatypeDescription
extendedLocationobjectExtended Location
locationstringThe geo-location where the resource lives
propertiesobjectThe resource-specific properties for this resource.
tagsobjectResource tags.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, mqName, dataLakeConnectorNameGet a DataLakeConnectorResource
list_by_mq_resourceselectsubscriptionId, resourceGroupName, mqNameList DataLakeConnectorResource resources by MqResource
create_or_updateinsertsubscriptionId, resourceGroupName, mqName, dataLakeConnectorName, data__extendedLocationCreate a DataLakeConnectorResource
updateupdatesubscriptionId, resourceGroupName, mqName, dataLakeConnectorNameUpdate a DataLakeConnectorResource
deletedeletesubscriptionId, resourceGroupName, mqName, dataLakeConnectorNameDelete a DataLakeConnectorResource

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
dataLakeConnectorNamestringName of MQ dataLakeConnector resource
mqNamestringName of MQ resource
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
subscriptionIdstringThe ID of the target subscription.

SELECT examples

Get a DataLakeConnectorResource

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

INSERT examples

Create a DataLakeConnectorResource

INSERT INTO azure.iot_mq.data_lake_connectors (
data__properties,
data__extendedLocation,
data__tags,
data__location,
subscriptionId,
resourceGroupName,
mqName,
dataLakeConnectorName
)
SELECT
'{{ properties }}',
'{{ extendedLocation }}' /* required */,
'{{ tags }}',
'{{ location }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ mqName }}',
'{{ dataLakeConnectorName }}'
RETURNING
extendedLocation,
location,
properties,
tags
;

UPDATE examples

Update a DataLakeConnectorResource

UPDATE azure.iot_mq.data_lake_connectors
SET
data__tags = '{{ tags }}',
data__properties = '{{ properties }}'
WHERE
subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND mqName = '{{ mqName }}' --required
AND dataLakeConnectorName = '{{ dataLakeConnectorName }}' --required
RETURNING
extendedLocation,
location,
properties,
tags;

DELETE examples

Delete a DataLakeConnectorResource

DELETE FROM azure.iot_mq.data_lake_connectors
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND mqName = '{{ mqName }}' --required
AND dataLakeConnectorName = '{{ dataLakeConnectorName }}' --required
;