Skip to main content

workspace_connections

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

Overview

Nameworkspace_connections
TypeResource
Idazure.machine_learning_services.workspace_connections

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringResourceId of the workspace connection.
namestringFriendly name of the workspace connection.
authTypestringAuthorization type of the workspace connection.
categorystringCategory of the workspace connection.
targetstringTarget of the workspace connection.
typestringResource type of workspace connection.
valuestringValue details of the workspace connection.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresource_group_name, workspace_name, connection_name, subscription_idGet the detail of a workspace connection.
listselectresource_group_name, workspace_name, subscription_idtarget, categoryList all connections under a AML workspace.
createinsertresource_group_name, workspace_name, connection_name, subscription_idAdd a new workspace connection.
deletedeleteresource_group_name, workspace_name, connection_name, subscription_idDelete a workspace connection.

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
connection_namestringFriendly name of the workspace connection. Required.
resource_group_namestringName of the resource group in which workspace is located. Required.
subscription_idstring
workspace_namestringName of Azure Machine Learning workspace. Required.
categorystringCategory of the workspace connection. Default value is None.
targetstringTarget of the workspace connection. Default value is None.

SELECT examples

Get the detail of a workspace connection.

SELECT
id,
name,
authType,
category,
target,
type,
value
FROM azure.machine_learning_services.workspace_connections
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND workspace_name = '{{ workspace_name }}' -- required
AND connection_name = '{{ connection_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Add a new workspace connection.

INSERT INTO azure.machine_learning_services.workspace_connections (
name,
properties,
resource_group_name,
workspace_name,
connection_name,
subscription_id
)
SELECT
'{{ name }}',
'{{ properties }}',
'{{ resource_group_name }}',
'{{ workspace_name }}',
'{{ connection_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
properties,
type
;

DELETE examples

Delete a workspace connection.

DELETE FROM azure.machine_learning_services.workspace_connections
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND workspace_name = '{{ workspace_name }}' --required
AND connection_name = '{{ connection_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;