vw_workspace_connections

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

Overview

Name	vw_workspace_connections
Type	View
Id	azure.ml_services.vw_workspace_connections

Fields

See the SQL Definition (view DDL) for fields returned by this view.

SQL Definition

Sqlite3

SELECT
id as id,
name as name,
type as type,
systemData as system_data,
JSON_EXTRACT(properties, '$.authType') as "auth_type",
JSON_EXTRACT(properties, '$.category') as "category",
JSON_EXTRACT(properties, '$.createdByWorkspaceArmId') as "created_by_workspace_arm_id",
JSON_EXTRACT(properties, '$.error') as "error",
JSON_EXTRACT(properties, '$.expiryTime') as "expiry_time",
JSON_EXTRACT(properties, '$.group') as "group",
JSON_EXTRACT(properties, '$.isSharedToAll') as "is_shared_to_all",
JSON_EXTRACT(properties, '$.metadata') as "metadata",
JSON_EXTRACT(properties, '$.peRequirement') as "pe_requirement",
JSON_EXTRACT(properties, '$.peStatus') as "pe_status",
JSON_EXTRACT(properties, '$.sharedUserList') as "shared_user_list",
JSON_EXTRACT(properties, '$.target') as "target",
JSON_EXTRACT(properties, '$.useWorkspaceManagedIdentity') as "use_workspace_managed_identity",
subscriptionId,
resourceGroupName,
workspaceName,
connectionName
FROM azure.ml_services.workspace_connections
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND workspaceName = 'replace-me';

Postgres

SELECT
id as id,
name as name,
type as type,
systemData as system_data,
json_extract_path_text(properties, '$.authType') as "auth_type",
json_extract_path_text(properties, '$.category') as "category",
json_extract_path_text(properties, '$.createdByWorkspaceArmId') as "created_by_workspace_arm_id",
json_extract_path_text(properties, '$.error') as "error",
json_extract_path_text(properties, '$.expiryTime') as "expiry_time",
json_extract_path_text(properties, '$.group') as "group",
json_extract_path_text(properties, '$.isSharedToAll') as "is_shared_to_all",
json_extract_path_text(properties, '$.metadata') as "metadata",
json_extract_path_text(properties, '$.peRequirement') as "pe_requirement",
json_extract_path_text(properties, '$.peStatus') as "pe_status",
json_extract_path_text(properties, '$.sharedUserList') as "shared_user_list",
json_extract_path_text(properties, '$.target') as "target",
json_extract_path_text(properties, '$.useWorkspaceManagedIdentity') as "use_workspace_managed_identity",
subscriptionId,
resourceGroupName,
workspaceName,
connectionName
FROM azure.ml_services.workspace_connections
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND workspaceName = 'replace-me';