workspace_managed_identity_sql_control_settings

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

Overview

Name	workspace_managed_identity_sql_control_settings
Type	Resource
Id	azure.synapse.workspace_managed_identity_sql_control_settings

Fields

The following fields are returned by SELECT queries:

get

Name	Datatype	Description
properties	object	Sql Control Settings for workspace managed identity (title: Managed Identity Sql Control Settings)

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	subscriptionId, resourceGroupName, workspaceName
create_or_update	insert	subscriptionId, resourceGroupName, workspaceName

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
resourceGroupName	string	The name of the resource group. The name is case insensitive.
subscriptionId	string	The ID of the target subscription.
workspaceName	string	The name of the workspace.

SELECT examples

get

OK

SELECT
properties
FROM azure.synapse.workspace_managed_identity_sql_control_settings
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND workspaceName = '{{ workspaceName }}' -- required
;

INSERT examples

create_or_update

No description available.

INSERT INTO azure.synapse.workspace_managed_identity_sql_control_settings (
data__properties,
subscriptionId,
resourceGroupName,
workspaceName
)
SELECT 
'{{ properties }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ workspaceName }}'
RETURNING
properties
;

Manifest

# Description fields are for documentation purposes
- name: workspace_managed_identity_sql_control_settings
  props:
    - name: subscriptionId
      value: string
      description: Required parameter for the workspace_managed_identity_sql_control_settings resource.
    - name: resourceGroupName
      value: string
      description: Required parameter for the workspace_managed_identity_sql_control_settings resource.
    - name: workspaceName
      value: string
      description: Required parameter for the workspace_managed_identity_sql_control_settings resource.
    - name: properties
      value: object
      description: |
        Sql Control Settings for workspace managed identity