integration_runtime_nodes

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

Overview

Name	integration_runtime_nodes
Type	Resource
Id	azure.synapse.integration_runtime_nodes

Fields

The following fields are returned by SELECT queries:

get

Name	Datatype	Description
	object	Unmatched properties from the message are deserialized to this collection.
capabilities	object	The integration runtime capabilities dictionary.
concurrentJobsLimit	integer	Maximum concurrent jobs on the integration runtime node.
expiryTime	string (date-time)	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 (date-time)	The most recent time at which the integration runtime was connected in ISO8601 format.
lastEndUpdateTime	string (date-time)	The last time for the integration runtime node update end.
lastStartTime	string (date-time)	The time the node last started up.
lastStartUpdateTime	string (date-time)	The last time for the integration runtime node update start.
lastStopTime	string (date-time)	The integration runtime node last stop time.
lastUpdateResult	string	The result of the last integration runtime node update. Known values are: "None", "Succeed", and "Fail".
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 (date-time)	The time at which the integration runtime node was registered in ISO8601 format.
status	string	Status of the integration runtime node. Known values are: "NeedRegistration", "Online", "Limited", "Offline", "Upgrading", "Initializing", and "InitializeFailed".
version	string	Version of the integration runtime node.
versionStatus	string	Status of the integration runtime node version.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	resource_group_name, workspace_name, integration_runtime_name, node_name, subscription_id		Get integration runtime node. Get an integration runtime node.
update	update	resource_group_name, workspace_name, integration_runtime_name, node_name, subscription_id		Create integration runtime node. Create an integration runtime node.
delete	delete	resource_group_name, workspace_name, integration_runtime_name, node_name, subscription_id		Delete integration runtime node. Delete an 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.

Name	Datatype	Description
integration_runtime_name	string	Integration runtime name. Required.
node_name	string	Integration runtime node name. Required.
resource_group_name	string	The name of the resource group. The name is case insensitive. Required.
subscription_id	string
workspace_name	string	The name of the workspace. Required.

SELECT examples

get

Get integration runtime node. 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 resource_group_name = '{{ resource_group_name }}' -- required
AND workspace_name = '{{ workspace_name }}' -- required
AND integration_runtime_name = '{{ integration_runtime_name }}' -- required
AND node_name = '{{ node_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

UPDATE examples

update

Create integration runtime node. Create an integration runtime node.

UPDATE azure.synapse.integration_runtime_nodes
SET 
concurrentJobsLimit = {{ concurrentJobsLimit }}
WHERE 
resource_group_name = '{{ resource_group_name }}' --required
AND workspace_name = '{{ workspace_name }}' --required
AND integration_runtime_name = '{{ integration_runtime_name }}' --required
AND node_name = '{{ node_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
,
capabilities,
concurrentJobsLimit,
expiryTime,
hostServiceUri,
isActiveDispatcher,
lastConnectTime,
lastEndUpdateTime,
lastStartTime,
lastStartUpdateTime,
lastStopTime,
lastUpdateResult,
machineName,
maxConcurrentJobs,
nodeName,
registerTime,
status,
version,
versionStatus;

DELETE examples

delete

Delete integration runtime node. Delete an integration runtime node.

DELETE FROM azure.synapse.integration_runtime_nodes
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND workspace_name = '{{ workspace_name }}' --required
AND integration_runtime_name = '{{ integration_runtime_name }}' --required
AND node_name = '{{ node_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;