Skip to main content

integration_runtime_status

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

Overview

Nameintegration_runtime_status
TypeResource
Idazure.synapse.integration_runtime_status

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
namestringThe integration runtime name.
dataFactoryNamestringThe workspace name which the integration runtime belong to.
statestringThe state of integration runtime. Known values are: "Initial", "Stopped", "Started", "Starting", "Stopping", "NeedRegistration", "Online", "Limited", "Offline", and "AccessDenied".
typestringType of integration runtime. Required. Known values are: "Managed" and "SelfHosted".

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresource_group_name, workspace_name, integration_runtime_name, subscription_idGet integration runtime status. Get the integration runtime status.

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
integration_runtime_namestringIntegration runtime name. Required.
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
subscription_idstring
workspace_namestringThe name of the workspace. Required.

SELECT examples

Get integration runtime status. Get the integration runtime status.

SELECT
name,
dataFactoryName,
state,
type
FROM azure.synapse.integration_runtime_status
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND workspace_name = '{{ workspace_name }}' -- required
AND integration_runtime_name = '{{ integration_runtime_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;