integration_runtime_nodes

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

Overview

Name	integration_runtime_nodes
Type	Resource
Id	azure.synapse.integration_runtime_nodes

Fields

Name	Datatype	Description
capabilities	object	The integration runtime capabilities dictionary
concurrentJobsLimit	integer	Maximum concurrent jobs on the integration runtime node.
expiryTime	string	The time at which the integration runtime will expire in ISO8601 format.
hostServiceUri	string	URI for the host machine of the integration runtime.
isActiveDispatcher	boolean	Indicates whether this node is the active dispatcher for integration runtime requests.
lastConnectTime	string	The most recent time at which the integration runtime was connected in ISO8601 format.
lastEndUpdateTime	string	The last time for the integration runtime node update end.
lastStartTime	string	The time the node last started up.
lastStartUpdateTime	string	The last time for the integration runtime node update start.
lastStopTime	string	The integration runtime node last stop time.
lastUpdateResult	string	The result of the last integration runtime node update.
machineName	string	Machine name of the integration runtime node.
maxConcurrentJobs	integer	The maximum concurrent jobs in this integration runtime.
nodeName	string	Name of the integration runtime node.
registerTime	string	The time at which the integration runtime node was registered in ISO8601 format.
status	string	Status of the integration runtime node.
version	string	Version of the integration runtime node.
versionStatus	string	Status of the integration runtime node version.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	integrationRuntimeName, nodeName, resourceGroupName, subscriptionId, workspaceName	Get an integration runtime node
delete	DELETE	integrationRuntimeName, nodeName, resourceGroupName, subscriptionId, workspaceName	Delete an integration runtime node
update	UPDATE	integrationRuntimeName, nodeName, resourceGroupName, subscriptionId, workspaceName	Create an integration runtime node

SELECT examples

Get an integration runtime node

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

UPDATE example

Updates a integration_runtime_nodes resource.

/*+ update */
UPDATE azure.synapse.integration_runtime_nodes
SET 
concurrentJobsLimit = '{{ concurrentJobsLimit }}'
WHERE 
integrationRuntimeName = '{{ integrationRuntimeName }}'
AND nodeName = '{{ nodeName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceName = '{{ workspaceName }}';

DELETE example

Deletes the specified integration_runtime_nodes resource.

/*+ delete */
DELETE FROM azure.synapse.integration_runtime_nodes
WHERE integrationRuntimeName = '{{ integrationRuntimeName }}'
AND nodeName = '{{ nodeName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceName = '{{ workspaceName }}';