Skip to main content

integration_runtime_nodes

Creates, updates, deletes, gets or lists an integration_runtime_nodes resource.

Overview

Nameintegration_runtime_nodes
TypeResource
Idazure.data_factory.integration_runtime_nodes

Fields

The following fields are returned by SELECT queries:

OK.

NameDatatypeDescription
capabilitiesobjectThe integration runtime capabilities dictionary
concurrentJobsLimitintegerMaximum concurrent jobs on the integration runtime node.
expiryTimestring (date-time)The time at which the integration runtime will expire in ISO8601 format.
hostServiceUristringURI for the host machine of the integration runtime.
isActiveDispatcherbooleanIndicates whether this node is the active dispatcher for integration runtime requests.
lastConnectTimestring (date-time)The most recent time at which the integration runtime was connected in ISO8601 format.
lastEndUpdateTimestring (date-time)The last time for the integration runtime node update end.
lastStartTimestring (date-time)The time the node last started up.
lastStartUpdateTimestring (date-time)The last time for the integration runtime node update start.
lastStopTimestring (date-time)The integration runtime node last stop time.
lastUpdateResultstringThe result of the last integration runtime node update.
machineNamestringMachine name of the integration runtime node.
maxConcurrentJobsintegerThe maximum concurrent jobs in this integration runtime.
nodeNamestringName of the integration runtime node.
registerTimestring (date-time)The time at which the integration runtime node was registered in ISO8601 format.
statusstringStatus of the integration runtime node.
versionstringVersion of the integration runtime node.
versionStatusstringStatus of the integration runtime node version.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, factoryName, integrationRuntimeName, nodeNameapi-versionGets a self-hosted integration runtime node.
updateupdatesubscriptionId, resourceGroupName, factoryName, integrationRuntimeName, nodeNameapi-versionUpdates a self-hosted integration runtime node.
deletedeletesubscriptionId, resourceGroupName, factoryName, integrationRuntimeName, nodeNameapi-versionDeletes a self-hosted integration runtime node.

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
factoryNamestringThe factory name.
integrationRuntimeNamestringThe integration runtime name.
nodeNamestringThe integration runtime node name.
resourceGroupNamestringThe resource group name.
subscriptionIdstringThe subscription identifier.
api-versionstringThe API version.

SELECT examples

Gets a self-hosted integration runtime node.

SELECT
capabilities,
concurrentJobsLimit,
expiryTime,
hostServiceUri,
isActiveDispatcher,
lastConnectTime,
lastEndUpdateTime,
lastStartTime,
lastStartUpdateTime,
lastStopTime,
lastUpdateResult,
machineName,
maxConcurrentJobs,
nodeName,
registerTime,
status,
version,
versionStatus
FROM azure.data_factory.integration_runtime_nodes
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND factoryName = '{{ factoryName }}' -- required
AND integrationRuntimeName = '{{ integrationRuntimeName }}' -- required
AND nodeName = '{{ nodeName }}' -- required
AND api-version = '{{ api-version }}'
;

UPDATE examples

Updates a self-hosted integration runtime node.

UPDATE azure.data_factory.integration_runtime_nodes
SET
data__concurrentJobsLimit = {{ concurrentJobsLimit }}
WHERE
subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND factoryName = '{{ factoryName }}' --required
AND integrationRuntimeName = '{{ integrationRuntimeName }}' --required
AND nodeName = '{{ nodeName }}' --required
AND api-version = '{{ api-version}}'
RETURNING
capabilities,
concurrentJobsLimit,
expiryTime,
hostServiceUri,
isActiveDispatcher,
lastConnectTime,
lastEndUpdateTime,
lastStartTime,
lastStartUpdateTime,
lastStopTime,
lastUpdateResult,
machineName,
maxConcurrentJobs,
nodeName,
registerTime,
status,
version,
versionStatus;

DELETE examples

Deletes a self-hosted integration runtime node.

DELETE FROM azure.data_factory.integration_runtime_nodes
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND factoryName = '{{ factoryName }}' --required
AND integrationRuntimeName = '{{ integrationRuntimeName }}' --required
AND nodeName = '{{ nodeName }}' --required
AND api-version = '{{ api-version }}'
;